Dueling Excel

Dueling Excel 125

January 18, 2017 0

DESCRIPTION Conditional Formatting Date Four Days Old & Not Paid See Mr Excel and excelisfun use two methods to Conditional Formatting Date That is Four Or More Days Old & Not Paid 1. Conditional Formatting […]

Excel Is Fun

Excel Magic Trick 1262

January 16, 2017 0

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT […]

Excel Is Fun

Excel Magic Trick 1261

January 12, 2017 0

DESCRIPTION Flash Fill to Add Spaces to Credit Card Numbers Learn how to use Flash Fill to Add Spaces to Credit Card Numbers. WORKBOOKS

Dueling Excel

Dueling Excel 124

January 11, 2017 0

DESCRIPTION Dynamic Stacked Line Chart See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. NA error Trick […]

Excel Is Fun

Excel Magic Trick 1260

January 9, 2017 0

DESCRIPTION VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table: (00:12) Problem setup. (00:49) […]

GETTING STARTED IN EXCEL

Starting Microsoft Excel

January 7, 2017 0

In the following example we are using Windows 7. 1. Click the Windows Start button 2. Click All Programs 3. Click on the Microsoft Office folder 4. Click Microsoft Excel Pin Microsoft Excel to the […]

Excel Is Fun

Excel Magic Trick 1259

January 5, 2017 0

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP […]

WORKBOOKS & WORKSHEETS

View Multiple Workbooks

January 5, 2017 0

This tutorial will show you how to quickly navigate between active workbooks or display multiple active workbooks on the same screen. In this example we have two active workbooks: Book1 and Book2. View Side by […]

Dueling Excel

Dueling Excel 123

January 4, 2017 0

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. […]

Tricks & Tips

Using AutoCorrect For Shorthand Data Entry

January 3, 2017 0

You can use the AutoCorrect feature to create shortcuts for commonly used words or phrases. For example if you find yourself regularly typing a company name e.g. MasterExcel.net you can create an AutoCorrect entry for […]