Skip navigation

Catalog

Instructor led
Added:08/20/2024 3:12 PM

Learning Excel tips is highly beneficial for anyone working with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques, and data analysis features can save time and reduce errors. Whether you're a beginner or an experienced user, this class will empower you to work smarter, not harder. 
Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience.
Program Level: Intermediate
Contents:Workbooks and File Secrets Customizing Excel for Efficiency Filters and slicersThe Most Effective Shortcut Keys Tips for Selecting and Navigating Efficiently Finding and Filling blank cellsUnderstanding the power of Flash Fill and AutofillUsing the Quick Analysis Feature Using Conditional FormattingFinding Duplicate recordsUsing Data ValidationHow to effectively use Excel Indenting 
Note: This course will be taught using the windows operating system environment
Credits awarded per Session. See individual Sessions for further details.
Credits awarded
Type
Name
Sub type
Value
Certificate awarded
Already successfully completed: This item allows re-enrollment

About this item

Learning Excel tips is highly beneficial for anyone working with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques, and data analysis features can save time and reduce errors. Whether you're a beginner or an experienced user, this class will empower you to work smarter, not harder. 


Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience.

Program Level: Intermediate


Contents:

  • Workbooks and File Secrets 
  • Customizing Excel for Efficiency 
  • Filters and slicers
  • The Most Effective Shortcut Keys 
  • Tips for Selecting and Navigating Efficiently 
  • Finding and Filling blank cells
  • Understanding the power of Flash Fill and Autofill
  • Using the Quick Analysis Feature 
  • Using Conditional Formatting
  • Finding Duplicate records
  • Using Data Validation
  • How to effectively use Excel Indenting 

Note: This course will be taught using the windows operating system environment

Course/Activity Information

Pricing:
$279.00 Member Volume Discount (3+)
$309.00 Member
$339.00 Non-Member Volume Discount (3+)
$369.00 Non-Member

Other information

Additional Charges May Apply

Ratings and reviews