Advanced Excel Training [Download Link Available On Purchase]

Learn Ms Excel From The Comfort Of Your Home Or Office

A step-by-step Excel Video Tutorials With Simulated Real Life Practical Cases and Solutions. This Is the best Excel Tutorial you can find in the market place because every video illustrates how to solve real world problems

From The Desk Of The Instructor

I get exhausted when I get emails from people who send me excel workbooks to help them solve simple problems yet these individuals have not taken any step to improve their Excel skills. I can understand that most Excel Onsite training are usually 3 - 5 days and are beyond the budget of many people who are interested in improving their skills. Others have busy schedule which I quite understand. No matter the challenges you face, you are very lucky reading this information because I have a solution to your challenges in MS Excel.

Are you a GRADUATE in Finance, Marketing, Business Management, etc., Excel is a must for YOU.

I have been part of interview panels for NYSC members who are looking for jobs yet, many of them LACK basic Office Productivity skills. There is no free money anywhere; corporate organizations are looking people to solve corporate problems and be rewarded for providing solutions and not people to pay salaries.

MS Excel have a lot of functionalities but many people do not even use up to 5%.

I have personally built many applications in Excel in the Corporate World - Applications from a simple Calculator, Stop Watch Timer to using Excel to build an Accounting Program.

You may have attended 3 – day crash Excel programs, collect certificates, eat launch and after some months, you forget what you have learnt – Let me be frank with you – You can’t learn Excel in 6 months, let alone 3-days. Or how many people would be patient like me that read a 1,200 – pages Excel books over 3 months in 2006 when I was not preparing for an Excel Exam?

If 3-days cannot make you to be an Excel Expert, then my Virtual Advanced Excel Class is the only solution to this problem.

With my Virtual Advanced Excel Class, you will be taken step-by-step from the rudiments of Excel to mastery in Excel Usage. This program is flexible to meet your schedule but the minimum time you can cover the entire 4 Modules is 30 days of consistent study and practice if you allocated each day to Excel. In fact, learning does not stop until you cover all the modules and are able to bring your knowledge to bear on problems you want to solve with Excel.

This whole program is encapsulated in 4 areas as follows:

1. Basic Excel Class
2. Intermediate Excel Class
3. Advanced Excel Class
4. Macros in Excel

Why Learn Advanced Excel?

1. It is a must for finance professionals because they cannot do without number crunching.
2. It gives you accuracy and speed as well as edge over your peers.
3. You cannot complete a business plan without Excel
4. You can build applications on Excel when you take your skills to VBA Programming.
5. Use Excel to by-pass a lot of time-consuming data entry functions.
6. Use Excel to build models you can use to evaluate the profit potential or a project or transactions thereby, minimizing business losses.
7. Use Excel to build templates to check excess bank charges
8. Use Excel to build a customized accounting solution with forms if you cannot afford an accounting software for you business at the moment.

Contents of The Excel Course

A – BASIC CLASS CONTENTS

Introduction To Advanced Excel, Examining The Ribbon, Customizing Excel, Saving A Workbook, Planning Your Worksheets, Worksheet Editing Techniques, Basic Formatting, Format As A Table, Cell Style Formatting, Conditional Formatting, Worksheet-Level Protection, Workbook-Level Protection and Encryption.

B – INTERMEDIATE CLASS CONTENTS

Introduction To Formulas & Functions, Understanding The Concept Of Reference, Using Names In Formulas, Sundry Maths & Stats Functions for everyday Business (Sum, SumProduct, Average, Count, Min, Max, SumIf, SumIFS, Averege, AverageIFS, CountIFS, Subtotal, etc), Finance Functions (Time Value of Money, NPV, IRR, XIRR, PV, FV, IPMT,PPMT, PMT), Creating a Loan Amortization Schedule, Logical Functions (IF, AND, OR, IFERROR, Nested IF), Date Functions (TODAY, NOW, EOMONTH, Calculations with Dates), Reference Functions (Hlookup, Vlookup, Lookup, Index, Match), Running Scenarios with Index Function, Indirect Function and many more.

C-ADVANCED EXCEL CLASS CONTENTS

Hyperlinks & Data Validation, Data Consolidation by position, Data Consolidation by Category, Splitting Data Into Multiple Columns, Flash Fill, Removing Duplicates, What-If-Analysis (Data Tables, Goal Seek, Scenario Manager, Solver), Data Management On Tables, Advanced Filters, Excel Charts, Pivot Tables, Data connection (From Access, Text Files, Web), Linking & Embedding,

D-EXCEL AUTOMATION WITH MACROS

Introduction To Macros, Running Macros with Relative & Absolute Reference, Creating A Format Macro, Tour of VBA Editor, Adding Macros to the Ribbon.

Watch these YouTube Videos to see how the course materials look like

How To Use Excel IF Function To Solve A Real Life Situation

How To Use Excel INDEX Function To Create Multiple Budget Scenarios

How To Use Excel RANK & VLOOKUP Function To Find The Top Nth Performance Position

How To Use Excel The Excel Goal Seek Tool To Find The Amount of Resources To Achieve An Objective

Contact Email: [email protected]

Contact No: 08035786640