Simfotix
 

Business EXCELerator Class

Overview

Microsoft Excel has always been a top recommended application for business users for making simple to complex calculations, data presentation analysis and on top work efficiently and productively. We have seem business user going home late just because they don’t know the right use of this useful program, you may work with little knowledge but true value comes when you work efficiently with maximum use of formulas, features and tricks in this wonderful application. Get ready to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application available in market.

WHO SHOULD ATTEND

For every individual, it will be a valuable resource which will help them in their professional life. This course is specially designed for Finance, HR, Admin and Management level individuals, who have basic skills with Microsoft Excel and now want to enhance their skills to optimize the performance of their work using this wonderful software.

COURSE OUTLINE
EXCEL SPEEDY TIPS and TRICKS
  • Power Shortcuts
  • Power Tricks to increase speed
  • Commenting Data
  • Pro recommended concepts and features
REMOVING DRYNESS
  • Working with Font, Colors and Borders
  • Format Custom Number Formats
  • Instant Formatting with Format Painter
  • Search and Replace Formats
  • Format as Table
RULE THE FORMATTING WITH CONDITIONS
  • Highlight Cells with Highlight Rules
  • Highlight Top values with Top Bottom Rules
  • Creating In-Cell Bars with Data Bars
  • Analyze Matrix Data with Color Scales
  • Better Visualization with Icons Sets
EXCEL FUNCTIONS
  • Understanding Excel Functions
  • Summarizing Data with Power Functions
    • SUMIFS, COUNTIFS
  • Manipulating Data with Logical Functions
    • IF, AND, OR, IFERROR
ETL PROCESS (EXTRACT, TRANSFORM AND LOAD)
  • Extract Data from a Cell
  • Extract Data from Excel Master Data
  • Extract Data from a Database
MANAGING YOUR LIST PRO
  • Apply Subtotal Function for Filtered Sum
    • Grouping and Ungrouping
    • Remove Duplicates
  • Advance Filter
  • Restrict Users with Data Validation
BRINGING DATA TO ONE PLACE
  • Using the Manual Consolidation Option of Excel
  • Using the Auto Consolidation Option of Excel
SECURITY ESSENTIALS
  • Levels of Protection
  • Securing File with Password
  • Protect Sheet / Workbook
  • Anti-Protection Software
THE ANALYST - PIVOT TABLE AND SLICERS
  • Creating a Pivot Table
  • Formatting a Pivot Table
  • Sorting Filtering Pivot Tables
  • Adding Removing Fields from Pivot Tables
  • Applying different styles to Pivot Table Fields
  • Creating Pivot Charts
  • Analyzing Data with PivotTable
  • Adding Slicers
INTRODUCTION TO POWER PIVOT
  • Introduction to Power Pivot
  • Importing Data Tables into Power pivot
  • Importing External Data
  • Creating Relationship
  • Exporting data
POWER VIEW – THE REPORTING TOOL
  • Creating Power view
  • Interface of Power view
  • Creating quick with power view charts
  • Creating reports with power cards and decks
PRESENTING DATA – SPARKLINES AND DYNAMIC CHARTS
  • Basic Chart Types
  • When to use which Chart
  • Line Chart
  • Column / Bar Chart
  • Pie Chart
  • X / Y or Scatter Chart

Testimonials