Excel Introduction

Course Overview

For those who have never done anything in Excel or lack confidence in their computer skills. The focus of this course is to build you solid understanding of the basics using lots of exercises building from very simple ones to help you master the controls to more practical applications you have to deal with in the workplace.

Learning Outcomes

Master advanced Excel functions and formulas
Create dynamic charts and visualizations

Course Curriculum

1
What is Excel?
  • Benefits of using Excel in work place
  • Accessing the application and workbooks
  • Overview of what the workbook looks like
2
Basic Controls
  • Basic concepts related to the worksheet
  • Basic management of the worksheets (tabs, adjust size of columns/rows, insert/delete, hide/unhide)
3
Data
  • Add, edit & remove data
  • Move data
  • Order & filter data
4
Functions & Formulas
  • Add & edit formulas
  • Use functions (SUM, AVERAGE, MIN, MAX, COUNT)
5
Formatting
  • Best practice
  • Adjusting the appearance of the worksheet (font, colour, alignment)
  • Number formatting
  • Using Format painter and AutoFormat
  • Using freeze panes
6
Printing

Course Details

From
£397.00
+ VAT

Duration

1 day

Who Should Attend

Business analysts, administrative staff, managers, and anyone working with data in Excel

Prerequisites

Basic computer literacy and familiarity with Windows/Mac

What's Included

  • Comprehensive course materials
  • Hands-on exercises
  • Certificate of completion
  • 30-day post-course support
  • Lunch and refreshments

Available Training Sessions

Choose from our upcoming scheduled training sessions. All sessions are delivered by certified instructors and include comprehensive course materials.

No Upcoming Public Sessions

Private training and group bookings available on request.

Frequently Asked Questions

Course Specific

Booking & Scheduling

Courses & Content

Guarantee & Refunds

Pricing & Discounts