COURSE DESCRIPTION


Preparing excel MIS reports at your job must be your common and routine work, Companies wants from their employees to have these reports regularly on time basis. if you are one of them, then you must consider undergoing the Advance Excel Training . We offers professional advance excel training

Microsoft Excel workbook is one of the most commonly used tools to summerize and present data - When you know all advance excel techniques, this tool can perform that work with ultimate efficiency. Axis Education Institute is an excellent and top advance excel training institute in Ajman,You can learn all about Advance excel like Macros, MIS, Pivot Table, Advance Dashboard, Lookup Functions, Filters from Axis and start doing it yourself as an expert. Our Advance Excel Training includes lab assignment and projects for better understanding, Our expert advance excel trainer and contents makes us premium advance excel training institute in UAE.

LEARNING OBJECTIVES :

To prepare students to demonstrate understanding and ability to use the Excel in the following areas:

  • Creating data boxes for financial accounting
  • Using multiple sheets in a workbook to prepare financial reports
  • Preparing professional quality statements for external reporting
  • Creating graphing to interpret business results
  • Using Excel functions to evaluate accounting data

SYLLABUS :


CONDITIONAL FORMATTING & SPARKILNES :

  • Formatting data on Conditions
  • Finding top 5 / 10 items in the Data
  • Clearing & Managing Rules
  • Adding data based on two attributes
  • Highlight Duplicate & Unique Values
  • Formatting data using Data Bars & Icons
  • Summarizing a data based on single attribute
  • Nested loops

SUMMAIZING & CONSOLIDATING DATA :

  • Creating Sub Totals
  • Advance Filtering on more than 1 criteria
  • Tips of copying Filtered data to New File
  • Sorting data with Multiple Level Sorts
  • Extracting Unique Values with filtering

PIVOT TABLE & SLICER :

  • Creating Pivot table & analyzing data
  • Creating sheets from Pivot table
  • Table creation & text to column
  • Creating Virtual Fields
  • Changing Source
  • Refreshing & Changing Pivot Table Range
  • Calculations & Creating Dynamic Pivot
  • Defining Name & work with tables
  • Creating more than one Pivot table on one sheet
  • Slicer

LOOKUPS AND DATA TABLE :

  • Picking data based on row criteria
  • Match and indexing
  • Data Tables more than one variable
  • Excel speech on data entry
  • Slicer
  • Analyzing data based on column criteria
  • Data Tables single variable
  • Data Entry Forms
  • Creating Grade sheet/Result sheet for performance Creating data list in excel

CHARTS & VALIDATION :

  • Creating Column, Line & Pie Charts
  • Changing Chart type
  • Method of pasting chart into PowerPoint
  • Creating Drop Downs in cell
  • Hyperlinking
  • Shortcuts of Creating Charts
  • Adding Target Line in chart
  • Creating two axis chart & advance charting
  • Sharing Workbook • Inserting object

DATA MINING :

  • Auditing spread sheet
  • Identifying source cells
  • Tracing dependent cell
  • Quick summary of data
  • Using Attendance data to calculate payroll
  • Changing source data year on year
  • Rearranging the data in required sequence

MACROS :

  • Record macros for automating tasks
  • Macro with Keyboard & its benefit
  • Creating Button to run a Macro
  • Run / Delete a macro

DATA SECURITY IN MS EXCEL :

  • File Level Security
  • Making the worksheets invisible
  • Limiting access to cell
  • Sheet Level Security
  • Preventing Sheets from Deletion Cell / Row / Column Level Security

FORMULA :

  • Statistical : Count, CountA, CountIF, CountIFs, & CountBlank
  • Change Case: Upper, Lower & Proper
  • AND & OR in IF Condition
  • & Conatenate, Sum, SumIF & SumIFs
  • Logica l: If Condition with Multiple IF’s, Using
  • Lookup : Advance & Multiple Vlookup & Hlookup