MAXIMIZING MICROSOFT EXCEL FOR BASIC & INTERMEDIATE USERS

Maximizing Microsoft Excel for Basic & Intermediate Users


Venue: Suite 1503A, West Tower, Philippine Stock Exchange Bldg., Exchange Road, Ortigas Center, Pasig City

Schedule 2020: https://businessmaker-academy.com/microsoft-excel-basic-intermediate/
Course Description
Conducted by a Certified Microsoft Trainer, this 2-day hands-on seminar provides you with the fundamental know-how and 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. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher-level different options that can be chosen or 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.
- Participants must bring their own laptop to apply lessons and work on exercises.

What You Will Learn
• Operate basic and intermediate functions of Microsoft Excel
• Navigate user interface and 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 Highlights:
1. Creating Basic Worksheet
2. Explore User Interface & Ribbon
3. Navigate and Select in Excel
4. Customize the Quick Access Toolbar
5. Create, Modify, Format Basic Worksheets
6. Calculate with Formulas and Functions
7. Printing Workbook Contents
8. Managing Large Workbooks
9. Format Worksheet Tabs
10. Managing and Viewing Large Worksheets in a Workbook
11. EXCEL DATA REFERENCE
12. Defining Names in Excel
13. Using Functions with Excel
14. Creating Charts and Dashboards
15. Chart Desgin options, Format Tools & Combo Charts
16. Data Consolidation
17. Conditional Formatting
18. Formula Auditing
19. Change Tracking
20. Error Tracing

Who Should Attend:
This course is intended for novice information workers who want to learn beginning to intermediate level Excel skills. Administrative Officers, Finance Officers, Department Managers, Assistants and all office workers who want to learn essential functions of Microsoft Excel program must attend this course.

Seminar Duration: 2 day, 9am to 5pm

Seminar Rate: Early Bird Rate - Php8,500 +VAT | Regular Rate - Php9,500 +VAT

Contact Us:

(632) 6874645, 6873416, 6874445

(0917) 5699639, (0922) 8874445

[email protected]

Visit: www.businessmaker-academy.com