Excel 2010 Training - Beginner to Advanced
Comprehensive and structured Excel 2010 training for beginners through to advanced users
This course will guide you through the features and functions of Microsoft Excel 2010. This structured training course is designed to teach new and experienced users how to get the most out of Microsoft Excel 2010!
Become an Excel Whiz today!
Course Curriculum
Introducing Excel 2010
Available in
days
days
after you enroll
Excel 2010 Basics
Available in
days
days
after you enroll
-
StartCreating and saving a new workbook (4:39)
-
StartWorking with the Format Painter (3:14)
-
StartOpening an existing workbook (1:35)
-
StartCreating a new workbook from a template (5:01)
-
StartSaving a workbook as a template (3:41)
-
StartUnderstanding the Number Group commands (6:32)
-
StartOpening a workbook using different options (5:25)
-
StartUsing SAVE AS to create a new workbook (1:30)
-
StartSaving an Excel 2010 workbook in Excel 2003 format (2:28)
-
StartSaving a workbook as a PDF file (2:33)
-
StartSaving a workbook in web page format (HTML) (3:50)
-
StartPrinting workbooks (4:30)
-
StartUnderstanding text versus numeric cell entries (5:39)
-
StartIntroducing the Quick Access Toolbar (6:43)
-
StartHow to minimise the Office Ribbon (2:40)
-
StartNavigating the Office Ribbon using the keyboard (3:45)
-
StartNavigating around worksheets using the keyboard (5:18)
-
StartManaging worksheets (4:17)
-
StartIntroducing the Mini Toolbar (3:37)
-
StartGetting to know the Formula Bar (5:35)
-
StartHow to select cells in different ways (4:49)
-
StartResizing rows and columns (2:13)
-
StartUsing AutoCorrect (2:51)
-
StartUsing AutoComplete (2:24)
-
StartUsing AutoFill (6:49)
-
StartInserting and deleting cells, rows and columns (3:25)
-
StartA closer look at Cut, Copy and Paste (7:34)
-
StartUnderstanding Excel Operators (5:46)
-
StartA refresher course in the Order of Operations - BODMAS (4:46)
-
StartMulti-User editing using the new Office Web Apps (3:50)
Controlling Information and Worksheets
Available in
days
days
after you enroll
-
StartGetting the most from the Office Clipboard (7:42)
-
StartUnderstanding the Font Group commands (5:03)
-
StartUnderstanding the Alignment Group commands (2:43)
-
StartMerging cells and wrapping text entries (4:56)
-
StartIntroducing Conditional Formatting (9:08)
-
StartWorking with Table Styles (5:14)
-
StartTable Style formatting options (5:21)
-
StartWorking with Cell Styles (5:16)
-
StartIntroducing Sparklines (8:49)
-
StartAdjusting rows and columns using the Office Ribbon (4:36)
-
StartHow to Hide and Unhide rows, columns and worksheets (3:25)
-
StartManaging worksheets using the Office Ribbon (1:38)
-
StartRemoving cell contents and formatting (3:24)
-
StartSorting and filtering information (6:01)
-
StartUsing the Find and Replace tools (7:57)
-
StartUsing the Select Objects tool (2:50)
-
StartWorking with the Selection Pane (4:08)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Are Certificates of Completion available after I have finished the course?
Of course! Once you have completed the course a Certificate of Completion will be sent to your email address.
Is this course suitable for beginners?
Absolutely. This course begins with the very basics of Microsoft Excel 2010. From there we slowly and clearly build on these skills, one step at a time. In no time at all you will be using the more powerful and interesting features of Excel 2010!
How many times can I look at this training course?
As many times as you like while you have a valid subscription. You should check out our 12 month subscription option - it is the best value and it allows you to come back and do a refresher at any time during the year.
How do I get access to this course?
Subscribe to the VideoTraining Course Library and you will get access to all the courses on our website.
Subscribe to the VideoTraining Course Library to Get Access to This Course!