Description

Develop the essential Microsoft Excel skills with our CPD-accredited Beginner Excel Course. The course is delivered through interactive online training. It is ideal for anyone looking to learn the basics of Excel. The course is suitable for all types of careers, whether you are starting a new career, returning to work or looking to improve your office skills. Our Beginner Excel training course provides the practical knowledge needed to use Excel confidently in the workplace. Additionally, it is the ideal foundation for progressing to higher levels in the future.

Beginner Excel Training

Microsoft Excel is one of the world’s most widely used business applications. For many jobs, it is an essential skill. Roles in administration, finance, bookkeeping, sales, customer service, HR, management, and more will require proficiency in Excel. Many employers assess Excel proficiency during recruitment, making a solid understanding of Excel essential.

Our online Beginner Excel course is designed specifically for beginners and provides a structured, practical introduction to Microsoft Excel. The training format helps learners build confidence through guided exercises and real-time feedback.

Excel Course for Beginners

Training Objective

Our training centre is a Microsoft Office Academy that equips students with the skills needed for everyday tasks. The Beginner Excel Training Course we provide is CPD-accredited. Therefore, a CPD certificate is issued to participants upon successful completion.

Course Format

The training is delivered online using a virtual tutor. The virtual tutor instructs, corrects, and provides examples, simulating a personal IT trainer. This is a very effective and up-to-date method of delivering interactive online training.

Excel Training Course Content

The Basics In Excel

  • Excel basics and interface overview
  • Navigate worksheets and workbooks
  • Essential Excel keyboard shortcuts
  • Select cells, rows, columns and ranges

Data in Excel

  • Enter text, numbers and dates in Excel
  • Edit, copy, move and update cell contents
  • Use AutoFill and Flash Fill
  • Find and Replace data
  • Proofread worksheets
  • Insert and delete rows, columns and cells

Beginner Excel Formulas

  • Creating simple formulas
  • Understanding cell references
  • Using SUM and other Beginner functions
  • Overview of how formulas work
  • How to use the formula bar

Formatting Worksheets

  • How to apply number formats
  • Applying a theme
  • Formatting characters and cells
  • Cell borders

Working with Rows, Columns and Sheets

  • Adjust column widths and row heights
  • Managing worksheets
  • Add worksheet backgrounds
  • Freeze panes for easier navigation
  • Split windows for more efficient views

Organising Data

  • Sorting data
  • Creating simple data lists
  • Grouping rows and columns
  • Creating outlines
  • Hiding rows, columns and gridlines

Printing and Page Layout

  • Configure page layout settings
  • Use Print Preview
  • Print Excel worksheets efficiently
  • Set print areas
  • Insert page breaks
  • Repeat row and column headings
  • Create headers and footers

Working Efficiently

  • Using Excel Help
  • Productivity tips and shortcuts
  • Best practices for building clean spreadsheets

Ready to head on to the intermediate and advanced training course? If you are, this course can be added for a £50 supplement to this module. This is a discounted price.

Dates and Duration

The recommended duration is six months, though you have access to the training material for one year. It can be completed far before this time. The course can be started and taken at any time. Estimated live learning hours are 10-12, depending on aptitude

Course Requirements

There are no entry requirements for this course. It is aimed at beginners. If you are more advanced, you can start with the Intermediate Excel Course.

Benefits

  • Zoom-enabled training for comfortable viewing on any screen size
  • CPD-accredited Microsoft Excel training developed by Microsoft Learning Partners
  • CPD-accredited certificate upon successful completion
  • Gain a recognised professional qualification for your CV
  • Interactive online learning with a virtual tutor function
  • Real-time feedback and marked practical exercises
  • Training written by Senior Microsoft Trainers within a Microsoft Certified Academy
  • Flexible online learning available 24/7
  • Practical exercises that simulate a real workplace environment
  • One year’s access to the learning platform