During this intensive one-to-one one-day Excel course, you will master the main features of Microsoft Office Excel. It is ‘hands on’ and you will practice creating and modifying actual spreadsheets.
Getting Started with Excel: About Workbooks, Exploring your Workbook, Getting Help with Excel
The Excel Ribbons and Menus: The Quick Access Toolbar and File Menu, The Home Tab, The Insert Tab, The Page Layout Tab, The Formulas Tab, The Data Tab, The Review Tab
Excel Course Basics:
Working with Excel, Basic Excel Features, Moving Data, Smart Tags and Options Buttons, Editing Tools
Inserting, Moving, Copying, Deleting sheets, Colouring sheettabs
Editing your Workbook:
Entering data, Modifying Cells and Data,
Cell Formatting, Enhancing a Worksheet’s Appearance, Copy Fomats
Entering basic Formulae: Creating basic formulae, Popular functions, reading and understanding existing formulae
Working with data sets: Sort, Filter, Find, Replace
Printing and Viewing your Workbook: Using the View Tab, Managing a Single Window, Managing Multiple Windows, Printing your Workbook
Working with Charts: Creating Charts, Selecting Chart Data, Working with Chart Options
Inserting Drawings, Inserting Smartart
Sign up to receive lessons, tips, examples, quizzes and other training materials.