8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / LEVEL 3 DIPLOMA IN MICROSOFT EXCEL 2016
Level 3 Diploma in Microsoft Excel 2016 ( 8 REVIEWS )
536 STUDENTS
Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day …
TAKE THIS COURSE
£299.00 £17.00
1 YEAR
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
1/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
LEVEL 3 - DIPLOMA COURSE BADGE COURSE CERTIFICATE
160
NUMBER OF UNITS
2
NUMBER OF QUIZZES
2 DAYS, 13 HOURS
HOME
CURRICULUM
REVIEWS
Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales gures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime.
Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the ‘Search and replace’ data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles De ne and re ne page layouts for printing options https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
2/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Managing large workbooks through worksheet tab formatting and using di erent views Options for general customization, language, formula, proo ng and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel’s version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-de ned functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from di erent sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data ltering and sorting Creating PivotTables and PivotCharts, and ltering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in di erent formats and protecting reports
Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your nal exam you will have the opportunity to test your pro ciency with a mock exam.
Certi cation: After completing and passing the course successfully, you will be able to obtain an Accredited Certi cate of Achievement. Certi cates 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? Level 3 Diploma in Microsoft Excel 2016 is certi ed by CPD Quali cations Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
3/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
As there is no experience and quali cation required for this course, it is available for all students from any academic background.
Requirements Our Level 3 Diploma in Microsoft Excel 2016 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 con dence to enrich yourself and brighten up your career in the relevant job market. COURSE CURRICULUM
Module : 1
Identify the Elements of the Excel Interface
00:30:00
Activity – Identify the Elements of the Excel Interface
00:05:00
Create a Basic Worksheet
01:00:00
Activity – Create a Basic Worksheet
00:05:00
Use the Help System
00:30:00
Activity – Use the Help System
00:05:00
Create Formulas in a Worksheet
01:00:00
Activity – Create Formulas in a Worksheet
00:05:00
Insert Functions in a Worksheet
00:30:00
Activity – Insert Functions in a Worksheet
00:05:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
4/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Reuse Formulas
00:30:00
Activity – Reuse Formulas
00:05:00
Manipulate Data
00:30:00
Activity – Manipulate Data
00:05:00
Insert, Manipulate, and Delete Cells, Columns, and Rows
00:30:00
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
00:05:00
Search For and Replace Data
00:30:00
Activity – Search For and Replace Data
00:05:00
Spell Check a Worksheet
00:30:00
Activity – Spell Check a Worksheet
00:05:00
Modify Fonts
00:30:00
Activity – Modify Fonts
00:05:00
Add Borders and Colors to Cells
01:00:00
Activity – Add Borders and Colors to Cells
00:05:00
Apply Number Formats
00:30:00
Activity – Apply Number Formats
00:05:00
Align Cell Contents
00:30:00
Activity – Align Cell Contents
00:05:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
5/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Apply Cell Styles
00:30:00
Activity – Apply Cell Styles
00:05:00
De ne the Basic Page Layout for a Workbook
01:00:00
Activity – De ne the Basic Page Layout for a Workbook
00:05:00
Re ne the Page Layout and Apply Print Options
00:30:00
Activity – Re ne the Page Layout and Apply Print Options
00:05:00
Format Worksheet Tabs
00:30:00
Activity – Format Worksheet Tabs
00:05:00
Manage Worksheets
00:30:00
Activity – Manage Worksheets
00:05:00
Manage the View of Worksheets and Workbooks
00:30:00
Activity – Manage the View of Worksheets and Workbooks
00:05:00
Customize General and Language Options
00:30:00
Activity – Customize General and Language Options
00:05:00
Customize Formula Options
00:30:00
Activity – Customize Formula Options
00:05:00
Customize Proo ng and Save Options
01:00:00
Activity – Customize Proo ng and Save Options
00:05:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
6/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Customize the Ribbon and Quick Access Toolbar
00:30:00
Activity – Customize the Ribbon and Quick Access Toolbar
00:05:00
Customize the Functionality of Excel by Enabling Add-Ins
00:30:00
Activity – Customize the Functionality of Excel by Enabling Add-Ins
00:05:00
Customize Advanced and Trust Center Options
00:30:00
Activity – Customize Advanced and Trust Center Options
00:05:00
Activities and Exercise Files – Microsoft Excel 2016 for Beginners
00:00:00
Module : 2
Apply Range Names
00:30:00
Use Specialized Functions
00:30:00
Use Text Functions
00:30:00
Use Logical Functions
00:30:00
Use Lookup Functions
00:30:00
Use Date Functions
00:30:00
Use Financial Functions
00:30:00
Create and Modify Tables
00:30:00
Sort and Filter Data
00:30:00
Use Subtotal and Database Functions to Calculate Data
00:30:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
7/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Create Charts
00:30:00
Modify and Format Charts
00:30:00
Create a Trendline
00:30:00
Create Advanced Charts
00:30:00
Create a PivotTable
00:30:00
Filter Data by Using Slicers
00:30:00
Analyze Data with PivotCharts
00:30:00
Insert and Modify Graphic Objects
00:30:00
Layer and Group Graphic Objects
00:30:00
Incorporate SmartArt
00:30:00
Customize Workbooks
00:30:00
Manage Themes
00:30:00
Create and Use Templates
00:30:00
Protect Files
00:30:00
Preparing a Workbook for Multiple Audiences
00:30:00
Activities and Exercise Files – Microsoft Excel 2016 Intermediate
00:00:00
00:15:00
Module : 3
Update Workbook Properties
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
8/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Activity-Update Workbook Properties
00:05:00
Create and Edit a Macro
00:15:00
Activity-Create and Edit a Macro
00:05:00
Apply Conditional Formatting
00:15:00
Activity-Apply Conditional Formatting
00:05:00
Add Data Validation Criteria
00:15:00
Activity-Add Data Validation Criteriaty
00:05:00
Trace Cells
00:15:00
Activity-Trace Cells
00:05:00
Troubleshoot Invalid Data and Formula Errors
00:15:00
Activity-Troubleshoot Invalid Data and Formula Errors
00:05:00
Watch and Evaluate Formulas
00:15:00
Activity-Watch and Evaluate Formulas
00:05:00
Create a Data List Outline
00:15:00
Activity-Create a Data List Outline
00:05:00
Create Sparklines
00:15:00
Activity_Create Sparklines
00:05:00
Create Scenarios
00:15:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
9/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Activity-Create Scenarios
00:05:00
Perform a What-If Analysis
00:15:00
Activity-Perform a What-If Analysis
00:05:00
Perform a Statistical Analysis with the Analysis ToolPak
00:15:00
Activity-Perform a Statistical Analysis with the Analysis ToolPak
00:05:00
Create Interactive Data with Power View
00:15:00
Activity-Create Interactive Data with Power View
00:05:00
Consolidate Data
00:15:00
Activity-Consolidate Data
00:05:00
Link Cells in Di erent Workbooks
00:15:00
Activity-Link Cells in Di erent Workbooks
00:05:00
Merge Workbooks
00:15:00
Activity-Merge Workbooks
00:05:00
Export Excel Data
00:15:00
Activity-Export Excel Data
00:05:00
Import a Delimited Text File
00:14:00
Activity- Import a Delimited Text File
00:05:00
Activity-Integrate Excel Data with the Web
00:05:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
10/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Activity-Integrate Excel Data with the Web
00:05:00
Create a Web Query
00:15:00
Activity-Create a Web Query
00:05:00
Import and Export XML Data
00:15:00
Activity-Import and Export XML Data
00:05:00
Activities and Exercise Files – Microsoft Excel 2016 Advanced
00:00:00
Module : 4
Create a Macro Using the Macro Recorder
01:00:00
Edit a Macro
01:00:00
Debug a Macro
00:30:00
Customize the Quick Access Toolbar and Hotkeys
00:30:00
Set Macro Security
01:00:00
Insert Text
00:30:00
Format Text
00:30:00
Sort Data
00:30:00
Duplicate Data
01:00:00
Generate a Report
01:00:00
Determine the Dialog Box Type
00:15:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
11/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Capture User Input
01:00:00
Insert, Copy, and Delete Worksheets
00:30:00
Rename Worksheets
00:30:00
Modify the Order of Worksheets
00:15:00
Print Worksheets
00:30:00
Create User-De ned Functions
00:30:00
Automate SUM Functions
00:30:00
Activities and Exercise Files – Microsoft Excel 2016 and VBA
00:00:00
Module : 5
Enable and Navigate
00:30:00
Import Data from Various Data Sources
01:00:00
Refresh Data from a Data Source
00:30:00
Create Linked Tables
00:30:00
Organize and Format Tables
00:30:00
Create Calculated Columns
00:30:00
Sort and Filter PowerPivot Data
00:30:00
Create and Manage Table Relationships
01:00:00
Create PivotTables
01:00:00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
12/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Create PivotCharts
00:30:00
Create Power Views
01:00:00
Filter Data Using Slicers
00:30:00
Present PivotTable Data Visually
01:00:00
Manipulate PowerPivot Data Using DAX Functions
01:00:00
Extract Data from Tables Using Functions
00:30:00
Save Reports in Di erent File Formats
01:00:00
Work with Time Dependent Data
00:30:00
Protect Reports
00:30:00
Activities and Exercise Files – Microsoft Excel 2016 PowerPivot
00:00:00
00:30:00
00:30:00
Mock Exam
-
Mock Exam- Level 3 Diploma in Microsoft Excel 2016
Final Exam
-
Final Exam- Level 3 Diploma in Microsoft Excel 2016
COURSE REVIEWS
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
13/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
4.9 8 ratings
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
RELATED COURSES
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
14/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Microsoft Excel Basics
£199.00 £10.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
492
15/21
8/13/2018
Microsoft O
Level 3 Diploma in Microsoft Excel 2016 - John Academy
ce Essential Skills
£269.00 £14.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
488
16/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Workplace Essential Training: Team Player
£199.00 £10.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
588
17/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Workplace Essential Training: Collaboration
£199.00 £10.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
564
18/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Progressive Employer Training
£199.00 £10.00
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
583
19/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Microsoft Power BI
£199.00 £10.00 527
536 STUDENTS ENROLLED
HAVE YOU ANY INQUIRY?
https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
20/21
8/13/2018
Level 3 Diploma in Microsoft Excel 2016 - John Academy
Full Name *
Your Email *
Telephone
Message *
By submitting your information, you agree to the terms and conditions stated in our Privacy Policy
Submit
ABOUT We are a company who is best known for o ering awarding body accredited courses for anyone who wishes to take their professional life to the next level. 11 Floor, 15 St Botolph Street, London EC3A 7BB 020 3744 3990 info@johnacademy.co.uk CERTIFICATE CODE Enter Certi cate Code https://www.johnacademy.co.uk/course/level-3-diploma-in-microsoft-excel-2016/
21/21