
Originally published: 31/05/2021 08:56
Publication number: ELQ-75334-1
View all versions & Certificate
Publication number: ELQ-75334-1
View all versions & Certificate

Microsoft Excel-The Ultimate Workbook How-to Resource Course
Discover and Master the Most Important Formulas, Functions, Tips, & Tricks in Excel!
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...
By completing this course, you will:
Be able to work comfortably with Microsoft Excel and many of its advanced features
Become one of the top Excel users in your team
Be much quicker at carrying out regular tasks
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 10 years in the accounting arena where I have been able to build my career by knowing Excel better than the last guy.
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...
By completing this course, you will:
Be able to work comfortably with Microsoft Excel and many of its advanced features
Become one of the top Excel users in your team
Be much quicker at carrying out regular tasks
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 10 years in the accounting arena where I have been able to build my career by knowing Excel better than the last guy.
This Best Practice includes
1 Excel Workbook