When learning Excel we provide learning materials and lessons around the following agenda items. This agenda can easily be customized and adapted to your needs.

CONDITIONAL FORMATTING

  • Data Bars & Color Scales
  • Coloring cells based on numbers or words
  • Creating your own rules

PIVOT TABLES

  • Quick and Easy Reports
  • Reorganize the data
  • Summarize your data

WORKING WITH TEXT

  • Concatenate
  • Removing duplicates
  • TRIM Function
  • PROPER Function
  • AND Function

AUDITING WORKSHEETS

  • Locating Precedent and Dependant Cells
  • Tracing Precedents and Dependants
  • Removing Auditing Arrows

USING BASIC ANALYSIS TOOLS

  • Performing “What If” analysis using Goal Seek
  • Working with Scenarios

OPTIONS WHEN SAVING

  • Password Protect your Worksheet
  • Define Protected area in your Spreadsheet

IMPORTING AND EXPORTING FILES

Taking the time to learn is taking the time to invest in yourself and your future success.