Microsoft Excel from Beginner to Advanced Level

Mastering the Microsoft Excel Application for Productivity

4.21 (38 reviews)

Udemy

platform

English

language

Other

What you will learn

Understand the Microsoft Excel from the Basic to Advanced Level

Master the use to Microsoft Excel Tools, Commands and Functions

Learn Microsoft Excel Defined Functions and Formulas used in calculations and Office Tasks

Understand how to handle Large Data, Manipulate, Summarized and Generate Reports

Understand the Power of Data Analysis using Microsoft Excel

Master how to use PIVOT TABLE and PIVOT CHART to create Dynamic Reports and Charts

Understand the POWER of VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, CHOOSE, INDEX & MATCH in Data and Financial Analysis

Understand DATA VALIDATION, CONSOLIDATION and Using SUB TOTAL tool for creating Subtotals Calculation for grouped Items

Working with Charts (Column, Pie, Bar, Line Chart and lot more. Editing Charts and working on Chart Designs

Understanding Alignment Tools, Text and Number Formatting, and Excel Cell and Table Style Formatting

Working Tables, Inserting Pictures and Images into Excel Worksheet, and using Text Boxes in Excel

Working with Cell and Range Names for Data Analysis and Calculations. Managing Names, and creating Names from Selections

Using Sparklines Column and Line Charts for Horizontal and Vertical in-cell Charts.

Using Hyperlink Tools to create Links to Worksheets, External Files, websites and Email from Excel Worksheet

Removing Duplicate Transactions, Text or Number from large range of data

Working with Conditional Formatting Tools on Large Data e.g Sales Data

Most courses ignore Basic fundamental tools, which can many task easy. This Course seeks to Address all major TOOLS in Excel

Creating and Working with Dashboards - Slicer and Timeline Tool.

Creating Sensitivity Analysis using the What-If-Analysis Tools (Goal Seek, Data Table, Solver and Scenarios)

Working with Logical Functions (IF, AND & OR and NESTING the IF Functions)

Understanding Project Evaluation Techniques using Financial Functions (PV, FV, NPV & IRR)

Introduction to Excel Macros and VBA Automations (Macros Recording, codes, User Form creation, VBA Controls and Objects)

As a Microsoft Excel Certified Expert, I guarantee that this Course will also help you to pass Certification Exams as it uses Examples that we help participant familiarize with Key Excel Tools.

Microsoft Excel from Beginner to Advanced Level

What you will learn

Understand the Microsoft Excel from the Basic to Advanced Level

Master the use to Microsoft Excel Tools, Commands and Functions

Learn Microsoft Excel Defined Functions and Formulas used in calculations and Office Tasks

Understand how to handle Large Data, Manipulate, Summarized and Generate Reports

Understand the Power of Data Analysis using Microsoft Excel

Master how to use PIVOT TABLE and PIVOT CHART to create Dynamic Reports and Charts

Understand the POWER of VLOOKUP, SUMIF, SUMIFS, COUNTIF, COUNTIFS, CHOOSE, INDEX & MATCH in Data and Financial Analysis

Understand DATA VALIDATION, CONSOLIDATION and Using SUB TOTAL tool for creating Subtotals Calculation for grouped Items

Working with Charts (Column, Pie, Bar, Line Chart and lot more. Editing Charts and working on Chart Designs

Understanding Alignment Tools, Text and Number Formatting, and Excel Cell and Table Style Formatting

Working Tables, Inserting Pictures and Images into Excel Worksheet, and using Text Boxes in Excel

Working with Cell and Range Names for Data Analysis and Calculations. Managing Names, and creating Names from Selections

Using Sparklines Column and Line Charts for Horizontal and Vertical in-cell Charts.

Using Hyperlink Tools to create Links to Worksheets, External Files, websites and Email from Excel Worksheet

Removing Duplicate Transactions, Text or Number from large range of data

Working with Conditional Formatting Tools on Large Data e.g Sales Data

Most courses ignore Basic fundamental tools, which can many task easy. This Course seeks to Address all major TOOLS in Excel

Creating and Working with Dashboards - Slicer and Timeline Tool.

Creating Sensitivity Analysis using the What-If-Analysis Tools (Goal Seek, Data Table, Solver and Scenarios)

Working with Logical Functions (IF, AND & OR and NESTING the IF Functions)

Understanding Project Evaluation Techniques using Financial Functions (PV, FV, NPV & IRR)

Introduction to Excel Macros and VBA Automations (Macros Recording, codes, User Form creation, VBA Controls and Objects)

As a Microsoft Excel Certified Expert, I guarantee that this Course will also help you to pass Certification Exams as it uses Examples that we help participant familiarize with Key Excel Tools.

Enjoy access to a CERTIFIED MICROSOFT EXCEL EXPERT with over 2 Decades in Spreadsheet Analysis using MICROSOFT EXCEL