Select Page
Excel Course for Beginners

Excel Essentials

This course introduces you to the power of Microsoft Excel, starting from the beginning this course will go through the most important features of Excel that you will need for daily use.

g

Beginners

2 Days

Certification Awarded

Online Resources

Course overview

  • This course introduces you to the power of Microsoft Excel, starting from the beginning this course will go through the most important features of Excel that you will need for daily use. Although it starts from the beginning, so it is suitable for Excel beginners, it will bring you to a very good working knowledge of Excel with many tips and tricks to make it a great revision course for existing Excel users, focusing in on the newest features in Excel that make it more efficient to work with, including Excel’s new AI integration.

Audience

  • No prior Excel experience is necessary; however, attendees should be familiar with file management and general computer use.

Objectives

  • By the end of this Excel Essentials course, participants should have a solid foundation in Excel’s essentials to an intermediate level and be capable of creating, formatting, and manipulating daily spreadsheets. They should also be prepared for more advanced Excel courses in our level 2 category of courses that delve into more complex data analysis and automation techniques.

Certification

  • At the end of the course, you’ll be Certified by the Irish Academy of Computer Training.
  • CPD Certification

CPD Certification

Requirements

  • No prior knowledge is needed
  • Software is provided in the Classroom and Live Virtual options

Learning paths

Why choose IACT

  • Ireland’s leading training provider for 30 years
  • Full-time Certified Trainers who use the software every day
  • Smaller class sizes to accelerate learning

Course curriculum

Day 1

Introduction
• Creating A Blank Workbook
• Looking at the Interface

Navigation & Data Entry
• Moving Through Cells & Sheets
• Selecting A Range Of Cells
• Inserting, Renaming And Deleting Worksheets
• Entering data

Editing Cell Content
• Working With Undo And Redo
• Copy, Cut And Paste
• Inserting/Deleting Rows & Columns

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

Page Setup

  • Headers & Footers
  • Printer Setup
Day 2

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
Tables
• Converting Data to Table
• Name a table
• Simple table options

Lists
• Sort data
• Filter data
• Remove duplicates
• Freeze panes

Protection
• Protecting sheets
• Protecting workbooks

AI in Excel
• Using the Analyse Data Pane
• Show data results quickly and easily

Contact us.

We'll reply quickly.

Enquiry

  • This field is for validation purposes and should be left unchanged.

I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.

0
YOUR CART
  • No products in the cart.