Excel Tips & Tricks

Overview: 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:

  • Creating "impossible" charts
  • Tweaking Pivot Tables
  • Copying print settings across sheets
  • Taming "automatic" toolbars
  • Using a UserForm
  • How to create dynamic chart data 
  • Use Analysis Toolpak
  • Sort on more than three columns
  • Attach toolbars to worksheets
  • Apply custom functions

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

  • Selecting
  • Navigating
  • Hiding
  • Formatting
Lesson 2: Data Entry
  • AutoComplete, AutoCorrect and Auto Fill
  • Freezing panes
  • Drop-Down lists
Lesson 3: Formatting
  • Number formats
  • Gridlines, borders and underlines
  • Wrapping text
  • Colors and alternate row shading
Lesson 4: Basic Formulas & Functions
  • References
  • Values and formulas
  • Names
Lesson 5: Useful Formula Examples
  • Calculating
  • Dates
  • Counting
  • Lookups
Lesson 6: Charts & Graphics
  • Different types of charts
  • Plotting
  • Graphics
Lesson 7: Data Analysis and Lists
  • Sorting
  • Filtering
Lesson 8: Working with Files
  • Importing
  • Document properties
  • Passwords
Lesson 9: Printing
  • Printing controls
  • Page breaks and numbering
Lesson 10: Customizing Toolbars & Menus
  • Buttons and commands
  • Creating, taming and attaching toolbars
Lesson 11: Spotting, Fixing & Preventing Errors
  • Error checking
  • Phantom links
  • Cell relationships
Lesson 12: Basic VBA & Macros
  • Security issues with macros
  • Recording and running a macro
  • Using add-ins
Lesson 13: Mathematical Calculations
  • Converting measurements and temperatures
  • Calculating, area, surface, circumference and volume
  • Generating random numbers and integers
Length of Class: 
One Day
Instructor-led or Online: