MICROSOFT EXCEL (ADVANCED LEVEL)
Online Training by
OTC Training Centre Sdn Bhd
Inquire Now
Online
/ Training
Details
INTRODUCTION FOR MICROSOFT EXCEL (ADVANCED LEVEL)
This course will give you a deep understanding of the useful Excel functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Focus on what each Functions does, hands-on, contextual
examples designed to showcase why these Functions are awesome and how they can be applied in several ways and how to troubleshoot formulas. Manipulating data using analysis tools, password settings and record actions using macros.
COURSE OBJECTIVES
-
Mastering the use of some of Excel’s most popular and highly sought-after functions (VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
-
Audit Excel Worksheet formulas to ensure clean formulas
-
Worksheets and Workbooks protection
-
Usefulness of the What-If Analysis
-
Automate your day-to-day Excel tasks by mastering the power of Macros
Outline
COURSE CONTENT
Excel List Functions
- Introduction to Excels Function: DSUM()
- Excel DSUM Function Single Criteria Continued
- Excel DSUM Function with OR Criteria
- Excel DSUM Function with AND Criteria
- Excel Function: DAVERAGE()
- Excel Function: DCOUNT()
- Excel Function: SUBTOTAL()
Working with Excel’s Conditional Functions
- Using Excel’s IF() Function
- Excel’s IF() Function with a Name Range
- Nesting Functions with Excel
- Nesting Excels AND() Function within the IF() Function
- Using Excel’s COUNTIF() Function
- Using Excel’s SUMIF() Function
- Using Excel’s IFERROR() Function
Working with Excel’s Lookup Functions
- Microsoft Excel VLOOKUP() Function
- Microsoft Excel HLOOKUP() Function
- Microsoft Excel INDEX() Function
- Microsoft Excel MATCH() Function
- Microsoft Excel INDEX() and MATCH() Function Combined
- Microsoft Excel INDEX() and MATCH() Function Combined Continued
- Creating a Dynamic HLOOKUP() with the MATCH() Function
Auditing an Excel Worksheet
- Tracing Precedents in Excel Formulas
- Tracing Dependents in Excel Formulas
- Working with the Watch Window
- Showing Formulas
Protecting Excel Worksheets and Workbooks
- Protecting Specific Cells in a Worksheet
- Protecting the Structure of a Workbook
- Adding a Workbook Password
Mastering Excel’s “What If?” Tools
- Working with Excel’s Goal Seek Tool
- Working with Excel’s Solver Tool
- Building Effective Data Tables in Excel
- Creating Scenarios in Excel
Automating Repetitive Tasks in Excel with Macros
-
Understanding Excel Macros
-
Activating the Developer Tab in Excel
-
Creating a Macro with the Macro Recorder
-
Creating Buttons to Run Macros
Special Offer
Register 3 Participants From Your Organization And Get The 4th Participant For Free!
The promotion expiry date for each programmes differs. For more information on the exact expiry date of the promotion, feel free to contact us.
OTC Training Centre Sdn Bhd may at any time in its sole and absolute discretion withdraw, amend and/or alter the terms and conditions of the stated promotions without prior notice.
The promotion expiry date for each programmes differs. For more information on the exact expiry date of the promotion, feel free to contact us.
OTC Training Centre Sdn Bhd may at any time in its sole and absolute discretion withdraw, amend and/or alter the terms and conditions of the stated promotions without prior notice.
Schedules
| No. of Days: | 2 |
| Total Hours: | 14 |
Reviews
Be the first to write a review about this course.
Write a Review
OTC Training Centre Sdn Bhd is an innovation leader in the development and delivery of practical outsourcing training programs for the past 17 years. Since then, OTC has supported thousands of companies to upskills their employees with personalized content and learning solutions. Today, we have evolved to provide a full suite of outsourcing services in the learning and development field.
Our training programs are entitled to HRDCorp claim, with our trainers being certified by HRDCorp as well. As a training provider, we aspire to keep providing the best training to our respected clients to ensure their satisfaction while using our service as the training provider.
Related Courses
OTC Training Centre Sdn Bhd
OTC Training Centre Sdn Bhd
OTC Training Centre Sdn Bhd
OTC Training Centre Sdn Bhd
