Excel has been the most effective Data Analysis & Reporting tool for years. However, with its recent developments and extensive use of these features, it is now regarded as an effective and amazing Presentation tool as well. Excel provides flexibility to manipulate and orient data with utmost ease and with minimal effort.
Excel has been the most effective Data Analysis & Reporting tool for years. However, with its recent developments and extensive use of these features, it is now regarded as an effective and amazing Presentation tool as well. Excel provides flexibility to manipulate and orient data with utmost ease and with minimal effort. This workshop will drill down to the overview of Excel tools, basic functions, tools that are mostly used to operate Excel effectively that would enhance the effectiveness and efficiency. Afterward, drill down to advance functions, reporting & presentation tools. The workshop will also demonstrate 3 projects in the form of Human Resources, Sales & Marketing, and Finance Dashboard.
Key Learnings
- Understanding the working decorum of MS Excel
- Develop detailed understanding of the Excel Tabs & Tools
- Adapt with the most effective Tools & Techniques of Excel
- Do Minor Modifications in an Excel Document
- Handle Errors in Excel
- Print & Protect Excel
- Work with the most essential Advance Functions in Excel
- Prepare reports and data visualizations
- Overview of Excel BI Tool
- Create Real-life Dashboard Reports
Target Audience
- People who use or planning to use Excel extensively
Training Deliverables
- Exercise Files for practice
- Full Video recording of the training (for online classes)
- Certificate of Participation (optional; can be designed and distributed by Organizer)
Pre-requisites to Participate
- Should have Basic knowledge about Computer operation.
- Use Microsoft Office 2007 or
- Maximum Participants per batch is 25 (for on-site classes) 50 (for online classes).
Course Module
- Introduction of Excel
- Referencing & Tools
- Create Logical Formulas
- Text Function & Number Formats
- Excel Statistical Functions for Data Consolidation
- Lookup & References
- Data Visualization
- Pivot Table
- Overview of Excel Business Intelligence Tool – Power Query
- Three Business Projects & Feedback