Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #7

May 7, 2015 0

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

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #6

May 6, 2015 0

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.

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #5

May 5, 2015 0

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

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #4

May 4, 2015 0

DESCRIPTION This Excel 2010 tutorial shows various ways of using the AutoSum function including editing and copying functions.

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #3

May 3, 2015 0

DESCRIPTION This Excel 2010 tutorial, for beginners, covers the creation of basic calculations and a few tips on getting Excel to create calculations automatically.

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #2

May 2, 2015 0

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.

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #1

May 1, 2015 0

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.

Excel Is Fun

Excel Magic Trick 1130

April 30, 2015 0

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

Excel Is Fun

Excel Magic Trick 1129

April 29, 2015 0

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