Excel for Business

Course Descriptions

Master Advanced Excel Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training.

Curriculum

• Introduction
  • What is a spreadsheet?
  • Rows and columns
  • Raw data and information
• Introduction to Excel
  • Text formatting
  • Cell structure in the spreadsheet
  • Using the fill handle
  • Numeric representation
  • General editing techniques
  • Printing adjustment
  • Cell type setup
• Basic Spreadsheet Operations
  • Using the AutoSum function
  • Auto Fill – Quick Tip
  • Finding data in spreadsheet
  • Sorting and filtering
  • Formatting the data
  • Format Painter – Quick Tip
  • Table creation and formatting
  • Charting and Analysis
  • Views in excel
• Data Analysis in Excel
  • Advanced data sorting
  • General formulas for data analysis
  • Text-to-Columns function
  • Data cleanup
  • Advanced referencing techniques
  • Auditing techniques
• Advanced Formulas and Functions
  • Using the IF function
  • Complex IF scenarios
  • Combining SUM and IF
  • Introduction to COUNT and IFS
  • Nested IF and special functions
  • Naming cells and cross-referencing
• Advanced Data Auditing
  • Introduction to formula audit
  • Trace Precedents and Dependents
  • What is a watch window?
  • Advanced data formatting techniques
• Advanced Data Analysis Techniques
  • Using data validation
  • Introduction to PivotTables
  • Advanced PivotTables functions
  • Using PivotCharts
  • Commenting and tracking change
• Security and Data Protection
  • Sheet protection and locking
  • Workbook protection and locking
  • Sharing workbook