Teaching intermediate to complex level Excel in an easy to follow way
What you’ll learn:
MS- Excel
Pivot Tables
Pivot Charts
VBA
Macros
Lookup Function- Vlookup and Hlookup
Index and Match Function
Advanced MS- Excel with Case based Application
Requirements
Basic Excel Knowledge is Preferable but not Required
Description
Microsoft Excel is a spreadsheet application where we can do graphs, charts, and many other important day to day functions.
But, there are many things in excel which we do not explore.
SigmaWay is here to help you explore the full potential of Microsoft Excel, by teaching you Advanced Excel. Learning the skills of advanced excel can make you stand out in a big crowd.
If you are an employee, researcher, student, or entrepreneur, learning these advanced excel skills will make you a valuable resource in your team. Thinking on these terms, SigmaWay created its Advanced Excel Training, to help everyone unlock the full potential of this common tool and stand out in the crowd.
With Sigmaway’s Advanced Excel Training, you will be able to master Core Concepts that will help you solve business problems and help you learn to manage data more efficiently.
The topics covered include.
Advanced Functions and Formulas Like :-
LOOKUP Functions (VLOOKUP/ HLOOKUP)
INDEX and MATCH functions
Excel VBA
Excel Macros
This course is taught through an Industry Case Example, curated to teach students how to:-
Analyze business problems
Understand how data is manipulated and Cleaned
Application of techniques to find insights from data
Visualize Data
Set Up Auto-Updating Features using Macros
And More..
Please take your time and enjoy learning with us @ SigmaWay!!
Who this course is for
Management Consultants
Analysts
Students
Business Students
Professionals
Freshers
Those wanting to Upskill
DOWNLOAD LINK