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