Course Description
This training program provides you with the fundamental competencies for Microsoft Excel.
Basic Microsoft Excel teaches you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Basic skill sets are discussed in more detail, exploring at a higher-level different options that can be applied for that skill set.
Intermediate Microsoft Excel is designed for learners who want to expand their knowledge in Improving, Formatting, Organizing Data and Highlighting Key Information and Key Formulas / Links between sheets. The course advances the user’s knowledge of functions, demonstrate how to manage data with excel and explore the dashboard feature of Excel.
Pre-requisites
Participants must have basic computer skills and must bring their own laptop to apply lessons and work on exercises.
Learning Objectives
By the end of this course, the participants shall be able to:
- Operate basic and intermediate functions of Microsoft Excel
- Navigate user interface & tools with ease
- Perform Calculations in Excel
- Create, modify, format and print worksheets or workbooks
- Use Excel Data reference
- Create Charts and Dashboards
- Consolidate data and manage Excel content
- Audit Workbooks and Trace Error for corrections
Course Topic Highlights
1. Creating a Basic Worksheet
2. Explore User Interface & Ribbon
3. Customize the Quick Access Toolbar
4. Performing Calculations
5. Basic Formulas & Functions
6. Modifying a Worksheet
7. Search for Data in a Worksheet
8. Spell Check a Worksheet
9. Formatting a Worksheet
10. Cell Styles
11. Print Options & Page Breaks
12. Managing Large Workbooks
13. Excel Data Reference
14. Defining Names in Excel
15. Using Functions: Info, Date & Database
16. Creating Charts & Dashboards
17. Design Options & Chart Format Tools
18. Data Consolidation: Sorting & Filtering
19. Managing Excel Content
20. Conditional Formatting
21. Auditing Workbooks
22. Formula Auditing and Error Tracing
23. Error Checking
24. Track Changes
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-basic-intermediate/
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.
