Advanced Excel Course in Germany - Spoclearn

1. Advanced Microsoft Excel Training - Brochure

2. Why take up Advanced Microsoft Excel Training? Microsoft Excel has become an indispensable tool in an individual's life, starting from school, college, and then to professional workspace. More than 80% of jobs in the industry require Excel skills, and for some jobs, it is a mandatory skill set as we are moving towards a data-centric business landscape. Professionals with Advanced Microsoft Excel knowledge earn 12% more than others with basic or intermediate-level skills. Some of the top-level jobs that require Advanced Microsoft Excel skills include Accountants, Administration Staff, Cost Estimators, Data Analysts, Business Analysts, Project Managers, Financial Analysts, Retail Managers, Sales & Marketing professionals, and more. The average salary of a Microsoft Excel certified professional is in the range of USD 47,000 to USD 89,000 per annum in the US.

3. Who can take up ADVANCED MICROSOFT EXCEL TRAINING? Job roles that can find Advanced Microsoft Excel training beneficial are: Data Analysts Sales team Members Business Analysts Marketing Team Members Operations Staff Project Managers Clerical Team Members Data Engineers Marketing Staff Data Scientists Administration Staff Accounting/Finance Staff • Anybody who wants to gain a thorough understanding of Advanced Microsoft Excel concepts • Professionals who are looking to clear their Microsoft Excel MO- 201 certification exam

4. Why Take up ADVANCED MICROSOFT EXCEL TRAINING FROM SPOCLEARN? 2-Day (6 hours/day) interactive instructor-led Advanced Microsoft Excel training z z 100% Money-Back Guarantee Expert Microsoft Certified Trainers across the globe z Exercise Spreadsheets prepared by SMEs z Hands-on practical-based learning with formulas and functions z z After training coaching for real-world application

5. MICROSOFT EXCEL MO-201 EXAM FORMAT Exam Type Multiple Choice No. of Questions 40-60 questions Type: Closed Book Exam Languages: English 01 02 03 04 Passing Score 700 out of 1000 required to pass (equivalent to 70%) Exam Duration 90 minutes (One and a half hours)

6. ADVANCED MICROSOFT EXCEL Training Agenda

7. 1 INTRODUCTION & DATA FORMATTING v Number Formatting v Worksheets/Rows/Columns/Workbook v Wrap Text/Merge/Go to/Find & Replace v Cell-reference

8. 2 TABLE STYLE v Conditional Formatting v Highlight rows and columns v Apply data bars and Icons v How to apply more than one conditional formatting? v Remove conditional formatting v Custom conditional formatting

9. 3 FORMULAS & FUNCTION v Logical Function v Mathematical Formula v Text Function v Date Function

10. 3 LOOKUP FUNCTION v What is the difference between VLOOKUP & HLOOKUP? v Difference uses of True and False option v Lookup itself v Advanced VLOOKUP Tricks v Advanced VLOOKUP’s v Looking up on left v VLOOKUP with Match function v Match & Index function v VLOOKUP with multiple condition

11. 4 ADVANCED FORMULAS v OFFSET Formula v What is it and Syntax v Offset with examples v Uses of Offset Formula

12. 5 FILTER WITH EDITING v Sorting with custom list v Filter v Advance Filter v Freeze Panes

13. 6 DATA VALIDATION v Uses of Data Validation v Using drop-down box to validate v Dependent drop-down List v Using Formulas v Showing Error Messages

14. 7 MASTER REPORT v Pivot Table v How to convert data in pivot table? v Use of Pivot table tools. v Pivot table option and Layout v Change source data v Automatic Refresh Data

15. 8 REPORT WITH GRAPHICS v Charts v Creating 2D 3D Charts v Formatting charts v Using Column & Line chart together v Primary & Secondary Axis Bullet chart – what is it and how to make v In cell charts – using REPT to make charts v Min-Max chart – showing range along with average v Waterfall charts v Timeline charts v Thermo-meter charts v Gauge Chart

16. 9 GOAL SEEK & SCENARIO v Creating a scenario v Defining data tables v Finding a target value with Goal v Seek Defining constraints and running Solver v Creating a configurable model

17. 10 GET & TRANSFORM DATA v Import Data v How to Import Live Data v How to Import Data from Text, CSV, MS-Access or Web

18. 11 ADVANCED PROTECTION v Workbook/Worksheets Protection v Protection on Opening v Protection on Read-only v Workbook Structure v Locking & Unlocking of Cells v Protecting Constant Cells v Protecting Formula containing cells v Protection only specific Cells

19. 12 MACROS & VBA PROGRAMMING v Introduction to Macros v What is a Macro? v Displaying the Developer Tab v About Macro Security v Saving Workbooks that contain macros v Understanding different types of macros v Recording, Editing, & Deleting of Macro v Understanding how to record VBA Macros v Examining, Testing and Editing macros v Absolute versus Relative referencing while recording macros v Assigning macro to a keyboard shortcut or a button

20. LEARNING ROADMAP FOR YOU Understand the learning objectives that fits your learning need Contact our coach and consultants and understand in depth Block your seat 2 4 6 1 3 5 Relate to how it can help you Talk to the trainer for more clarity Continuously learn and apply the learning

21. Connect with us now! Talk to our consultant USA: +1 (832) 924 0564 You can also email us at info@spoclearn.com IND: +91 83417-05065 support@Spoclearn.com UK: +44 807 164 0572