If you are interested in a class that does not have a scheduled date, please click on the CONTACT US button
Tags: PC Applications
Excel Tips & Tricks
One Day • Instructor Led
This course offers valuable tips and tricks to maximize the capabilities of Excel. You will learn shortcuts that are sure to speed up application development with Excel and take your skills to the next level. Below are just a few of the tips and tricks –
Prerequisites
To ensure your success, we recommend you have experience using Excel with data and familiarity with basic concepts of data analysis such as working with tables, filtering, sorting, using formulas and performing calculations.
Course Outline
Lesson 1: Basic Excel Usage
Lesson 2: Data Entry
Lesson 3: Formatting
Lesson 4: Basic Formulas & Functions
Lesson 5: Useful Formula Examples
Lesson 6: Charts & Graphics
Lesson 7: Data Analysis and Lists
Lesson 8: Working with Files
Lesson 9: Printing
Lesson 10: Customizing Toolbars & Menus
Lesson 11: Spotting, Fixing & Preventing Errors
Lesson 12: Basic VBA & Macros
Lesson 13: Mathematical Calculations