Hotlines: +234-8035786640, 8127708077 | Email: info@walktalkblogsystems.org

Advanced MS Excel Tutorial

7,500.00

Rating: Category:

Be An Expert In Advanced Excel & Financial Modelling Without Attending Class Training
An Interactive Way To Learn Advanced Excel From The Comfort Of Your Home Or Office With Over 70 Videos And Practical Excel Case Studies

Product Description

Be An Expert In Advanced Excel & Financial Modelling Without Attending Class Training
An Interactive Way To Learn Advanced Excel From The Comfort Of Your Home Or Office With Over 70 Videos And Practical Excel Case Studies

From The Virtual Office Of Emmanuel Daniels

I observed that a lot of people do not know the power of Ms-Excel. Even though many use Excel but they only use less than 5% of the potential of Ms-Excel.

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 building Financial Models. This program is flexible to meet your schedule but the minimum time you can cover the whole modules of 32, summarized in 23 Subject lines and 5 sections of 70 videos, is 3 months. 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.
  9. Why Subscribe For My Virtual Training?

You cannot learn Excel in 3 days – Use this program to build you skill set over timeIf you cannot pay N50,000 to N100,000 to take your Excel Skills to an Advanced Level, this program is for you

  1. If you do not have the time to attend class training, this program is for you
  2. If you want to learn how to build financial models, this program is for you

Contents Of The Excel Program

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


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.


 

Reviews

There are no reviews yet.

Be the first to review “Advanced MS Excel Tutorial”

Your email address will not be published. Required fields are marked *