Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course takes the hands-on approach while getting familiarized with some of the Excel’s advanced concepts. The analysis and dash-boarding capabilities are hence practiced to the fullest.
At the end of the course, participants would learn/use/acquire the following techniques/knowledge:
Each and every topic mentioned above are explained in detail in the Hands-on videos. Exercises and datasets included in this course are useful to practice and implement the concepts learned in this course. For your reference,additional materials are also provided
This course is is intended for the financial analysts and business users who are willing to explore the advanced tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP|
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUPPreview
|Section 3: Reverse Lookup techniques – using INDEX and MATCH|
Reverse Lookup techniques – using INDEX and MATCHPreview
|Section 4: Effective Error handling – using ISERROR/IFERROR|
Effective Error handling – using ISERROR/IFERROR
|Section 5: Tracing formula dependents and precedents|
Tracing formula dependents and precedents
|Section 6: Using formula auditing tools to avoid errors|
Using formula auditing tools to avoid errorsPreview
|Section 7: Datasets|
|Section 8: Creating Pivot Tables using complex datasets|
Creating Pivot Tables using complex datasets
|Section 9: Generating Pivot Charts Instantly|
Generating Pivot Charts Instantly
|Section 10: Implementing Slicers to build Interactive dashboards|
Implementing Slicers to build Interactive dashboards
|Section 11: Grouping and Sub Total of Data in Pivots|
Grouping and Sub Total of Data in PivotsPreview
|Section 12: Beautifying reports / tables using Sparklines|
Beautifying reports / tables using Sparklines
|Section 13: Datasets|
|Section 14: Additional Material|
|Section 15: Exercises|
|Section 16: Mock Test|
|Section 17: Course Conclusion|
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.