MS Excel Power User

Excel Power User

Create Powerful Interactive Dashboards

  • Investment

    9000 6500

  • Course Duration

    10 Days

What you'll learn

  • Analyze data and create reports in a fraction of the time of spreadsheets
  • How to approach an Excel dashboard project from idea to delivery
  • How to add interactivity to your Excel reports - No VBA required
  • Clever use of Excel core functionality for responsive spreadsheets
  • Learn how to create a professional stunning dashboard from scratch for Sales & Marketting, Accounts & Finance, Projects, HR, Admin and IT Departments
  • Create impressive, non-standard Excel charts using smart techniques
  • Use powerful visual techniques so your content has more effect
  • Build Pivot Table-based dashboards for easy interactivity
  • Impress management with reports that make the decision-making process faster
  • Dealing with Raw Data
  • A Foundation in Dashboards
  • Useful Excel Keyboard Shortcuts
  •  
  • 4 Time-Saving Tips for Excel
  • Proper Spreadsheet Architecture & Workflow
  • Advanced Filtering
  • Interactive Features to Create User Friendly Reports
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Using Excels PROPER() Function on Text
  • Create Consistency with Excels UPPER() Function
  • Microsoft Excels Paste Special Feature
  • Replace Meaningless Data with Excels CHOOSE() Function
  • Extract Date Values Using Excels TEXT() Function
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Dashboard Source Data and Formats
  • Source: Text/Data/CSV File - Linking of files which helps automation of data updation
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Preparing the Data Using Format As Table
  • Creating a Drop Down Menu with Data Validation
  • Looking Up Data with Excels VLOOKUP() Function
  • Cleaning Up Data with Excels IF() Function
  • INDEX() and MATCH() an Alternative to VLOOKUP()
  • Index for Dynamic List Selection
  • SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria
  •  
  • LARGE and SMALL for Sorting
  • ROW(S), COLUMN(S) for Indexing
  • ROW as Unique Identifier for Lookups
  •  
  • GetPivotData: Extract data Efficiently from Pivot Tables
  • INDIRECT for Flexible References
  • Choose & Name Manager for Flexible Ranges (Alternative to Indirect)
  •  
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Introduction to Form Controls - Active X vs. Form Controls
  • Combo Box - Select From a Drop Down List
  • Check Box - Check / Uncheck Option
  • Spin Button - Move Up & Down Lists
  • Option Button - Choose One Option Only
  • List Box - Select From a List of Option
  • Scroll Bar - Scroll Through Graphs & Tables
  • Dependent Combo Boxes
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Chart Overview & When to Use Which Graph
  • Chart Basics (for those who need to get familiar with basic features)
  • Add Total Values to Stacked Column Charts
  • Add Series Labels Inside Chart
  • Error Bars for Additional Control
  • Pro Technique: Changing Chart Ranges
  • Info-graphics in Excel: Non-standard but Impressive Bar Chart
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Variances in Pivot Table
  • Conditional Formatting in Pivot Table
  •  
  • Pivot Table as Part of Dashboard Report
  • Pivot Charts in Dashboards
  • Automatically Refresh Pivot Table with Simple VBA code
  •  
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Info Charts: Adding Shapes to (Pivot) Charts
  • Info Charts: Overcoming Pivot Chart Limitations
  •  
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Camera for Improved Design
  •  
  • Advanced Camera - Lookups on Pictures
  •  
  • Dynamic Map Chart with Drop-down
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Creating Interactive Charts with Slicers
  • Modifying the Chart Slicer
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Hiding Extra Worksheets and Columns
  • Cleaning Up the Excel Default Settings
  • Hiding the Chart and Resetting the Slicer (VBA)
  • Protecting the Dashboard
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
Bonus
  • Resume Building Free (Originally Rs.2500)
  • Community of Life Long Learners Free (Originally Rs. 25,000)
  • Interview Skills Free (Originally Rs.2500)
  • Life Long access to Community of Life Coaches, Motivational Speakers, Digital Influencers who keep inspiring you to lead happy and fulfilling life Free (Originally Priceless)
  • Exclusive FB Group Free (Originally Priceless)

Congratulations! You Became an absolute EXCEL POWER USER