Description
MS Excel 2016 has various functions. It engages people to maintain documents, business resource, calculations, making so many effective works at an instance. If you want to more about its functions, you may have a look at the MS Excel 2016 Advanced course.
The MS Excel 2016 Advanced course is designed in such a way that will enable students to learn about the advance issues of MS Excel including AVERAGEIF, COUNTIF, and SUMIF functions. It also incorporates advanced lookup features such as VLOOOKP and HLOOKUP, INDEX, and MATCH, and difficult logical and textual functions. The purpose of the course is to make the students expert on auditing formulas including learning the methods of worksheet and workbook safety, IF Analysis types of equipment, functions of Pivot Tables and PowerPivot add-in, use of Macros, and the assurance of data reliability in the worksheet and workbooks.
Assessment:
This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.
Certification:
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
MS Excel 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
Requirements
Our MS Excel 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Course Curriculum
Introduction | |||
Introduction | FREE | 00:01:00 | |
Using Advanced IF Statements | |||
Summarize Data with SUMIF | 00:04:00 | ||
Summarize Data with AVERAGIF | 00:03:00 | ||
Summarize Data with COUNTIF | 00:02:00 | ||
Using Advanced Lookup Functions | |||
Using VLOOKUP with TRUE to find an Approximate Match | 00:04:00 | ||
Using HLOOKUP TRUE to find an Approximate Match | 00:01:00 | ||
Using the Index Function | 00:03:00 | ||
Using the Match Function | 00:02:00 | ||
Creating a Combined Index and Match Formula | 00:04:00 | ||
Comparing Two Lists with VLOOKUP | 00:02:00 | ||
Comparing Two Lists with VLOOKUP and ISNA | 00:04:00 | ||
Using Complex Logical and Text Functions | |||
Creating a Nested IF Function | 00:03:00 | ||
Using the IFERROR Function | 00:02:00 | ||
Using the LEN Function | 00:02:00 | ||
Using the TRIM Function | 00:01:00 | ||
Using the Substitute Function | 00:02:00 | ||
Formula Auditing | |||
Showing Formulas | 00:01:00 | ||
Tracing Cell Precedents and Dependents | 00:03:00 | ||
Adding a watch Window | 00:02:00 | ||
Error Checking | 00:02:00 | ||
What-If Analysis Tools | |||
Using the Scenario Manager | 00:03:00 | ||
Using Goal Seek | 00:02:00 | ||
Analyzing with Data Tables | 00:02:00 | ||
Worksheet and Workbook Protection | |||
Protection Overview | 00:02:00 | ||
Excel File Password Encryption | 00:03:00 | ||
Allowing Specific Worksheet Changes | 00:01:00 | ||
Adding Protection to only Certain Cells in a Worksheet | 00:03:00 | ||
Additional Protection Features | 00:02:00 | ||
Advanced Use of PivotTables and PowerPivot | |||
Using the Pivot Tables Charts Wizard | 00:02:00 | ||
Adding a Calculated Field | 00:02:00 | ||
Adding a Caculated Item | 00:02:00 | ||
Apply Conditional Formatting to a Pivot Table | 00:03:00 | ||
Using Filters in the Pivot Table Fields Pane | 00:02:00 | ||
Creating Filter Pages for a Pivot Table | 00:01:00 | ||
Enabling a Power Pivot Add In | 00:04:00 | ||
Automating with Macros | |||
What are Macros | 00:03:00 | ||
Displaying the Developer Tab and Enabling Macros in Excel | 00:03:00 | ||
Creating a Basic Formatting Macro | 00:03:00 | ||
Running a Macro | 00:02:00 | ||
Assigning a Macro to a Button | 00:02:00 | ||
Creating a More Complex Macro | 00:02:00 | ||
Viewing and Editing the VBA Code for an Existing Macro | 00:03:00 | ||
Adding a Macro to the Quick Access Toolbar | 00:02:00 | ||
Working with Form Controls | |||
What are Form Controls | 00:02:00 | ||
Adding Spin Buttons and Check Boxes to a Spreadsheet | 00:02:00 | ||
Adding a Combo Box to a Spreadsheet | 00:02:00 | ||
Ensuring Data Integrity | |||
What is Data Validation | 00:01:00 | ||
Restricting Data Entries to Whole Numbers | 00:02:00 | ||
Data Validation Restricting Data Entry to a List | 00:01:00 | ||
Data Validation Restricting Data Entry to a Date | 00:01:00 | ||
Data Validation Restricting Data Entry to Different Text Lengths | 00:01:00 | ||
Composing Input Messages | 00:02:00 | ||
Composing Error Alters | 00:02:00 | ||
Finding Invalid Data | 00:02:00 | ||
Editing and Deleting Data Validation Rules | 00:01:00 | ||
Collaborating in Excel | |||
Working with Comments | 00:03:00 | ||
Printing Comments and Errors | 00:02:00 | ||
Sharing a Workbook | 00:04:00 | ||
Tracking Changes in a Workbook | 00:03:00 | ||
Working with Versions | 00:02:00 | ||
Sharing Files via Email | 00:02:00 | ||
Importing and Exporting Data to a Text File | |||
Importing a Text File | 00:03:00 | ||
Exporting a Text File | 00:01:00 | ||
Conclusion | |||
Course Recap | 00:01:00 | ||
Assessment |
Course Reviews
No Reviews found for this course.