- Duration / Course length: Upto 3 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut – from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced – Complete Video Course is designed to help 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. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us.Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Creating Sparklines and Mapping Data
Create Sparklines
MapData
Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends Updated on 05 June, 2018
Eligibility / Requirements
Our Microsoft Office 2016 Excel Advanced – Complete Video Course 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.
About John Academy
John Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online course provider, we are aware of the fact that there are a lot of people out there who consider themselves to be very curious learners but the courses that they are interested in are not available at their convenient time and place. So, we have decided to give them a unique opportunity for them to learn and obtain necessary skills in a very convenient way at any time from anywhere.
Who We Are
We are an online course provider who wants to make sure that the students would be able to learn everything there is a need for them to learn regarding the course that they have enrolled in on our site. So, we see to it that they would be provided with the highest possible standard of online learning. That way, students would be able to use it in the real world – the employment world and at their desired field of interests.
Certification
After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.
