Power USER Mastering MS Excel - Simfotix
 
×
  • One Day Training Workshop
  • Two Day Traning Workshop

Power USER Mastering MS Excel - Two Days – with Mini Projects

Two Days – with Mini Projects
Summarizing & Consolidating Data
  • Working with Data Tables & its practical usage
  • Using Paste Special (In depth)
  • Advanced Subtotals
  • Adding and Copying with Subtotals
  • Consolidating Data
  • Formatting data on Conditions
  • Highlight Duplicate & Unique Values
  • Formatting data using Data Bars & Icons
  • Clearing & Managing rules
What-If Scenarios
  • Scenario Concepts
  • Creating Scenarios
  • Managing Scenarios
  • Scenario Reports
Solver
  • Solver Concepts
  • Defining the Problem
  • Solving the Problem
  • Solver Reports
  • Solver Options
Charts/Graphs & Techniques
  • Recommended Charts
  • Trend lines
  • Sparkline’s charts
  • Saving Custom Chart as Template
  • Formatting and Editing a series
Filter, Sorting & Conditional Formatting
  • Creating Sub Totals
  • Extracting Unique Values with Filtering
  • Multi column Sort
  • Filter ( By Values, By Cell Color, By Font Color , By Cell Icon )
  • Format As a table
Advanced Validation
  • Controlling The Limits Of Numeric Data
  • Dropdown List
  • Date Controls
  • Text Length Control
  • Specialized Custom Formula Control
  • Custom Formula
Advanced Formula & Powerful Functions
  • Auditing Formulas
  • Shrinking the Formula Bar
  • Using Custom Formatting Codes
  • Using Paste Special
  • Using Date Functions
  • Using Bizarre Date Functions
  • SUMIF & SUMIFS
  • Using Array Formulas
  • Looking at AutoSum Tricks
Advanced Lookup Function
  • A step ahead with VLOOKUP; Multi-worksheet, Multi-list, Nested VLOOKUP
  • Understanding HLOOKUP
  • MATCH / INDEX as a universal replacement to VLOOKUP/HLOOKUP
  • Using the Offset Function
  • Indirect & Flash Fill
  • Remove Duplicates
Summarizing Data Using Pivot Tables
  • Creating Pivot table & Analyzing data
  • Doing calculation & making pivot dynamic
  • Calculating variances with pivot
  • Grouping data in pivot tables
  • Formatting a pivot table
  • Selecting elements of a pivot table
  • Making use of multiple data fields
  • Using grand totals and subtotals
  • Changing a pivot table’s calculations
Getting Started with PowerPivot
  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables
Reporting – Create Amazing Power View Reports
  • Reports with multiple views in Power View in SharePoint
  • Share Power View reports
  • Share Power View in Excel
  • Share Power View in SharePoint reports (RDLX files)
  • Print Power View reports
  • Set Power View reporting properties in Power Pivot
Set Power View reporting properties in Power Pivot
  • Creating Functional Macros
  • Recap of creating macros
  • Extend your knowledge of the use of macros
  • Adding a message box
  • Display a form
  • Recording Macros for Automating tasks
  • Macro with Keyboard & its benefit
  • Creating global macros

Gallery

Testimonials