Microsoft Excel Introduction

Basic Excel Navigation – Including keyboard shortcuts
Adding Data – Understanding Excels control of text vs numbers
The Logic of Formula
Writing Formulas –
Including formula shortcuts
The Logic of Functions 
Writing Functions – Including SUM, AVERAGE, COUNT, COUNTA, SUMIF, COUNTIF
Copying Data & Formulas – Including Autofill Options
Formatting Skills –
Including Format Painter and other shortcuts 
Printing
Absolute Cell References –
Learn the concept of absolute cell references in formulas
Named Ranges – Named ranges make formulas more readable and manageable
Linking Worksheets & Workbooks
Creating Charts – Learn how to create various types of charts and graphs to visualize data effectively

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.

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)
  • Closed group
  • In person face to face
  • Virtual
  • One to one coaching

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

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

How Our Tutor led Courses Are Delivered:

Delegates are given Pre-work
Group courses use your real-world scenarios so learning is immediately relevant and actionable.
Our sessions are participative and highly Interactive by including a variety of activities throughout the delivery including
Real-world case work
Practical exercises
Real Play
Peer learning
Case studies
Simulation
Facilitated discussion and Structured reflection
Leave with Actionable outcomes
Post-session measurements

Participants leave with:

Practical tools
Clear action plans
Greater confidence
Skills they can apply immediately

Course Benefits

  • Fully tutor led instruction
  • Comprehensive courseware for all delegates
  • Certificates of attendance
  • Course Guarantee
  • Emergency trainer
  • Contextualisation and customisation for Closed group courses
  • Evaluation Feedback
  • Pre & Post Course Activities
  • 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 tutor led event

Comprehensive course materials

Certificates of attendance

Access to Customer Portal (course bookers)

Course Guarantee

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.