Blog

Advertisements

Doing the Basics: Worksheets

A workbook is simply the name for an Excel file. When you open Excel, clicking on Blank workbook will create a new Excel workbook for you to begin working with. You can also open an existing workbook, to pick up where you left off.

Keep reading

Doing the Basics: Workbooks

A workbook is simply the name for an Excel file. When you open Excel, clicking on Blank workbook will create a new Excel workbook for you to begin working with. You can also open an existing workbook, to pick up where you left off.

Keep reading

How to… Use INDEX and MATCH

Index and Match are a powerful method to look-up data from a table, in a similar way to a VLOOKUP or its sibling formula, HLOOKUP. Using INDEX and MATCH together allows you to look-up data in a more flexible manner, and in a way that prevents the breaking of formulae…

Keep reading

Loading…

Something went wrong. Please refresh the page and/or try again.

Advertisements