Microsoft Excel For Business

Course details

• Nearly 100 downloadable PDF slides and Excel Project files to enhance your learning
• Free quiz to help you consolidate your learning
• Develop a mastery of basic and advanced excel skills
• Learn how to master formula, functions, charts and graphs
• Master… functions such as SUMPRODUCT, COUNTIFS, VLOOKUP,… CONCATENATE, HYPERLINK and many more!
• PLUS easy keyboard shortcuts to increase your productivity and speed - both PC and Mac!… 

Microsoft Excel for Business will take your Excel to the next level, and allow you to impress your boss or keep driving your business forward. This course will provide a masterclass in advanced excel skills which will allow you to master powerful analytics tools and present data in new and exciting ways.

Leading you through this course will be Chris Dutton, the founder of Excel Maven whose passion for Excel led to him to become a Certified Microsoft Excel Expert. Chris specialises in using innovative, hands-on online courses to get students up to speed and has taught thousands of students in the past seven years to use Excel like a master.

This course starts with detailed instructions on how to master Excel Formulas and Functions, with sections dedicated to Lookup/Reference functions, Statistical functions, Formula based formatting, Date & Time functions and many more. Chris will then move on to how to use those functions in a creative way through Advanced Charts and Graphs.

If you want to master Excel and banish those spreadsheet fears take this course today!

• Intro
• Say hi to your fellow students!
• Share your new course with your friends!
• Course Structure & Outline

• Introduction
• Handout - Formulas 101
• Excel Download - Fixed Relative References
• The Formula Library & Auditing Tools
• Basic Formula Syntax
• Fixed, Relative, & Mixed References
• Common Errors & the IFERROR statement
• Function, CTRL & ALT Shortcuts
• Handout - Mac Shortcuts
• BONUS: Shortcuts for Mac Users
• Creating Custom Data Validation Rules
• Fixed vs. Volatile Functions

• Introduction
• Handout - Logical Operators
• Excel Download - Logical Operators
• Anatomy of the IF Statement
• Nested IF Statements
• AND/OR Operators
• NOT vs. \\"
• Fixing Errors with IFERROR
• Common IS Statements

• Introduction
• Handout - Statistical Functions
• Excel Download - Statistical Functions
• Basic Statistical Functions
• SMALL/LARGE & RANK/PERCENTRANK
• RAND() & RANDBETWEEN
• The SUMPRODUCT Function
• COUNTIFS/SUMIFS/AVERAGEIFS
• PROJECT SHOWCASE: Building a Basic Dashboard with COUNTIFS & SUMIFS

• Introduction
• Handout - Lookup/Reference Functions
• Excel Download - Lookup/Reference Functions
• Working with Named Arrays
• ROW/ROWS & COLUMN/COLUMNS
• VLOOKUP/HLOOKUP
• Joining Data with VLOOKUP
• Fixing Errors with IFERROR & VLOOKUP
• VLOOKUP Reference Array Options
• The INDEX Function
• The MATCH Function
• Using INDEX & MATCH together
• Combining MATCH with VLOOKUP
• The OFFSET Function
• PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart

• The INDEX Function
• The MATCH Function
• Using INDEX & MATCH together
• Combining MATCH with VLOOKUP
• The OFFSET Function
• PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart

• Introduction
• Handout - Text Functions
• Excel Download - Text Functions
• UPPER/LOWER/PROPER & TRIM
• The CONCATENATE Function (&)
• LEFT/MID/RIGHT & LEN
• TEXT/VALUE
• SEARCH/FIND
• Categorizing Data with IF(ISNUMBER(SEARCH))
• Combining RIGHT