Advanced Microsoft Excel Training For professionals

MS Excel 2016 Advanced Masterclass Outline

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.

Prerequisites

A working knowledge of Excel or our Excel Intermediate course.

 

Benefits

• At the end of this course you will have a complete understanding of the higher functions of Excel.
• You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

 

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

Duration: 1 day

Requirement: Laptop with Microsoft Office

Venue: 1, Adegbeyemi Street, Beside Alade Market, Off Allen Avenue, Ikeja Lagos

Date: Saturday 17th, February 2018

 

Bank Details

Account Name: Lead-Leap Consulting Limited

Account Number: 1015367694

Fee: NGN25,000

Bank: Zenith

Contact

Tel: 08062468296

E: [email protected]

W: www.leadleapconsult.com