HOT
blank

Microsoft Excel Masterclass – Beginner to Advanced Level

Business

Rating3.9
Enroll Now

Microsoft Excel Masterclass – Beginner to Advanced Level, available at $44.99, has an average rating of 3.9, with 31 lectures, based on 125 reviews, and has 1078 subscribers.

You will learn about MS Excel skills from beginner to Advanced Confident using Excel for Business Reports Excel Formulas, Functions & keyboard shortcuts Pivot Table and Pivot Charts & Automate reports Creating Excel based dynamic Reports Excel Charts and Graphs and custom based Visualizations Comfort using Complex Formulas and apply formatting Be able to create summary reports quickly Macros and VBA to avoid donkey work This course is ideal for individuals who are Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs or This is the program for everybody who uses Excel daily or For those who love to save his/her precious time to buld quick Reports It is particularly useful for Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs or This is the program for everybody who uses Excel daily or For those who love to save his/her precious time to buld quick Reports.

Enroll now: Microsoft Excel Masterclass – Beginner to Advanced Level

Summary

Title: Microsoft Excel Masterclass – Beginner to Advanced Level

Price: $44.99

Average Rating: 3.9

Number of Lectures: 31

Number of Published Lectures: 29

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 29

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

  • MS Excel skills from beginner to Advanced
  • Confident using Excel for Business Reports
  • Excel Formulas, Functions & keyboard shortcuts
  • Pivot Table and Pivot Charts & Automate reports
  • Creating Excel based dynamic Reports
  • Excel Charts and Graphs and custom based Visualizations
  • Comfort using Complex Formulas and apply formatting
  • Be able to create summary reports quickly
  • Macros and VBA to avoid donkey work

Who Should Attend

  • Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs
  • This is the program for everybody who uses Excel daily
  • For those who love to save his/her precious time to buld quick Reports

Target Audiences

  • Data Analyst, Financial Analyst, Finance Professionals, Sales Managers, Finance Managers, HR professonals, Students, Teachers, CFOs
  • This is the program for everybody who uses Excel daily
  • For those who love to save his/her precious time to buld quick Reports

A good teacher can inspire hope, ignite the imagination, and instill a love of learning

~Bred Henery~

MS Excel is the first choice for any report. Data analysis is an exciting field to get into and the career prospects are amazing. You don’t need to be a math/computer science/coding whiz to land a job in data analysis.

Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. MS Excel is the ultimate choice and widely used to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.

In this Course I will teach you to create some beautiful Excel based Reports by simple techniques in quick time.

WHAT YOU WILL LEARN

  • Simple methods to Excel Reports

  • Using key Shortcuts

  • Formulas and Functions

  • Protect your Reports

  • Subtotals, Sorting, Filter

  • Advanced Filter, Linking of Data and quick Formatting

  • Advanced Skills to create quick Reports

  • Consolidation of Data, Combining and Merging Techniques

  • Pivot Tables & Pivot Charts

  • Vlookup, Xlookup, Advanced Features

  • Macros and VBA

  • Excel Tricks and Techniques

  • Data Validation

  • Quick way to create Reports and Charts

PREREQUISITES

  • Basic Computer knowledge

  • Basic level Excel skills

  • MS office installed (better office 365 or office 2016 and above) on Windows based (but not Mac)

WHO THIS COURSE IS FOR?

  • Finance Manager

  • Students

  • Sales Manager

  • Training Manager

  • Executives

  • HR Managers

  • Analyst

  • Admin

  • Data Analyst

  • Teacher

  • Researcher

  • Excel Lover

  • CFO

Happy Learning !

Thanks & Regards

Asif Hafeez

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Key Excel Shortcuts

Lecture 3: Printing & Layouts

Lecture 4: Print Settings

Lecture 5: Find & Replace, Hide & Unhide, Groups

Chapter 2: Data Sorting, Subtotals, Filter and Advanced Filter

Lecture 1: Download Data Resources

Lecture 2: Complete Lecture

Chapter 3: Data Cleansing Technique

Lecture 1: Data Cleaning

Chapter 4: Conditional Formatting in Reports

Lecture 1: Complete Lecture

Chapter 5: Hyperlinking, Paste Special & Linking of Sheets

Lecture 1: Complete Lecture

Chapter 6: Data Validation & Name Ranges

Lecture 1: Complete Lecture

Chapter 7: Linking Worksheets and Consolidation

Lecture 1: Complete Lecture

Chapter 8: Basic Excel Formulas

Lecture 1: Basic Formulas

Chapter 9: Advanced & Complex Formulas

Lecture 1: Complex Formulas

Chapter 10: Creating Charts & Visual Reports

Lecture 1: Charts

Lecture 2: Sparklines (Mini Charts)

Chapter 11: Pivot Tables and Pivot Charts

Lecture 1: Power of Pivot Tables

Lecture 2: Interractive Reports & Slicers

Chapter 12: Right, Left & Mid Formulas & Flahs Fill replacement

Lecture 1: Magic Tricks

Chapter 13: What-if-Analysis

Lecture 1: Scenarios, Goal Seek & Data Tables

Chapter 14: Report Protections

Lecture 1: Protecting your Reports

Chapter 15: Advanced Vlookup, Xlookup, Index, Match

Lecture 1: Working with Lookups

Lecture 2: Lookup Excercises

Chapter 16: Macros & VBA in Excel

Lecture 1: Recording your first Macro

Lecture 2: Developer Tab & assigning Macros Buttons

Lecture 3: Creating your personal Macro Workbook

Chapter 17: Excel Revolutions (New Excel)

Lecture 1: New Excel (the Awesome tool)

Chapter 18: Additional Contents

Lecture 1: Additional Content: Removing blank cell/rows

Lecture 2: Additional Content: Reporting Values as Thousands, Millions etc.

Instructors

  • Asif Hafeez
    Asif Hafeez
    Microsoft Certified Trainer | MCSA (BI Reporting)

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 5 votes
  • 3 stars: 16 votes
  • 4 stars: 35 votes
  • 5 stars: 68 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024