This course covers basic information about Microsoft Excel including terminology, navigation, formatting, formulas, functions, database features and more. It is geared towards getting the basic user more firmly grounded in the program in order to increase their fluency and efficiency. Concrete examples are provided as well as listings of shortcuts and techniques to provide a solid foundation in using this popular spreadsheet software.
An introductory video on how to use the program
This module covers key terms, navigational tricks and shortcuts.
The File Tab is Home Base in many ways for Excel. Learn how to open files quickly and many settings in this "Back Stage" area of Excel.
The Quick Access Toolbar, or QAT, is a great place to put buttons that you use frequently. Learn all about it in this module.
Almost all of your formatting settings are available just by right clicking your mouse. The module teaches all about this cool feature.
Some basic information you need to know about different types of data that Excel can handle -- covered in this module.
Learn how to quickly fill in months, days of the week and even more complicated lists with the power of Autofill!
Learn how to quickly select areas of the spreadsheet to format, copy, etc. with the settings and techniques covered in this module.
There are many ways to do basic things in Excel -- including keyboard shortcuts. Learn these particular keyboard shortcuts and you won't waste time looking for buttons anymore!
Adding and deleting rows and columns, hiding and unhiding as well as column and row sizing are covered in this module.
Naming, moving and copying worksheets quickly are covered in this module.
Saving and replacing, save as and different file types are covered in this module.
Quickly make your spreadsheet more usable and professional looking with these basic formatting options.
Learn the fundamentals of how to quickly create a CORRECT formula in Excel!
There are over 350 functions in Excel that do lots of different things. In this module, I covered the basic functions as well as the basic structure of all Excel functions.
Database design principles, sorting, filtering, hiding and unhiding rows and columns are all covered in this module.
Using and practicing these techniques to important in order to retain it. I make some suggestions on how to "make it stick" in this module.
Rob Hambleton is a seasoned professional with decades of experience working at Ford Motor, Eastman Kodak and Dell Computer. Rob has distilled his experiences and techniques into dozens of course that he has been delivering publicly for over 15 years. Courses in finance, Microsoft Excel, Team Building, Leadership, Communications and more. Rob's courses are designed to deliver techniques that are usable and immediately applicable. Roll up your sleeves -- it's about to get REAL!