•   +971 6 5504 881

  •   +971 562 301 830

  •  admin@leadseducation.com

COURSE

DATA ANALYSIS AND REPORTING TECHNIQUES WITH EXCEL


...

Our Specialities

Experienced & Professional Trainers
Certification Questions & Answers
Cloud Server Access
Assingments &
Case Studies
Configuration Materials Soft-Copy
Recorded Session Videos

Course Structure

  •     Consolidating Data from Separate Files and Sheets
  •     Advanced Data Validation Using Lists, Dates and Custom Validation
  •     Array Functions
  •     Cell Management Tools: Left, Right, Mid, Concatenate, Value
  •     Naming Cells and Ranges
  •     Subtotal, Sumif, Sumifs, Sumproduct
  •     Looking-Up Data, Texts, and Values Using Vlookup
  •     The Incredible Table Tools Techniques
  •     Slicing Dates into Day Names, Month Names, Years and Quarters
  •     Text to Columns and Dynamic Trimming Using Trim, Len
  •     Find and Substitute
  •     Text Change Functions

  •     Creating Pivot Tables
  •     Number Formatting Techniques
  •     Designing Report Layout
  •     Sorting in Ascending, Descending and More Sort Options
  •     Filtering Labels and Values
  •     Expanding and Collapsing Reports
  •     Summarize Data By Sum, Average, Minimum, Maximum, Count
  •     Show Values as % of Total & % of …
  •     Pivot Table Options
  •     Inserting Formulas
  •     Date Analysis
  •     Copying Pivot Tables
  •     Creating Pivot Charts
  •     Dynamic Chart Labeling
  •     Mastering the Slicer
  •     Showing Report Filter Pages
  •     Linking Pivot Tables and Pivot Graphs with PowerPoint
  •     Conditional Formatting with Pivot Tables
  •     Designing Reports Using the GetPivotData

  •     Spinner
  •     Check Box Data Modeling with IF function
  •     Option Box Data Modeling with IF function
  •     List Box Data Modeling with CHOOSE function
  •     Scenario Manager

  •     Data Entry Form
  •     Custom List
  •     Text to Speech
  •     Protecting Worksheet

ENQUIRE NOW

Subscribe
Our Newsletter