Microsoft Excel Introduction

Using Help:  Teaches users how to utilize Excel’s built-in help features to find information and assistance when encountering difficulties or questions while using the software.
Editing Techniques: Participants learn various editing techniques, including how to cut, copy, paste, and manipulate data within Excel.
Saving Your Work: Understanding how to save Excel workbooks and files is crucial to ensure that data is preserved and can be accessed in the future.
Formulas: The basics of creating and working with formulas in Excel, which are essential for performing calculations and data manipulation.
Writing Formula: Users learn how to write and structure formulas to perform specific calculations, such as addition, subtraction, multiplication, and division.
Using Functions: Functions are predefined formulas in Excel. Participants learn about commonly used functions like SUM, AVERAGE, MAX, and MIN, and how to use them in calculations.
Copying Data: This section covers techniques for copying and pasting data within Excel worksheets and between worksheets or workbooks.
Auto Fill: Participants learn how to use Excel’s auto-fill feature to quickly fill cells with a series of data, dates, or patterns.
Formatting: Formatting is crucial for making Excel worksheets visually appealing and easy to read. Learn about cell formatting, font formatting, and other formatting options.
Spell Checker: Teaches users how to use it to check and correct spelling errors.
Find And Replace: How to search for specific data within a worksheet and replace it with other values or text.
Printing: Understanding how to configure and print Excel worksheets is important for creating physical copies or reports.
Absolute Cell References: Learn the concept of absolute cell references in Excel formulas, which allow for precise referencing of specific cells.
Named Ranges: Named ranges make formulas more readable and manageable. This section teaches users how to define and use named ranges.
Naming A Formula: Participants learn how to assign names to formulas for easier reference and reuse.
Linking Workbooks: How to establish links or references between different Excel workbooks, which can be useful for data consolidation.
Creating Charts: Learn how to create various types of charts and graphs to visualize data effectively.
Chart Options: Delve into customizing charts by adjusting their appearance, labels, and other settings.
Changing The Size Of Embedded Charts: Learn how to resize and manipulate charts when they are embedded within a worksheet.

The target audience for this course includes individuals who have specific needs related to data analysis and reporting using Excel. This could be:

Business Professionals: This course is ideal for professionals working in various business roles, such as finance managers, accountants, business analysts, and sales managers, who need to use Excel to create spreadsheets for budgeting, cash projections, and sales analysis.
Financial Analysts: Financial analysts who require Excel skills to perform financial modeling, data analysis, and reporting will benefit from this course. It covers essential topics for financial data management and presentation.
Small Business Owners: Entrepreneurs and small business owners who need to track their finances, create budgets, and analyse sales data can gain valuable skills from this course.
Report Writers: Individuals responsible for preparing and presenting financial information in the form of numerical or graphical reports, such as financial reports, sales reports, or performance dashboards, can enhance their reporting capabilities with the skills learned in this course.
Students and Learners: Students pursuing business, finance, or related courses can use this course to build a strong foundation in Excel for academic and future career purposes.
Anyone Seeking Excel Proficiency: If you’re looking to improve your Excel skills for personal or professional development and you have a specific interest in financial analysis and reporting, this course can be a valuable resource.

The course’s focus on creating spreadsheets for budgets, cash projections, and sales analysis, along with teaching how to use formulas for basic statistics like finding averages, makes it particularly suitable for individuals who work with financial data or need to communicate financial information effectively.

Have two or more people to train? you may consider a closed group course.

Benefits include:

  • Cost effective
  • Choose a date to suit you
  • Customise content and timings
  • No minimum delegate
  • Choose how the course is delivered – In person face-to-face at your location or virtual 

Contact us on [email protected] to discuss specific date and delivery requirements.

We can deliver our training sessions in several ways, these being:

  • Open public course (Contact us if you can’t see a suitable date listed)

Please enquire about the following methods

  • Closed group
  • In person face to face
  • virtual
  • One to one coaching

Course Benefits

  • Fully led tutor instruction
  • Comprehensive courseware for all delegates
  • Certificates of attendance
  • Course Guarantee
  • Emergency trainer
  • Contextualisation and customisation for Closed group courses
  • Evaluation Feedback
  • Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details

Key Features

Course Duration is 1 Day

Engaging & interactive tutor led session

Comprehensive course materials

Priced per delegate per day for open public course

From: £295.00 Plus VAT

Select a Date

Loading available dates...

Can’t see a suitable date? Please request a date here

Payment available via all major credit cards or Invoice. All options available during the online booking process.