• LOGIN
  • No products in the cart.

Diploma in Microsoft Excel 2016

4.9( 8 REVIEWS )
537 STUDENTS

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 the Diploma in Microsoft Excel 2016 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

How is this qualification is 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.

Mandatory units

The Diploma in Microsoft Excel 2016 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 PDF Certificate for £12.

Who is this course for?

Our Diploma in Microsoft Excel 2016 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.

Career path

Studying this would benefit a range of careers, but would specifically boost employability in roles including

  • Payroll
  • Accounting
  • Finance
  • Business administration
  • Budgeting
  • Office administration
  • Other professional roles in IT or accounting and finance

Course Curriculum

Section 1
Finding your way around the interface 00:30:00
Exercise: Finding your way around the interface 00:05:00
Creating a worksheet in Excel 01:00:00
Exercise: Creating a worksheet in Excel 00:05:00
Accessing help documents 00:30:00
Exercise: Accessing help documents 00:05:00
Inserting formulas 01:00:00
Exercise: Inserting formulas 00:05:00
Creating functions 00:30:00
Exercise: Creating functions 00:05:00
Copying formulas 00:30:00
Exercise: Copying formulas 00:05:00
Inserting and editing data 00:30:00
Exercise: Inserting and editing data 00:05:00
Editing cells, columns and rows 00:30:00
Exercise: Editing cells, columns and rows 00:05:00
Find and replace data 00:30:00
Exercise: Find and replace data 00:05:00
Spellchecking 00:30:00
Exercise: Spellchecking 00:05:00
Changing fonts and formats 00:30:00
Exercise: Changing fonts and formats 00:05:00
Changing cell styles 01:00:00
Exercise: Changing cell styles 00:05:00
Adding number formats 00:30:00
Exercise: Adding number formats 00:05:00
Changing cell alignment 00:30:00
Exercise: Changing cell alignment 00:05:00
Editing cell styles 00:30:00
Exercise: Editing cell styles 00:05:00
Designing a worksheet layout 01:00:00
Exercise: Designing a worksheet layout 00:05:00
Preparing your layout for printing 00:30:00
Exercise: Preparing your layout for printing 00:05:00
Formatting tabs 00:30:00
Exercise: Formatting tabs 00:05:00
Maintaining multiple worksheets 00:30:00
Exercise: Maintaining multiple worksheets 00:05:00
Trust centre options 00:30:00
Exercise: Maintaining multiple worksheets and workbooks 00:05:00
Language options 00:30:00
Exercise: Language options 00:05:00
Formula options 00:30:00
Exercise: Formula options 00:05:00
Proofing and saving options 01:00:00
Exercise: Proofing and saving options 00:05:00
Navigating the quick access toolbar 00:30:00
Exercise: Navigating the quick access toolbar 00:05:00
Analyse data with add-ins 00:30:00
Exercise: Analyse data with add-ins 00:05:00
Exercise: Trust centre options 00:30:00
Exercises: Microsoft Excel for Beginners 00:05:00
Activities and Exercise Files – Microsoft Excel 2016 for Beginners 00:00:00
Section 2
Editing range names 00:30:00
Applying special functions 00:30:00
Applying text functions 00:30:00
Applying logical functions 00:30:00
Applying lookup functions 00:30:00
Applying date functions 00:30:00
Applying financial functions 00:30:00
Inserting tables 00:30:00
Applying filtering and sorting functions 00:30:00
Analysing and calculating data with database functions 00:30:00
Inserting charts 00:30:00
Customising charts 00:30:00
Inserting a trendline 00:30:00
Inserting advanced charts 00:30:00
Insert a PivotTable 00:30:00
Using slicers to filter your data 00:30:00
Analysing data using PivotTables 00:30:00
Adding graphics 00:30:00
Grouping graphics 00:30:00
Using SmartArt 00:30:00
Managing your workbooks 00:30:00
Editing themes 00:30:00
Making and using templates 00:30:00
Guide to project files 00:30:00
Exporting your workbook to other audiences 00:30:00
Exercises: Microsoft Excel Intermediate 00:00:00
Section 3
Customising the properties of your workbook 00:15:00
Exercise: Customising the properties of your workbook 00:05:00
Inserting and updating a macro 00:15:00
Exercise: Inserting and updating a macro 00:05:00
Understanding conditional formatting 00:15:00
Exercise: Understanding conditional formatting 00:05:00
Applying data validation to your worksheet 00:15:00
Exercise: Applying data validation to your worksheet 00:05:00
Using the trace cells function 00:15:00
Exercise: Using the trace cells function 00:05:00
Understanding common formula errors and invalid data 00:15:00
Exercise: Understanding common formula errors and invalid data 00:05:00
Using watch windows and evaluating data 00:15:00
Exercise: Using watch windows and evaluating data 00:05:00
Isolate data lists and create outlines 00:15:00
Exercise: Isolate data lists and create outlines 00:05:00
Using sparkline tools 00:15:00
Exercise: Using sparkline tools 00:05:00
Forecasting with the scenario manager tool 00:15:00
Exercise: Forecasting with the scenario manager tool 00:05:00
How to undertake a what-if analysis 00:15:00
Exercise: How to undertake a what-if analysis 00:05:00
Using the Data Analysis ToolPak 00:15:00
Exercise: Using the Data Analysis ToolPak 00:05:00
How to create a Power View 00:15:00
Exercise: How to create a Power View 00:05:00
Using Excel’s consolidation functions 00:15:00
Exercise: Using Excel’s consolidation functions 00:05:00
How to link cells across workbooks 00:15:00
Exercise: How to link cells across workbooks 00:05:00
Merging your workbooks 00:15:00
Exercise: Merging your workbooks 00:05:00
Exporting your data 00:15:00
Exercise: Exporting your data 00:05:00
Importing data into Excel 00:14:00
Exercise: Importing data into Excel 00:05:00
Exercise: Publishing an Excel sheet online 00:05:00
Exercise: Publishing an Excel sheet online 00:05:00
Making web queries 00:15:00
Exercise: Making web queries 00:05:00
How to import and export XML data 00:15:00
Exercise: How to import and export XML data 00:05:00
Exercises: Microsoft Excel Advanced 00:00:00
Section 4
Using the macro recorder 01:00:00
Customising your recorded macro 01:00:00
Troubleshooting your recorded macro 00:30:00
How to customise your Excel set up 00:30:00
Securing your recorded macro 01:00:00
Adding text with macros 00:30:00
Formatting text with macros 00:30:00
Sorting data with macros 00:30:00
Duplicating data with macros 01:00:00
How to generate a report with macros 01:00:00
Using dialog boxes with your macros 00:15:00
Capturing user inputs with macros 01:00:00
How to edit worksheets with macros 00:30:00
Renaming sheets with macros 00:30:00
Modifying sheet order with macros 00:15:00
How to print worksheets using a macro 00:30:00
About user-defined functions 00:30:00
Automate calculations using the SUM function 00:30:00
Exercises: Microsoft Excel and VBA 00:00:00
Section 5
Installing the PowerPivot add-in 00:30:00
Importing outside data with PowerPivot 01:00:00
How to refresh outside data 00:30:00
Linking tables with PowerPivot 00:30:00
Editing tables with PowerPivot 00:30:00
How to create calculated columns 00:30:00
Filtering data in PowerPivot tables 00:30:00
Maintaing table relationships 01:00:00
Inserting PivotTables 01:00:00
Inserting PivotCharts 00:30:00
Generating PowerView sheets 01:00:00
Using slicers to sort your worksheet data 00:30:00
Using sparklines and conditional formatting with PivotTables 01:00:00
Using the DAX functions 01:00:00
Exporting data from PivotTables 00:30:00
Exporting to different file formats 01:00:00
Organising time-sensitive data with DAX 00:30:00
The importance of workbook protection 00:30:00
Exercises: Microsoft Excel and PowerPivot 00:00:00
Mock Exam
Mock Exam- Diploma in Microsoft Excel 2016 00:30:00
Final Exam
Final Exam- Diploma in Microsoft Excel 2016 00:30:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • £350.00 £39.00
  • 1 year
  • Course Badge
  • Course Certificate
  • Number of Units160
  • Number of Quizzes2
  • 2 days, 13 hours

Instructors

537 STUDENTS ENROLLED
    © Victoria Education Ltd.