Description

Our Microsoft Excel Diploma for Data Entry has been created in partnership with Microsoft Learning Partners. Excel is a vital programme for Data Entry Professionals. It enables you to input data, verify accuracy, summarize, manipulate and present data. All of these are core to professionals who work with big data.

Microsoft Excel Diploma for Data Entry

Our Diploma aims to build your speed and accuracy using Excel. This will be done through the numerous functions, formulas, and shortcuts included in the program. Excel training can also show you how to validate and prevent errors in data. Another important part of Excel is the ability to manipulate and present data.

Diploma Format

The training is delivered online. Training can be taken at any time. You have 24/7 access. Our Diploma is delivered on interactive online software that enables interactive learning. Microsoft Learning Partners wrote all of the training material. The learning system contains a virtual tutor who will instruct you in all lessons, provide exercises, and give corrections and feedback. This state-of-the-art system provides the personalised interaction needed to gain skills and transfer them back to your job.

Course Content

The Excel Diploma includes Beginner, Intermediate and Advanced levels. Below, you can see the details of each module:

Beginner Level – Excel

  • Getting Started with Excel
  • Essential within new workbooks and an overview of the functionalities of Excel
  • Formatting in an Excel Workbook
  • Formatting font; formatting cells; borders; colours, highlighting
  • Copying, cutting, pasting and other formatting issues in Excel
  • Set out your first Excel calculation and enter a calculation formula
  • Calculating a sum and other essential functions
  • Reproducing data in adjacent cells
  • Increase your efficiency as an Excel user
  • Simple numerical formats and checking to spell
  • Find and replace
  • Inserting/deleting/moving rows, columns and cells
  • Copying to non-adjacent cells; how to merge cells; change cell style; change cell content orientation.
  • Print an attractive document
  • Page layout; print preview and printing
  • Repeating row/column headings on printed pages, headers and footers; hiding sheet elements.
  • Page breaks and print area
  • Manipulating your Workbook
  • Introduction to tables
  • Sort data, customise the presentation, copy formatting, and work with an automatic date.
  • Date formats
  • Splitting the window, freezing a column/row
  • Tables and Charts
  • Subtotal rows; advanced filtering options

Intermediate Level Excel

  • Increase your efficiency in Excel
  • Microsoft Excel Help
  • Checking to spell, find and replace
  • Inserting/deleting rows, columns and cells
  • Moving cells, copying to non-adjacent cells
  • Copying cell format quickly, merging cells, the orientation of cell content.
  • Cell styles
  • Sorting data
  • Multiple worksheets and various views
  • Sheet name, tab colour, inserting, deleting sheets#
  • Sheet background
  • Moving, copying, hiding sheets
  • Splitting the window, freezing a column/row, hiding elements of a sheet
  • Repeating rows/columns on printed pages
  • More complex Excel Tables, Formulas and Functions
  • Merging and Wrapping text
  • Absolute reference in a formula
  • Copying values, copying with a link, transposing
  • Calculating with functions
  • Control date, date formats
  • Simple conditions
  • Custom formats
  • Applying and managing conditional formats
  • Naming a range of cells
  • Validation rules
  • Multiple cell ranges and calculations in functions
  • Charts in Excel to present data
  • Creating and managing a chart
  • Selecting, adding and removing items in a chart
  • Formatting chart items
  • Modifying a chart’s text items
  • Printing and page layout of a chart
  • Sparklines in Charts
  • Managing chart options, data series, labels and axes
  • Visuals in Excel
  • Modifying a text box
  • Picture and Drawing
  • Creating, editing, resizing, rotating, grouping, stacking and aligning objects
  • Database functionality with an Excel table
  • Subtotal rows
  • Automatic calculations in a table
  • Automatic filtering
  • Custom filters
  • Blank cells and duplicates
  • Advanced filtering with a criteria range
  • Criteria ranges
  • Copying rows filtered using a criteria range
  • Statistics with a criteria range
  • Flash Fill

Advanced Excel Module

  • Pivots Tables
  • Pivot Charts
  • Advanced Formulas (VLookup, Date Functions and many more)
  • IF statements, AND and OR
  • Nested, Arrays and Conditions Formulas
  • Scenarios, Goal Seek
  • Other advanced functions
  • Auditing and Error Checking
  • Templates and themes
  • Protecting workbooks
  • Sharing workbooks

Benefits

  • Training made by experts: senior Microsoft Trainers from a Microsoft Learning Partner
  • CPD Accredited Excel Diploma
  • Receiving a CPD Certificate provides an internationally recognised qualification.
  • Virtual training with an expert, which enables you to do all the same just on personal training
  • Numerous practical exercises which provide you with all the needed skills
  • Professionally accredited qualification to help your CV

Other courses

Our Microsoft Access Diploma for Data Entry is an ideal complement to this course. We additionally have a Microsoft Office Diploma for people looking to take all courses.