Microsoft Excel ( Advanced Masterclass)

Who is this course for?

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

With our Super Advanced Excel training course, you will spend only 20% of the time to master enough Excel skills that will contribute to 80% of your job performance. The secret is – do not try to learn everything Excel has to offer, only learn the part that is most useful, and especially the creative ways those features and functions can be combined to process and analyze data.

What will you be able to do post-training?

1. Have high comfort working with Excel leading to quick turnaround time
2. Use right formulas for the given scenario
3. Write Complex Formulae with ease
4. Handle Excel related situations more maturely
5. Present Financial data with better interpretation

Objectives

The objective of the training program is to enable professionals to enhance their MS Excel skills through exercise, case studies and gaining hands-on experience on various techniques & Tools. Advance MS Excel Financial Functions have been exclusively designed for the all corporate professionals to hone their skills in applying all financial acumen in Excel.  

The training covers step-by-step lessons ranging from basic/start fundamentals likes, working with Cells & Ranges, Chartings, Writing Iteration loops in Excel, Application of Array functions to advanced features and their application in professional jobs. The course will help delegates gain Excel Proficiency- Calculations, Functions, Formula's, Optimization and Statistical Tools and Excel Best Practices. Also, knowing Excel functions and features is the first step in financial modeling.

 

Training Deliverables

• 150 Pages+ Study Material
• 25+ Practice Excel Worksheets & Cases
• 7 Hours /1 Day
• Post Training Support (Refresher training)
• You must bring your laptop
• Certificate after completion of training

Course Syllabus

Using logical functions

Naming ranges
- Creating named ranges
- Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Working with lookups

The VLOOKUP function
The HLOOKUP function

Working with useful shortcuts, tips and tricks

 

Working with functions and formulas

Financial functions [PMT, IPMT, PPMT, FV, PV]

Date Functions [Days, Edate, Eomonth, Networkdays, Workdays, Datedif]

Text Functions [Upper, Lower, Proper, Concatenate, Concat, Textjoin, Len, Mid, Right, Left]

Others functions such as Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs, Maximum, Minimum

Sorting and Filtering

Using of advanced sorting and filtering

Conditional Formatting

Advanced list management

Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown list

PivotTables and PivotCharts

Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Working with scenarios
- Creating and saving scenarios
- Viewing scenarios

Macros

Creating macros
Using the macro recorder

Akerele Oluwasogo is a professional Data Analyst and corporate Excel Trainer at Lead-Leap Consulting Limited with experience in training small and large groups across diverse industries. Proven success in leveraging educational theories and methodologies to design, develop, and deliver successful training programs and integrate instructional technology to provide onsite and virtual training. Adept at organizing and facilitating Microsoft Office, Management and Team building training programs and activities. I have in the past executed Advanced Microsoft Excel training for corporate clients such as CWAY Group Nigeria Limited, Dew Insight Consulting, and Spar Nigeria Limited.

Professional Experience
1. Managed development, implementation, and continuous improvement of training programs, including on going learning opportunities company wide.
2. Scheduled and taught weekly internal classes to groups of 25+ employees across various departments.
3. Delivered virtual and hands-on Microsoft Excel training while identifying training gaps to help Human Resource department to work efficiently and effectively using comprehensive templates
4. Coordinate and conduct small group and individual training sessions based on staff and organizational learning needs.
5. Lead learning enhancement classes to improve Microsoft Office knowledge and people skills for workplace success and advancement.
6. Routinely evaluate business training needs and adjust staff development and educational programs.
7. Conduct ongoing needs analysis leveraging customer feedback, field interactions, and subject matter expertise to adjust learning strategy and curriculum.

Lunch
Your choice of Food and Drinks

Discount
5%  for those who pay a week before the Training (Early Bird)
10% for a group of four(4) that register for the Training

Course Manual and Certificate