MS Excel Power House

Excel Power House

Intermediate & Advanced Level

  • Investment

    10,000 7500

  • Course Duration

    15 Days

What you'll learn

  • Learn from Intermediate to Advance level Excel
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most Popular Tools, Pivot Tables and Dashboards
  • Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
  • Master data analysis tools like Goal Seek, Scenario Manager, Solver and other Analysis Tools
  • Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Build Powerful Advanced Excel Projects From Scratch
  • Build Gantt charts in Excel for project planing
  • Exploit Excels built in advanced functions to do things "regular" users think are impossible!
  • Build Interactive Dashboard Reports with Buttons and Drop Down Menus
  • Impress management with your new version of expertise on most sort out tool_MS Excel
  • Introduction to the Excel Interface
  • Customizing the Excel Quick Access Toolbar
  • Power pack of shortcut keys
  • Entering and Editing Text and Formulas
  • Relative Versus Absolute Cell References in Formulas
  • Working with Basic Excel Formulas & Functions
  • Modifying an Excel Worksheet
  • Formatting Data in an Excel Worksheet & Using Conditional Formatting
  • Inserting Images and Shapes into an Excel Worksheet
  • Creating Basic Charts in Excel
  • Printing an Excel Worksheet
  • Working with Excel Templates
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Excel Function: DSUM()
  • Excel Function: DAVERAGE()
  • Excel Function: DCOUNT()
  • Excel Function: SUBTOTAL()
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy.
  • Understanding the Need for Data Validation
  • Creating a Validation List
  • Adding a Custom Validation Error
  • Dynamic Formulas by Using Validation Techniques
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Importing Data from Text Files
  • Importing Data from any Web Page
  • Exporting Data to a Text File
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Understanding Excel PivotTables
  • Creating an Excel PivotTable
  • Modifying Excel PivotTable Calculations
  • Grouping PivotTable Data
  • Formatting PivotTable Data
  • Drilling Down into PivotTable Data
  • Creating PivotCharts
  • Filtering PivotTable Data
  • Create interactive dashboards using Pivot Tables and Quick Buttons
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Why PowerPivot?
  • Activating the Excel Power Pivot Add In
  • Creating Data Models with PowerPivot
  • Creating Pivot Tables based on Data Models
  • Power Pivot Calculated Fields
  • Power Pivot KPIs
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Using the Freeze Panes Tool
  • Grouping Data (Columns and/or Rows)
  • Print Options for Large Sets of Data
  • Linking Worksheets (3D Formulas)
  • Consolidating Data from Multiple Worksheets
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Working with Excel Name Ranges
  • Using Excel's IF() Function
  • Nesting Functions
  • Using Excel's COUNTIF() Function
  • Using Excel's SUMIF() Function
  • Using Excel's IFERROR() Function
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Using Excel's VLOOKUP() Function
  • Using Excel's HLOOKUP() Function
  • Using Excel's INDEX() and MATCH() Functions
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Using Excel's LEFT(), RIGHT() and MID() Functions
  • Using Excel's LEN() Function
  • Using Excel's SEARCH() Function
  • Using Excel's CONCATENATE() Function
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Tracing Precendents in Excel Formulas
  • Tracing Dependents in Excel Formulas
  • Working with the Watch Window
  • Showing Formulas
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Protecting Specific Cells in a Worksheet
  • Protecting the Structure of a Workbook
  • Adding a Specific Worksheet or Workbook Password
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy
  • Working with Excel's Goal Seek Tool
  • Working with Excel's Solver Tool
  • Building Effective Data Tables in Excel
  • Creating Scenarios in Excel
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 HOUSE