A Demonstration Is Worth A Thousand Words!

You will learn how to numerate greatly with Microsoft Excel, utilize Excel watch window, and consolidate Excel Data, enable interactive Excel calculations, Dashboard, Pivot, Chart and Graph, utilize What-If analysis tools (including goal seek), utilize Excel Scenario Manager, good knowledge of some absolute great Excel Functions.

Try AlvaPRO for accurate content, simplified delivery and convenient schedule..

Program Deliverables:

Study Materials

Practices Excel Worksheets and Cases

16 Hours/2 days

Tea break, Lunch, Training Notepad with pen

Post Training Support

16 Hours Course completion certificate

You have to bring your laptop for the workshop

 

Course Contents (In Brief):

Day 1

ü  Getting started

ü  Worksheet Basics

ü   In-depth Excel Formulas and Functions

ü  Essential Formatting

ü  Creating and Using Charts

ü  Printing preparation

ü  Exploring Excel’s Database Features

ü  Analyzing Data

ü  Pivot Tables

ü  Advance Formatting

ü  Collaborating with others

ü  Creating and Using Macros

ü  Customizing Excel

 

Day 2

5 Large Excel Projects:

ü  Creating Worksheet and an Embedded Chart

ü  Formulas, Formulas, Formatting, and Web Queries

ü  What-If Analysis, Charting, and Working with Large Excel Projects.

ü  Creating, Sorting and Querying

ü  Financial Functions, Data Tables and Amortization Schedule

       

             Reach Joshua on 08091728713/0905042300 or josh@alvaexcel.com to register.

           

                                                            

Abuja Venue:  Gracious Hotel, Plot 29, Okemesi Crescent, New Polytechnic Layout(Old FERMA) Off Mohammed  Buhari Way, By Old CBN, Garki 2.

Dates:  10th and 11th of June (Friday and Saturday)          Time: 8:00 a.m. sharp

 

PortHarcout Venue: JC International Ltd, Plot 5 JC Street, off Peter Odilli Road, Trans Amadi Industrial layout

Dates: 17th and 18th of June (Friday and Saturday)           Time: 8:00 a.m. sharp

 

Lagos Venue: Kristina Jade Learning Center, 70b Olorunlogbon Street, Off Alade Lawal Street, Anthony Village, Lagos. 

Dates: 24th and 25th of June (Friday and Saturday)         Time: 8:00 a.m. sharp