Course Description
This 2-day hands on course will provide you with the knowledge of more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Prerequisites
-Participants must have basic Excel knowledge and must bring their own laptop to apply the lessons and work on exercises.
Learning Objectives
By the end of this course, the participants shall be able to:
- Identify & define the essential components of Excel formulas
- Perform advanced formulas
- Identify how to format financial statements & other Excel-based reports effectively
- Perform data security & validation
- Create Excel-based charts and dashboards to aid in communicating financial data information
- Manage big data in Excel
- Use data analysis tools & pivot features
- Get introduced to macro functions & features
Course Topic Highlights
1. Essential Components of Excel Formulas
2. Relative Value & Absolute Value
3. Calculate Data Across Worksheets
4. Performing Advanced Formulas
5. Simplify Number Functions
6. Create Solutions Using Text Methods
7. Streamline Aging Report
8. Using IF Condition & Logical Functions: SUMIF, COUNTIF, AVERAGEIF
9. Lookup Functions
10. How to Format Financial Statements & Other Excel-based Reports
11. Advanced Conditional Formatting & Filtering
12. Custom Data Formats, Styles & Templates
13. Perform Data Security & Validation
14. Using Input & Drop-down Tool for Validation
15. Read-only Protected Sheet & Workbook
16. File Protection Method
17. Excel-based Charts & Dashboards for Communicating Financial Data Info
18. Application of Subtotal per Data Category
19. Managing Big Data in Excel
20. Advanced Filter with Name Manager and Logical Symbols
21. Data Analysis Tools Using Pivot Features
22. Introduction to Visual Basic & Macro Settings
Here are the rates:
Webinar Rate
Php4500 +12%VAT = Php5040
Seminar Rate
Php8500 +12%VAT = Php9520
Full details & Registration:
https://businessmaker-academy.com/live-webinar-microsoft-excel-advanced-training/
For more inquiries, you may contact us at:
Landline: (632) 8687-4645, 8687-341
Mobile/Viber: (0917) 6372471, (0912) 2231826, (0917) 1357279
Email:
aW5mbyB8IGJ1c2luZXNzbWFrZXItYWNhZGVteSAhIGNvbQ==
www.businessmaker-academy.com
You may also like the following events from Businessmaker Academy:
Also check out other
Workshops in Pasig,
Virtual events in Pasig.
