Microsoft Excel for Data Analysis

√ ● Focus Area
√ Navigate Microsoft Excel
● How Microsoft excel works & its setup
● Customising
√ Short cut keys
● Frequently used keys
● Quick Access Tool bar
√ Formatting
● Number , Currency , Date , Text & Custom
√ Conditional Formatting
● Basic Conditions such as Highlighting duplicate ..etc.
● Setting Rules
● Managing Rules
√ Filtering & Advance Filtering
● Sorting
● Selection
● Adding Levels
√ Frequently used Formulas
● IF Formula
● Vlookup formula
● Sumif Formula
● Countif Formula
● Other Useful formulas
√ Graphs
● Creating Charts ( Line , Bar & Pie)
● Legend
● Labeling
● Positioning
● Customising
√ Pivot Tables
● Pivot
● Pivot Table Field
● Display Classic Pivot
● Change Source Data/Refresh
● Search Field
● Analytical Tool ( Through Selection )
● Additional Calculations
● Quick Sheets
● Insert Blank Line ( Field Setting )
● Repeat Printing Header
● Design Customisation
● Pivot creation using two or more source data
√ Page setup & Print
● Print Area setup
● Repeat Header
● Background setup
√ Data Protection & Validation
● Listing & Alerting
● Grouping
● Cell / Sheet / Workbook Protection
√ Macro
● Recording & Performing
√ Other
● Insert Shape / Symbol / Hyperlink / etc..

Call for Flexible Training : 0772295201

අමතන්න