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
Micro How to VBA… Convert Numbers to their Alphanumeric Value
Open VBA, create a new module, and create a new function as follows. This gives you access to a function in the Excel front-end called Alphabetise, that takes the number to convert as its argument. It converts from A to AZ.
Keep reading
How to… Consolidate Quarterly or Monthly Data Using Power Query
Do you get regular data files that you need to consolidate/compile together for a report or dashboard? This method will help you keep your reporting files lightweight and portable, while making updating their data as easy as pressing Refresh. The basics can be done in five easy steps. For our…
Keep reading
Loading…
Something went wrong. Please refresh the page and/or try again.
Static Interest 