MS Excel Training - 6 Weeks Program

EXCELTHE SKILLS WITH ENRICHED EXPERIENCE

  • Gain Practical Knowledge - in class and through assignments
  • know how to work on variety of data and how to use it more efficiently using excel as tool 
  • Learn various formulas and functions
  • Learn how to analyze the data and present data
  • Gain knowledge on those skills which are actually relevant and used in any dataset

WHO SHOULD ATTEND? 

  • Working managers - who daily come across some data for working and reading
  • Entrepreneurs - how to use data using excel and using the same to uplift business activities
  • Junior Management level - gain excel skills & insights to step further in corporate hierarchy
  • Relevant to any industry where excel is main source to look into business insights
COURSE STRUCTURE - LEVEL 1 & 2 (BASIC AND ADVANCE)
  • Level 1 - Understanding Spreadsheet and Basic Working
    • Table & font formatting - Size, Color, format, alignment etc
    • Filters - to find & select the particular scenario
    • Merge/Demerge
    • Cut, Copy,Paste, Paste Special
    • Merge & Wrap
    • Number alignments & formatting
    • Print Setup - Page Break
    • Comments - Addition, Edit, Delete
  • Level 1 - Getting familiar with Data on excel - Numbers, Text, Date etc
    • Data formatting
    • Data cleaning - Trim. Substitute, Proper
    • Text to column
    • Duplicates removal
  • Level 1 - Understanding the Functions used in daily corporate life
    • Pivot tables & Charts - Summary format to see data in tables
    • Basic Formulas - Sum, average, multiplication, division etc
    • Data cleaning formulas - Trim, proper etc so that formulas can be applied
    • Using conditional formatting - Highlight the cells based on conditions
    • Creating drop down & validation
    • Freeze, Unfreeze, Group, Ungroup. Hide, Unhide
    • Sorting - Number, Text, additional criteria to sort
  • Level 2 - Learning the Advance function for analyzing data
    • To find value from various sheets - Vlookup, Hlookup, Lookup
    • To add the numbers specific to different criterias - Sumif, Sumifs
    • To count the numbers with/without criteria - Count, countif, countifs
    • To provide & see the rank - Ranking
    • Conditional Formulas - using If, or, and
    • Date Functions
    • Chart preparations - Usage & preparations
  • Level 2 - Data Reading and Analyzing using formulas & functions
    • Understanding data and usage
    • Driving the output from given data using the functions & formulas learnt
  • Level 2 - Creating dashboards - One layout to see all the outcome
  • Add Ons - PowerPoint - making best use of data analysis on presentations

 

When and where

Excel Training - Dubai (2020)

Saturday, March 14, 2020 to April 18, 2020 - Total 6 Saturdays

From 6:00 PM to 9:00 PM

Arabian Infotech Training Institute

Contact Number: +971 4 2281166