Excel Basics

Course details

• Detailed supporting Excel workbooks and section specific quizzes to give you a thorough base in Excel
• Learn how to master Worksheets, Formatting, Formulas, Charts, Sorting & Filtering Data, Charts and Printing
• Lean the basic skills that provide a foundation to build advanced Excel skills as you develop throughout your career… 

This course will provide a comprehensive foundation of basic Excel skills. Learn how to master the Excel Basics that will impress your colleagues and help you hit the career heights that you deserve.

David Millard will guide you through the Excel Basics that will enable you to manipulate data on the world's most popular spreadsheet software with ease. David is a Microsoft Master Instructor who was granted Microsoft Certified Trainer status in 2009, and he has designed this course to help students of all abilities to master the foundations of Excel. With detailed sections on worksheets, charts, formulas and much more by the end of this course you will feel totally in control using Excel.

It is time to turn your Excel weakness into a strength. Take this course today to unlock your career potential through Excel.

• Intro
• Say hi to your fellow students!
• Share your new course with your friends!
• Welcome to Excel Basics

• The Excel Interface
• Creating a New Workbook… 
• Pointer Shapes
• Opening and Closing Workbooks
• Excel Download - Workbooks Lesson 1
• Excel Download - Workbooks Lesson 2
• Moving around with Keyboard and Mouse
• Excel Download - Moving around with Keyboard and Mouse
• Opening Multiple Workbooks
• Excel Download - Opening Multiple Workbooks: January 1
• Excel Download - Opening Multiple Workbooks: January 2
• Renaming Sheets
• Excel Download - Renaming Sheets
• Copying and Moving Sheets
• Excel Download - Copying and Moving Sheets
• Inserting and Deleting Sheets
• Excel Download - Inserting and Deleting Sheets
• Changing Sheet Tab Colours
• Excel Download - Changing Sheet Tab Colours
• Copying and Moving Cells
• Excel Download - Copying and Moving Cells
• Copying and Moving by Dragging
• Excel Download - Copying and Moving by Dragging
• Using the Fill Handle

• Inserting Rows and Columns
• Excel Download - Inserting Rows and Columns
• Deleting Rows and Columns
• Excel Download - Deleting Rows and Columns
• Hiding Rows and Columns
• Excel Download - Hiding Rows and Columns
• Adjusting Column Widths
• Excel Download - Adjusting Column Widths
• Adjusting Row Height
• Excel Download - Adjusting Row Height
• Copying by Using the Fill Handle
• Excel Download - Copying by Using the Fill Handle
• Copying Using the Shortcut Menus
• Excel Download - Copying Using the Shortcut Menus

• Selection Methods… 
• Cell Alignment
• Excel Download - Cell Alignment
• The Format Painter
• Excel Download - the Format Painter
• Simple Formatting
• Excel Download - Simple Formatting
• Fonts, Font Size and Font Colour
• Excel Download - Fonts, Font Size and Font Colour
• Cell Borders
• Cell Patterns
• Excel Download - Cell Patterns

• Introduction to Formulas and Functions
• Excel Download - Introduction to Formulas and Functions: Using Excel to Calculate
• Invoice Walkthrough
• Absolute Cell References
• Functions
• Named Ranges
• Outlining

• Sorting
• Filtering
• Excel Download - Sorting and Filtering
• Tables
• Excel Download - Tables

• Inserting Charts in Excel 2010
• Adding Charts in Excel 2013
• Excel Download - Inserting Charts in Excel 2010 and 2013
• Sparklines
• Excel Download - Sparklines

• Setting and Clearing a Print Area… 
• Excel Download - Setting and Clearing a Print Area
• Page Breaks and Column Headers
• Excel Download - Page Breaks and Column Headers

• Part 1
• Part 2
• Part 3
• Part 4
• Part 5
• Part 6
• Part 7