| Topics | Coverage |
| Gathering and processing data for reports | Organizing Data & Processing Data |
| Summarizing Data | Graphs Templates & Graphs |
| Analysing Data for Decision Making | Projecting differences in Data & What-if analysis |
| Exchanging Data between various resources | Loading & Transferring Data from various sources |
| Collaborating with other users | Protecting information and allowing simultaneous access |
| Automating the Business Operations | VBA, Macros |
| Data Cleansing Tools | Using Data filters, sorting, Sub-Totals, Find & Replace |
| Pivot Tables | Creating Pivot Tables & Charts |
| Conditional Formatting & Data Validation | Create, Edit & Manage rules, creating dynamic lists |
| Sub-Totals, Grouping/Ungrouping | Using various Data Grouping Techniques |
Who should take this course - This course is for anyone from a student to a working professional who wants to start a career in Analytics or wants to enhance knowledge in Excel.
Benefits – Understand Basic Excel, VBA and Macros. Get the NIIT Edge with a globally recognized certificate.
This is short term program and can be covered in a weeks time on fast track.
View this Course
Certified
You have 
