Advanced Excel 2016 Online Training Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Advanced Excel 2016 Training Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.
To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.
The training materials of this Advanced Excel 2016 Online Training Course are available online for you to learn at your own pace and fast-track your career with ease.
- Accredited by CPD
- Instant e-certificate
- Fully online, interactive course with Professional voice-over
- Self paced learning and laptop, tablet, smartphone friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
Sneak Peek Advanced Excel 2016 Online Training Course
Who Should Take The Advanced Excel 2016 Online Training Course
Anyone with a knack for learning new skills can take this Advanced Excel 2016 Online Training Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.Certification
Once you’ve successfully completed your Advanced Excel 2016 Course, you will immediately be sent a digital certificate. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.Accreditation
All of our courses, including this Advanced Excel 2016 Online Training Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.Assessment
At the end of the Advanced Excel 2016 Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.Course Curriculum
Introduction Using Advanced IF Statements Using Advanced Lookup Functions Using Complex Logical and Text Functions Formula Auditing What-If Analysis Tools Worksheet and Workbook Protection Advanced Use of PivotTables and PowerPivot Automating with Macros Working with Form Controls Ensuring Data Integrity Collaborating in Excel Importing and Exporting Data to a Text File Conclusion Course Certification
We guarantee that all our online courses will meet or exceed your
expectations. If you are not fully satisfied with a course - for
any reason at all - simply request a full refund. We guarantee no
hassles. That's our promise to you.
Go ahead and order with confidence!
Easy to Access
Let's Navigate Together
Course Curriculum
| Introduction | |||
| Introduction | |||
| Using Advanced IF Statements | |||
| Summarize Data with SUMIF | |||
| Summarize Data with AVERAGIF | |||
| Summarize Data with COUNTIF | |||
| Using Advanced Lookup Functions | |||
| Using VLOOKUP with TRUE to find an Approximate Match | |||
| Using HLOOKUP TRUE to find an Approximate Match | |||
| Using the Index Function | |||
| Using the Match Function | |||
| Creating a Combined Index and Match Formula | |||
| Comparing Two Lists with VLOOKUP | |||
| Comparing Two Lists with VLOOKUP and ISNA | |||
| Using Complex Logical and Text Functions | |||
| Creating a Nested IF Function | |||
| Using the IFERROR Function | |||
| Using the LEN Function | |||
| Using the TRIM Function | |||
| Using the Substitute Function | |||
| Formula Auditing | |||
| Showing Formulas | |||
| Tracing Cell Precedents and Dependents | |||
| Adding a watch Window | |||
| Error Checking | |||
| What-If Analysis Tools | |||
| Using the Scenario Manager | |||
| Using Goal Seek | |||
| Analyzing with Data Tables | |||
| Worksheet and Workbook Protection | |||
| Protection Overview | |||
| Excel File Password Encryption | |||
| Allowing Specific Worksheet Changes | |||
| Adding Protection to only Certain Cells in a Worksheet | |||
| Additional Protection Features | |||
| Advanced Use of PivotTables and PowerPivot | |||
| Using the Pivot Tables Charts Wizard | |||
| Adding a Calculated Field | |||
| Adding a Caculated Item | |||
| Apply Conditional Formatting to a Pivot Table | |||
| Using Filters in the Pivot Table Fields Pane | |||
| Creating Filter Pages for a Pivot Table | |||
| Enabling a Power Pivot Add In | |||
| Automating with Macros | |||
| What are Macros | |||
| Displaying the Developer Tab and Enabling Macros in Excel | |||
| Creating a Basic Formatting Macro | |||
| Running a Macro | |||
| Assigning a Macro to a Button | |||
| Creating a More Complex Macro | |||
| Viewing and Editing the VBA Code for an Existing Macro | |||
| Adding a Macro to the Quick Access Toolbar | |||
| Working with Form Controls | |||
| What are Form Controls | |||
| Adding Spin Buttons and Check Boxes to a Spreadsheet | |||
| Adding a Combo Box to a Spreadsheet | |||
| Ensuring Data Integrity | |||
| What is Data Validation | |||
| Restricting Data Entries to Whole Numbers | |||
| Data Validation Restricting Data Entry to a List | |||
| Data Validation Restricting Data Entry to a Date | |||
| Data Validation Restricting Data Entry to Different Text Lengths | |||
| Composing Input Messages | |||
| Composing Error Alters | |||
| Finding Invalid Data | |||
| Editing and Deleting Data Validation Rules | |||
| Collaborating in Excel | |||
| Working with Comments | |||
| Printing Comments and Errors | |||
| Sharing a Workbook | |||
| Tracking Changes in a Workbook | |||
| Working with Versions | |||
| Sharing Files via Email | |||
| Importing and Exporting Data to a Text File | |||
| Importing a Text File | |||
| Exporting a Text File | |||
| Conclusion | |||
| Course Recap | |||