YOUR CART
- No products in the cart.
Subtotal:
€0
Overview
This Excel Beginners Course introduces you to the power of Microsoft Excel. Starting from the basics, the course walks you through the most important features you’ll need for everyday tasks, such as formulas, formatting, and data organization. Although designed for complete beginners, it also serves as an excellent refresher for current users. You'll gain a solid working knowledge of Excel, along with valuable tips and tricks. The Excel Beginners course highlights the latest Excel tools, including new AI-powered features, making your workflow faster, smarter, and more efficient in real-world applications.
Course Objectives
By the end of this Excel Beginners Course, you’ll have a strong grasp of Excel’s core functionalities. You’ll be adept at creating, formatting, and managing everyday spreadsheets, utilizing features like formulas and tables to enhance your daily Excel tasks. You’ll also gain confidence using Excel efficiently in real-world work scenarios. Once complete, you can progress to our Excel Advanced Course.
Look at our Excel Master Programme, which includes Data Analysis, Power BI, and VBA Courses. We also have a Data Analytics Master Programme.
How We Stand Out
IACT’s Excel Beginners Course is the perfect starting point in our modular Excel learning pathway, which also includes the Excel Advanced Data Analysis course and Excel Master Diploma.
With CPD-accredited certification and flexible learning options (online or in-person), this course is ideal for beginners seeking practical, career-relevant Excel skills.
Whether taken as a standalone foundation course or as part of a broader Excel training plan, it’s designed to help individuals and teams build confidence with essential spreadsheet tools.
Course Benefits
- Gain confidence using Excel to manage and format basic spreadsheets
- Learn essential functions, formulas, and formatting tools
- Build a strong foundation for further Excel learning and workplace tasks
- Practice in real time with expert-led instruction and guided exercises
- Delivered by Microsoft-certified trainers, available in-person or online
Content
Introduction & Navigation
- Looking at the Interface
- Moving Through Cells & Sheets
- Selecting A Range Of Cells
Basics
- Inserting, Renaming And Deleting Worksheets
- Entering data
- Editing Cell Content
Formatting
- Formatting data in cells
- Applying Cells Borders
- Changing Alignments, Font Size, Type And Colour
- Merge And Wrap Features
- Hide/Show columns and rows
- Formatting text
- Formatting dates and numbers
Basic Formulae
- Simple Calculations Using Operators
Protection
- Protecting sheets
- Protecting workbooks
Page Setup
- Headers & Footers
- Printer Setup
Using Functions
- Simple Daily Functions: SUM, AVERAGE
- Daily functions: COUNT, MAX, MIN
- Formulas across 2 separate sheets
- Absolute referencing
- Name a cell/range
- Name Manager
- Using Named cells/ranges in formula
Find and Select Options
- Find a value
- Select/Replace
- Find a Special value
Lists
- Sort data
- Filter data
- Remove duplicates
- Freeze panes
Introduction to Tables
- Converting ranges into Tables
- Table Options
- Using Sorts and Filters in Tables
- Total Row
AI in Excel
- Using the Analyse Data Pane
- Show data results quickly and easily
You will learn how to
- Open, save and close workbooks
- Work with multiple sheets
- Enter and edit data in cells
- Change format types of cells
- Create simple formula using operators and cell references
- Create more advanced formula using daily functions such as SUM
- Work with long lists of data with sort and filter features
- Create and work with Tables
- … and much more to give your CV and skills a boost.
Audience
A little knowledge of Excel would be beneficial but not required. Excel beginners can attend if they are already using other Microsoft applications.
If you are a complete beginner to Excel and have little knowledge of the Microsoft Office applications in general, contact us and we will tell you about our Excel Beginners Course.
Classroom and Virtual training options
Online Course Materials
Duration
2 Days or 4 x 3-Hour Sessions
More Courses...
Contact us...
Relevant, industry-focused learning and development
Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.
