Download & Install Power Query for Data Transformation Tools
DESCRIPTION This updated tutorial shows how to apply Formatting to your worksheet including basic highlighting of text and numbers and applying colours. There is also a quick look at Print Preview and how to apply […]
DESCRIPTION This updated tutorial shows how to apply basic number formats in Excel 2010. Currency, comma and percentage formats are demonstrated along with the useful Format Painter.
DESCRIPTION This updated tutorial shows how to use the following functions: AVERAGE, MAX, MIN and COUNT. The tutorial also shows how to create these functions in a variety of ways, including from the Functions tab […]
DESCRIPTION This Excel 2010 tutorial shows various ways of using the AutoSum function including editing and copying functions.
DESCRIPTION This Excel 2010 tutorial, for beginners, covers the creation of basic calculations and a few tips on getting Excel to create calculations automatically.
DESCRIPTION This Excel 2010 tutorial covers the set up of a simple spreadsheet with entry of text and numbers. The tutorial also shows how to edit and delete entries and simple spreadsheet navigation.
DESCRIPTION In this updated tutorial for Excel 2010 users learn how to create a simple spreadsheet in Excel 2010 (also applies to Excel 2007 & Excel 2013), complete with formatting, calculations and a chart.
DESCRIPTION See how to create an Ageing Accounts Receivable Reports Using Advanced Filter: (00:27) Helper Column. The correct formula for Days Late is: =TODAY()-D8 (00:49) Sort to bring largest to top (01:10) Criteria Area (01:40) […]
DESCRIPTION See how to create Ageing Accounts Receivable Reports using Slicer, Excel Table Feature and formulas: (00:09) Overview (01:05) Text Formula For Reporting Categories in Lookup Table (01:59) Days Late Formula. The correct formula for […]