Sale!

Demo Advanced Microsoft Excel with Dashboarding in Power BI (starts 2nd September)

1,000 

WHY SHOULD YOU LEARN ADVANCED MICROSOFT EXCEL?

  • Saves Time: Excel helps you make the machine work for you on tasks that would otherwise take hours to do manually. This saves you a lot of time
  • Prepares you for better roles: All higher roles in industries require the employee to know Advanced Excel. This course will help you learn it and prepare you for these roles.
  • Reduces Work: Automating your daily tasks helps improve efficiency and eventually reduces your work by more than 30%. You’ll be less busy using Excel and do your work in the right manner.

WHY THIS COURSE?

  • Learn live from the expert
  • Practice on Real Life Datasets
  • Detailed notes for each lecture
  • Guaranteed Doubt Solving
  • Certified Course
  • Limited batch size
  • Recordings to be provided

Description

ABOUT THE INSTRUCTOR

  • Microsoft Certified Excel Expert

INDUSTRIES WHERE MICROSOFT EXCEL IS USED ON A DAILY BASIS:

  • Finance
  • Accounting
  • Marketing
  • Sales
  • Operations
  • Consulting
  • HR
  • Data Science

IS YOUR EXISTING KNOWLEDGE OF MS EXCEL ENOUGH?

Check if your knowledge of Microsoft Excel is enough according to industry standards!

COURSE DATES

This is a 24 hours certified course on Advanced Excel. The demo session for  this will be held on 2nd September 2020, Wednesday at 7.30 to 8.30 pm

COURSE CURRICULUM

Crash Course on Basics of Excel

  • Introduction to Excel Interface
  • Font Formatting & Alignment Tools
  • Number Formatting Options
  • Navigation Shortcuts
  • Lists in Excel & Creating Custom Lists
  • Sorting & Filtering
  • Conditional Formatting
  • Format Painter
  • Alt Key Custom Shortcut Creation
  • Tables and Importance of Tables

Advanced Formulas (Basics Covered)

  • Understanding when to use what formula
  • Mathematical Formulas
  • Logical Operators
  • Statistical Formulas
  • Conditional Formulas
  • Look Up Formulas
  • Index Match
  • Financial Formulas
  • Types of common errors and their solution

Advanced Data Visualization (Basics Covered)

  • Selecting the correct chart for your data
  • Bar & Column Charts
  • Line Chart
  • Pie & Donut Chart
  • Scatter Plots
  • Histogram & Pareto Charts
  • Waterfall Chart
  • Heat Maps & Sparklines
  • Dynamic Dropdown Charts (Advanced)
  • Dynamic Spin Button Charts (Advanced)

Pivot Tables

  • Understanding the importance of Pivot Table
  • Inserting a Pivot Table
  • Understanding Field List Contents
  • Using Pivot Tables to Analyse Data
  • Formatting in Pivot Tables
  • Grouping of Data
  • Slicers
  • Timelines
  • Interactivity of Slicers

Dashboards with Power BI

  • Creating a Coronavirus Dashboard for India from Scratch
  • Creating a Bank Dashboard from Scratch
  • Understanding Visual Interactivity
  • Understanding different filters available in Power BI
  • Analyzing Dashboards to get key insights from your data
  • Knowing how to create 8+ visuals in Power BI

Advanced Excel Tips & Tricks

  • Interactivity between Excel and Powerpoint
  • Grouping your data
  • Hiding data
  • Autosum
  • Quickest way to insert charts
  • Protecting your data
  • Multiple other techniques which will truly make you an Advanced Excel Expert

Reviews

There are no reviews yet.

Be the first to review “Demo Advanced Microsoft Excel with Dashboarding in Power BI (starts 2nd September)”

Your email address will not be published. Required fields are marked *

Title:
Demo Advanced Excel

Time:
September 2, 2020, 7:30 pm

Timezone:
Asia/Calcutta

Scroll to top
Register for next session We will inform you when the product arrives in stock. Just leave your valid email address below.
Email We won't share your address with anybody else.
Open chat
Powered by