infyni Kids

MS Excel - Advanced

Suitable for beginners, fresh recruits and middle level managers, classes are held twice a week for those who are working. Whether you are running your own business, or managing your own finance, this live training in excel is an essential skill that will pay off at any workplace.

Live Course

Live Class:

Enrolled: 0

Duration: 24 Hours

Offered by: infyni

Live Course

$204.44

About Course

Excel Advanced course focuses on more advanced features beyond the Microsoft Excel Course Basics and Intermediate. Advanced analysis tools including data linking, data consolidation and outlining and summarizing are covered, as are PivotTables, Lookup Functions, and some key automation features such as macros. Learn how to import data, create Data Tables and Scenarios for What If analysis, techniques to validate data, and create form controls such as List and Combo Boxes to make data entry easier.

Skills You Will Gain

Master advanced formulas and functions (e.g., INDEX/MATCH, XLOOKUP, array formulas). Expertise in PivotTables, Power Query, and Power Pivot for data analysis. Proficiency in creating dynamic dashboards, charts, and data visualizations. Automation of repetitive tasks using Macros and VBA.
  • Topics
  • Instructor (1)
1 Setting Excel Options
  • Understanding Excel Options, Personalising Excel, Setting the Default Font, Setting Formula Options, Understanding Save Options, Setting Save Options, Setting the Default File Location, Setting Advanced Options
  • Understanding Data Importing, Importing From an Earlier Version, Understanding Text File Formats, Importing Tab Delimited Text, Importing Comma Delimited Text, Importing Space Delimited Text, Importing Access Data, Working With Connected Data, Unlinking Connections
  • Understanding Grouping and Outlining, Creating an Automatic Outline, Working With an Outline, Creating a Manual Group Grouping by Columns
  • Creating Subtotals, Using a Subtotal Worksheet, Creating Nested Subtotals, Copying Subtotals, Using Subtotals with AutoFilter, Creating Relative Names for Subtotals, Using Relative Names for Subtotals
  • Understanding Data Lookup Functions, Using Vlookup, Using HLookup, Using XLookup
  • Understanding Data Consolidation, Consolidating With Identical layouts, Creating a Linked Consolidation, Consolidating From Different Layouts, Consolidating Data Using the SUM Function
  • Understanding Data Tables and What-If Models, Using a Simple What-If Model, Creating a One-Variable Table, Using One-Variable Data Tables, Creating a Two-Variable Data Table
  • Understanding Scenarios, Creating a Default Scenario, Creating Scenarios, Using Names in Scenarios, Displaying Scenarios Creating a Scenario Summary Report, Merging Scenarios
  • Understanding Slicers, Creating Slicers, Inserting a Timeline Filter, Using Compound Fields, Counting in a PivotTable Formatting PivotTable Values, Working With PivotTable Grand Totals, Working With PivotTable Subtotals, Finding the Percentage of Total, Finding the Difference From Grouping in PivotTable Reports, Creating Running Totals, Creating Calculated Fields, Providing Custom Names, Creating Calculated Items, PivotTable Options, Sorting in a PivotTable
  • Inserting a PivotChart, Defining the PivotChart Structure, Changing the PivotChart Type, Using the PivotChart Filter Field Buttons, Moving Pivot Charts to Chart Sheets
  • Understanding Data Validation, Creating a Number Range Validation, Testing a Validation, Creating an Input Message Creating an Error Message, Creating a Drop-Down List Using Formulas as Validation Criteria, Circling Invalid Data Removing Invalid Circles, Copying Validation Settings
  • Understanding the Power Query Editor in Excel, Deleting rows, columns, or blanks, Filtering out data you don’t need, Fixing the layout so it will work in a PivotTable, Splitting or joining columns or text, Removing spaces and special characters from your data, Merging worksheets, text/CSV files together Extracting data from an external database, Incorporating the next month’s data to an existing report
  • Understanding Excel Macros, Saving a Document as Macro Enabled, Recording a Simple Macro, Running a Recorded Macro, Relative Cell References, Running a Macro with Relative References, Viewing a Macro, Editing a Macro, Assigning a Macro to the Toolbar, Running a Macro from the Toolbar Assigning a Keyboard Shortcut to a Macro, Deleting a Macro, Copying a Macro
  • What is an Excel dashboard? Differences from Reports, How to create an Excel Dashboard, Create a layout for your Dashboard, Get your Data into Excel, Clean raw data, Use an Excel Table and filter the data, Analyse, Organize, Validate and Audit your Data, Choose the right chart type for your Excel dashboard, Select Data and build your chart, Create a Dashboard Scorecard, Best practices for creating visually effective Excel Dashboards, Excel Dashboards Do’s and Don’ts, Excel, Dashboard Examples

...
Surendra Reddy
About Instructor

I have 14+ years of Corporate Experience and 5+ years Training Experience on MS Office i.e. MS Excel, MS PowerPoint, MS Outlook, MS Word and Email Etiquettes. I provide MS Office Trainings for Corporates and Individuals. I am Certified Trainer and I have done Certification in MO 200 (MS Office Excel Specialist).

0

Rating

0

Reviews

5

Students

4

Courses