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

Excel Is Fun

Excel Magic Trick 1274

February 27, 2017 0

DESCRIPTION Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a […]

WORKBOOKS & WORKSHEETS

Microsoft Excel Workbook Formats

February 26, 2017 0

In Excel 2007 Microsoft introduced a new file format, Office Open XML which allows other programs to easily work with Excel workbooks. Listed below is a list of the most common file formats you will […]

WORKBOOKS & WORKSHEETS

Pin A Workbook

February 25, 2017 1

A quick way of opening workbooks you use most frequently is to pin them to the Recent list that is displayed when you first start Excel 2013 or when you click FILE from the file […]

Excel Is Fun

Highline Excel 2013 Class Video 24

February 24, 2017 0

Getting Top 5 Values With LARGE And Bottom 5 With SMALL DESCRIPTION Topics in this video: 1. Getting Top five values with LARGE and ROWS 2. Getting Bottom five values with SMALL and ROWS WORKBOOKS

Excel Is Fun

Excel Magic Trick 1273

February 23, 2017 0

DESCRIPTION Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins Learn how to use the Get External Data Feature, Web Query to get Super Bowl data. Then make two PivotTables to […]

Dueling Excel

Dueling Excel 130

February 22, 2017 0

DESCRIPTION Text Formula To Show Calculation (Not Formula) From A Cell See Mr Excel and excelisfun use two methods to show formula calculation in a cell: 1. Use Ampersand (Join Symbol), Text in Double Quotes, […]

Excel VBA

Find The Last Occupied Row

February 21, 2017 0

You can use the following code to find the last row in a worksheet that contains data and assign it to a variable. If you use or are planning to use VBA frequently then it […]

Excel Is Fun

Excel Magic Trick 1272

February 20, 2017 0

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]