MS Excel - Advanced Masterclass
Details
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.
PrerequisitesA 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.
- Have high comfort working with Excel leading to quick turnaround time
- Use right formulas for the given scenario
- Write Complex Formulae with ease
- Handle Excel related situations more maturely
- Present Financial data with better interpretation
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
Outline
- Introduction to Excel Advanced
- Using Text to Columns
- The Paste Special Function
- Data Validation
- Subtotals and Grouping
- Consolidating Data
- Scenario Analysis
- Data Tables in Scenario Analysis
- What-if Analysis
- Mats and Trig Functions
- Text Functions in Excel
- Using Lookup Functions
- V-Lookups
- H-Lookups
- Using Statistical Functions
- Database Functions
- Formula Auditing and Error Tracing
- Hyperlinks in Excel
- Linking Data
- Understanding Pivot Tables Using Pivot Charts
- Workbook Properties
- Protecting and Sharing Worksheets
- Data Encrypting and Finalising Workbooks
- Understanding & Using Macros
- Custom Number Formats in Excel
- Using Custom Lists
- Working with Templates
- Tracking Changes in Excel
- Merging and Comparing Excel Workbooks
- Dashboards, Form Control & Power View
- PowerPivot -Intro
Special Offer
LeadLeap Consulting Limited …Giving you the best learning experience
Lead-Leap Consulting Limited (LCL) is a group of professionals whose overarching goal is to add value to individuals and organizations through our well researched hands-on training. we have supported organizations in their quest for impact and growth leveraging educational theories and methodologies to design, develop, and deliver successful training programs.
From CWAY, LEADWAY, COOL FM, FLUTTERWAVE, BCX, JUMIA to SPAR Nigeria Ltd, Lead-Leap has delivered end-to-end training solutions to meet the training needs of corporate organizations and individuals.
Mission
To give our clients the best learning experience by adding value to them
Areas of Specialization
- DATA ANALYTICS TRAINING
We offer carefully selected and relevant professional Data Analytics training courses in our open and corporate training classes. 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. ...