[vc_row][vc_column][vc_column_text]
Benefits You will get
- Affordable, engaging & premium-quality e-learning study materials
- Assessment through Tests and Quizzes and instant result
- Internationally recognized accredited qualification
- Dedicated support team working 24/7
- Access to course content on mobile, tablet or desktop from anywhere anytime
- Personalized learning – Learn at your own pace, time and place
- A vast array of fascinating subjects
- Regularly updated contents
Description
This Microsoft Office 2013 Excel Advanced – Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze, and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course.
Requirements:
- Anyone with any academic background can enroll into this course.
- A device with an active internet connection
Assesment:
We assess our learners through quizzes or multiple choice test. This test will be assessed automatically and immediately to give you an instant result.
Certification:
The PDF copy of Certificate of Completion can be claimed at the free of cost. If you need a hardcopy of this certificate, you have to pay an additional payment. The time for PDF certificate turnaround is 24 hours, and for the hardcopy, it is 3-7 working days
[/vc_column_text][/vc_column][/vc_row]
Course Curriculum
-
Update Workbook Properties
00:07:00 -
Create and Edit a Macro
00:15:00
-
Apply Conditional Formatting
00:09:00
-
Add Data Validation Criteria
00:10:00
-
Trace Cells
00:05:00
-
Troubleshoot Invalid Data and Formula Errors
00:12:00
-
Watch and Evaluate Formulas
00:10:00
-
Create a Data List Outline
00:09:00
-
Create Sparklines
00:13:00
-
Create Scenarios
00:12:00
-
Perform a What If Analysis
00:19:00
-
Perform a Statistical Analysis with the Analysis ToolPak
00:06:00
-
Create Interactive Data with Power View
00:10:00
-
Consolidate Data
00:10:00
-
Link Cells in Different Workbooks
00:10:00
-
Merge Workbooks
00:08:00
-
Export Excel Data
00:06:00
-
Import a Delimited Text File
00:09:00
-
Integrate Excel Data with the Web
00:11:00
-
Create a Web Query
00:08:00
-
Mock Exam- Microsoft Office 2013 Excel Advanced – Complete Video Course
00:20:00
-
Final Exam- Microsoft Office 2013 Excel Advanced – Complete Video Course
00:20:00
-
Duration:3 hours, 59 minutes
-
Access:1 Year
-
Units:22
Want to get everything for £149
Take Lifetime Pack
