Excel Is Fun

Excel Magic Trick 1276

March 6, 2017 0

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

GETTING STARTED IN EXCEL

Remove The Excel 2013 Start-up Screen

March 5, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Start With More Than One Worksheet

March 4, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Worksheet Tabs

March 4, 2017 0

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 […]

Excel Is Fun

Highline Excel 2013 Class Video 25

March 3, 2017 0

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 Is Fun

Excel Magic Trick 1275

March 2, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

Worksheet Basics

March 2, 2017 0

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 […]

WORKBOOKS & WORKSHEETS

View Multiple Worksheets

March 1, 2017 0

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

Dueling Excel 131

March 1, 2017 0

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 […]

THE RIBBON

Customise The Quick Access Toolbar

February 28, 2017 0

The Ribbon is easily accessible for most commands, but you can also add command shortcuts for easier access in the Quick Access Toolbar which is located in the top left corner of the Excel Workbook. […]