What you'll learn

Microsoft Excel
The most useful functions, formulas, tips, & tricks
The 21 must-know things in Excel today
Learn the skills to help you automate, streamline, and optimize your workflow with Excel
Master unique tips that you won't find in ANY other course, guaranteed

Requirements

Basic understanding of Microsoft Excel- Microsoft Excel 2016

Description

Are you looking for a course where you can discover the most valuable Excel features available today?

Well, you've found it. This course provides you with an in-depth workbook that explains the most important functions that you NEED to know. Discover the truly awesome power of Excel that will help take your career to the next level.

If you are looking for a course where the instructor talks for 6+ hours and gives you little in the way of resources, well... this isn't that course. You will start with the complete resource Excel workbook that I have spent months putting together...Then, I will walk you through the whole thing.

This course will prepare you for any accounting/ finance role and improve your performance in your current role.

I've used the knowledge contained in this course to build:

Fully dynamic dashboards, forecasting models, standard cost models, cost analysis models...

Included in this course:

Function Wizard

Data Validation

Working in Excel

Text to Columns

Sumif

Sumifs

Countif(s)

Vlookup, Vlookup-Match

Index Index-Match-Match, Offset, Index-Match-Match

Pivot Tables

Logical Operators

Text Functions

Data Tables

Quick Access Tool Bar

Cell Formatting

Conditional Formatting

Indirect

Sumproduct

Linking Cells

Ben's Excel Best Practices Word document (Included)

Who am I? I have worked in Executive-supporting roles at 6 major corporations during the last 7 years in the accounting arena where I have been able to build my career by knowing Excel better than the last guy.

Who this course is for:

Accounting & Finance professionals
Anyone who wants to master Excel