Diploma in Microsoft Excel 2016

Microsoft Excel is considered the industry-standard spreadsheet software, and is used across a range of different business areas and job roles for a variety of statistical, engineering and financial needs. Enhance your employability and provide real value to your employer with a professional qualification in Excel, gaining advanced expertise of formulas, creating macros, workbook management and pivot tables in the process.

Description

Become an accomplished Microsoft Excel professional with this engaging, innovative online distance learning course. Through exercises that put knowledge gained from video and handout lessons into practice, you will master higher Excel functions such as performing statistical analyses, creating and editing macros, and utilising advanced formulas, as well as broader business administration and IT skills.

Benefits of studying with Victoria Education include:

• Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
• No hidden fees or costs - study a professional course and earn a professional e-certificate upon successful completion
• Get instant feedback from automated assessments and mock exams to gauge your progress
• No formal deadlines or teaching schedule, meaning you can learn at your own pace
• 24/7 help and support from your online tutors, through email and via our live online chat
• Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

Who is this course for?

Our course is aimed at anyone wishing to start working in a range of business and administration roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

CPD

How is this qualification delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

• Video lessons
• PDF handouts
• Mock exams
• Online assessment
• These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Course Curriculum

Section 1

• Finding your way around the interface
• Exercise: Finding your way around the interface
• Creating a worksheet in Excel
• Exercise: Creating a worksheet in Excel
• Accessing help documents
• Exercise: Accessing help documents
• Inserting formulas
• Exercise: Inserting formulas
• Creating functions
• Exercise: Creating functions
• Copying formulas
• Exercise: Copying formulas
• Inserting and editing data
• Exercise: Inserting and editing data
• Editing cells, columns and rows
• Exercise: Editing cells, columns and rows
• Find and replace data
• Exercise: Find and replace data
• Spellchecking
• Exercise: Spellchecking
• Changing fonts and formats
• Exercise: Changing fonts and formats
• Changing cell styles
• Exercise: Changing cell styles
• Adding number formats
• Exercise: Adding number formats
• Changing cell alignment
• Exercise: Changing cell alignment
• Editing cell styles
• Exercise: Editing cell styles
• Designing a worksheet layout
• Exercise: Designing a worksheet layout
• Preparing your layout for printing
• Exercise: Preparing your layout for printing
• Formatting tabs
• Exercise: Formatting tabs
• Maintaining multiple worksheets
• Exercise: Maintaining multiple worksheets
• Trust centre options
• Exercise: Maintaining multiple worksheets and workbooks
• Language options
• Exercise: Language options
• Formula options
• Exercise: Formula options
• Proofing and saving options
• Exercise: Proofing and saving options
• Navigating the quick access toolbar
• Exercise: Navigating the quick access toolbar
• Analyse data with add-ins
• Exercise: Analyse data with add-ins
• Exercise: Trust centre options
• Exercises: Microsoft Excel for Beginners
• Activities and Exercise Files - Microsoft Excel 2016 for Beginners

Section 2

• Editing range names
• Applying special functions
• Applying text functions
• Applying logical functions
• Applying lookup functions
• Applying date functions
• Applying financial functions
• Inserting tables
• Applying filtering and sorting functions
• Analysing and calculating data with database functions
• Inserting charts
• Customising charts
• Inserting a trendline
• Inserting advanced charts
• Insert a PivotTable
• Using slicers to filter your data
• Analysing data using PivotTables
• Adding graphics
• Grouping graphics
• Using SmartArt
• Managing your workbooks
• Editing themes
• Making and using templates
• Guide to project files
• Exporting your workbook to other audiences
• Exercises: Microsoft Excel Intermediate

Section 3

• Customising the properties of your workbook
• Exercise: Customising the properties of your workbook
• Inserting and updating a macro
• Exercise: Inserting and updating a macro
• Understanding conditional formatting
• Exercise: Understanding conditional formatting
• Applying data validation to your worksheet
• Exercise: Applying data validation to your worksheet
• Using the trace cells function
• Exercise: Using the trace cells function
• Understanding common formula errors and invalid data
• Exercise: Understanding common formula errors and invalid data
• Using watch windows and evaluating data
• Exercise: Using watch windows and evaluating data
• Isolate data lists and create outlines
• Exercise: Isolate data lists and create outlines
• Using sparkline tools
• Exercise: Using sparkline tools
• Forecasting with the scenario manager tool
• Exercise: Forecasting with the scenario manager tool
• How to undertake a what-if analysis
• Exercise: How to undertake a what-if analysis
• Using the Data Analysis ToolPak
• Exercise: Using the Data Analysis ToolPak
• How to create a Power View
• Exercise: How to create a Power View
• Using Excel's consolidation functions
• Exercise: Using Excel's consolidation functions
• How to link cells across workbooks
• Exercise: How to link cells across workbooks
• Merging your workbooks
• Exercise: Merging your workbooks
• Exporting your data
• Exercise: Exporting your data
• Importing data into Excel
• Exercise: Importing data into Excel
• Exercise: Publishing an Excel sheet online
• Exercise: Publishing an Excel sheet online
• Making web queries
• Exercise: Making web queries
• How to import and export XML data
• Exercise: How to import and export XML data
• Exercises: Microsoft Excel Advanced

Section 4

• Using the macro recorder
• Customising your recorded macro
• Troubleshooting your recorded macro
• How to customise your Excel set up
• Securing your recorded macro
• Adding text with macros
• Formatting text with macros
• Sorting data with macros
• Duplicating data with macros
• How to generate a report with macros
• Using dialog boxes with your macros
• Capturing user inputs with macros
• How to edit worksheets with macros
• Renaming sheets with macros
• Modifying sheet order with macros
• How to print worksheets using a macro
• About user-defined functions
• Automate calculations using the SUM function
• Exercises: Microsoft Excel and VBA

Section 5

• Installing the PowerPivot add-in
• Importing outside data with PowerPivot
• How to refresh outside data
• Linking tables with PowerPivot
• Editing tables with PowerPivot
• How to create calculated columns
• Filtering data in PowerPivot tables
• Maintaing table relationships
• Inserting PivotTables
• Inserting PivotCharts
• Generating PowerView sheets
• Using slicers to sort your worksheet data
• Using sparklines and conditional formatting with PivotTables
• Using the DAX functions
• Exporting data from PivotTables
• Exporting to different file formats
• Organising time-sensitive data with DAX
• The importance of workbook protection
• Exercises: Microsoft Excel and PowerPivot

Mandatory units

The course consists of five mandatory units, covering

• Identifying the elements of the Excel interface
• Creating formulas and inserting functions
• Using subtotal and database functions to calculate data
• Creating user-defined functions
• Working with time-dependent data
• And more...

Assessment

The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.

Certification

Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a print copy sent by post for GBP12.

Victoria Education is a leading provider of online training, practical courses and professional accreditation.

Our mission is to make learning accessible, affordable, and available to all, regardless of experience or qualifications.