Microsoft Excel Courses Classroom & Online

Microsoft Excel - Beginner Course

Enquire

Venue

Course Content

Course Details

Price: £195 per person Time: 9:00am-2:00pm Available: Face-to-Face in Bridgend County or Virtually

Microsoft Excel - Overview

In this one-day course, we will cover the basics of Microsoft Excel, including creating and formatting spreadsheets, using basic formulas and functions, and working with charts and graphs. You will learn how to use the software to create spreadsheets that are well-organised and easy to read.

By the end of the course, you will have a solid understanding of how to use Microsoft Excel to organise and analyse data effectively. You will have had the opportunity to practice these skills through hands-on exercises and projects. Whether you are a business professional, student, or anyone who needs to manage data, this course will provide you with the skills you need to use Microsoft Excel effectively. Join us for this practical and informative one-day course and take the first step towards becoming a proficient user of Microsoft Excel.

Microsoft Excel - Course Dates 2024

Microsoft Excel - Course Content

• Learn to set up spreadsheets from new

• Learn how to enter data, basic formulas and functions

• Managing printing and spreadsheet layouts

• Explore the various user interface elements

• Getting going with formulas and functions

• Use the Excel galleries

• Customise the interface

• Creating, opening and saving a workbook

• Creating forms with Excel

• Utilising Excel help

• Replicate formulas & functions

• Create an absolute reference

• Range names and how they are applied

• Setting up data for printing

• Recording the current date and time on the printed spreadsheet

• Turning your figures in to charts

• Formatting charts

Who is this course for?

Designed for anyone who is new to spreadsheet software and needs to learn how to use Microsoft Excel. It is ideal for business professionals, students, or anyone who needs to manage data efficiently. No prior experience with Microsoft Excel is required, as we will cover the basics of the software from scratch. If you want to learn how to create and manage spreadsheets, use basic formulas and functions, and create simple charts and graphs, then this course is for you.

Microsoft Excel - Intermediate Course

Enquire

Venue

Course Content

Course Details

Price: £195 per person Time: 9:00am-2:00pm Available: Face-to-Face in Bridgend County or Virtually

Microsoft Excel - Overview

In this one-day course, we will cover intermediate-level topics in Microsoft Excel, including working with complex formulas and functions, creating and modifying charts and graphs, using pivot tables, and automating tasks with macros. You will learn how to use the software to create spreadsheets that are well-organised, visually appealing, and easy to understand.

By the end of the course, you will have a solid understanding of how to use Microsoft Excel to manage and analyse data effectively. You will have had the opportunity to practice these skills through hands-on exercises and projects. Whether you are a business professional, analyst, or anyone who needs to manage and analyse complex data, this course will provide you with the skills you need to use Microsoft Excel effectively at an intermediate level. Join us for this practical and informative one-day course and take your Microsoft Excel skills to the next level.

Microsoft Excel - Course Dates 2024

Microsoft Excel - Course Content

• Absolute cell references

• Naming cells and ranges

• Referring to named cells and ranges in formulae

• Editing named cells and ranges

• Setting up entire workbooks with group editing

• Using VLOOKUP & HLOOKUP statements to retrieve data

• Editing lookups and ensuring accuracy in returned data

• Linking spreadsheets and workbooks together with formulas and functions

• Utilising If statements to assist decision making

• If statements and calculations

• Analysing data with the all new conditional formatting features

• Databases in Excel understanding fields and records

• Sorting data numerically and alphabetically

• Filtering data for range and precision analysis

• Setting up data validation to ensure integrity of the data

• Attaching security to a spreadsheet

• Selective protection i.e. protecting formulas while allowing data entry

• Setting up and utilising templates

• Creating and formatting charts

• Adding trend lines to the chart

• Utilising custom chart types

Who is this course for?

This intermediate course is designed for users who have attended an introductory level course or are already confident in the basic features of Microsoft Excel.

Microsoft Excel - Advanced Course

Enquire

Venue

Course Content

Course Details

Price: £195 per person Time: 9:00am-2:00pm Available: Face-to-Face in Bridgend County or Virtually

Microsoft Excel - Overview

This course focuses on the more advanced functions within Microsoft Excel is focused on manipulating and analysing data. This course covers in detail how to normalise data and analyse it with Pivot Table, importing data using queries, preparing and analysing data with What If functions and scenario building. You will learn how to record and run your own macros in order to automate tasks within Excel, together with the skills to import data, prepare it and set up pivot tables to analyse it. You will learn the knowledge to record macros and create icons on the toolbars to run them. Finally you will learn the ability to use analysis tools to forecast figures based on a range of scenarios.

Whether you are a business professional, financial analyst, data scientist, or anyone who needs to manage and analyse complex data, this course will provide you with the advanced skills you need to use Microsoft Excel effectively. Join us for this practical and informative one-day course and take your Microsoft Excel skills to the next level.

Microsoft Excel - Course Dates 2024

Microsoft Excel - Course Content

• Text functions in Excel

• Count functions

• Advanced 'If' statements

• Create a pivot table reports from new

• Analysing data with pivot tables

• Manipulating pivot tables

• Formatting pivot tables

• Creating pivot charts

• Trace cell precedents & cell dependents

• Goal seek to reverse calculate a formula

• Creating single input data tables

• Setting up and manipulating scenarios for What-If? analysis

• Consolidating data by position

• Group and outline features

• Importing text files

• Setting up database queries

• Recording macros

• Editing macros

• Creating buttons to run macros

• Customising access to Excel commands

• Adding icons to the toolbars

• Creating a custom tab

• Adding options to menus to run macros

Who is this course for?

This course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.

Our Customers

Our Approach

Encouragement and participation in a relaxed learning atmosphere foster motivation and active engagement, leading to successful training.

Inhouse Training

Effortlessly upskill your teams with on-site expert training, saving time and promoting a comfortable learning environment.

Get Quote

Recent Feedback

Feedback plays a pivotal part of our Learning Process, it ensures that we maintain the standards that we have set and continue to make improvements.

"I really enjoyed this course. The trainer allowed us to focus on the aspects of Excel that would be relevant to our work. My only regret is I didn't do it sooner!"

University of South Wales

"Good course. Challenging at times but was able to work through it with the instructor. Overall valuable experience."

Gwent Police

"Learnt lots which is going to save me so much time in work."

NHS

Virtual Learning Available

Our courses are all delivered by a live trainer. Checkout our guidance on virtual learning.

Virtual Training

Have a Question?

If you have any questions regarding our training courses then please feel free to call us on 01656 737349 from Monday to Friday from 8.30am to 4:30pm. Or complete the contact form.

Contact

Training Brochure 2024

Download our latest training brochure for 2024. Includes our Wellbeing, Core Skills, ICT and Technical courses.

Download