### Excel Magic Trick 1276

March 6, 2017

DESCRIPTION Impossible: Excel Online Absolute Cell References? How do you make a Cell Reference Absolute in Excel Online? WORKBOOKS

### Remove The Excel 2013 Start-up Screen

March 5, 2017

When you start Excel 2013 you are taken to the new start-up screen. This can prove very useful if you want to open a workbook you recently used or want to open a template. There […]

### Start With More Than One Worksheet

March 4, 2017

When you create a new workbook in Excel 2013 a single blank worksheet is added for you and named Sheet1. This is different from previous versions of Excel where by default you were given three […]

### Worksheet Tabs

March 4, 2017

Each worksheet has a tab at the bottom of the workbook which contains the name of the worksheet. By default Excel names a new worksheet “Sheet1” if you add another this is named “Sheet2” and […]

### Highline Excel 2013 Class Video 25

March 3, 2017

DESCRIPTION Topics in this video: 1. Goal Seek: Get Formula To Evaluate To Desired Result 2. Goal Seek: Keyboard: Alt T, G 3. Set Cell: Contains a formula with a formula input you want to […]

### Excel Magic Trick 1275

March 2, 2017

DESCRIPTION Excel Online Office 365 MAXIFS function Learn how to find the biggest value based on a condition or criteria. New features released in these versions: 1. Office 365 Online Excel OR 2. Office 365 […]

### Worksheet Basics

March 2, 2017

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 […]

### View Multiple Worksheets

March 1, 2017

In this example we have two worksheets in our workbook. We want to view both worksheets on the same screen. Here are four easy steps to execute this…. Step 1 On the View tab click […]

### Dueling Excel 131

March 1, 2017

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP […]