future savvy logo
image

Microsoft Excel Training Courses For Beginners

Excel Introduction

Gain essential Excel skills with our 1-day beginner course. Learn how to use Excel efficiently for business, perform calculations, create and use formulas, modify and format worksheets, and style data for greater impact. This training course is ideal for understanding and analysing your organisation's data to make informed business decisions.

  • Virtually Online Or On-Site

  • 1 Days

  • Next Running:

    4th November
UPCOMING COURSES
Monday

4th November 2024

Virtually Online
£275.00

EX. VAT

Tuesday

3rd December 2024

Virtually Online
£275.00

EX. VAT

Monday

6th January 2025

Virtually Online
£275.00

EX. VAT

Monday

3rd February 2025

Virtually Online
£275.00

EX. VAT

Monday

3rd March 2025

Virtually Online
£275.00

EX. VAT

Monday

7th April 2025

Virtually Online
£275.00

EX. VAT

Course Information

This 1-day Excel Introduction training course has been designed specifically for beginners. Our skilled trainer will provide you with foundational Excel knowledge and equip you with the necessary skills to start using it for your business straight away.

Choose from our online public courses dates to book your course today.

Alternatively, contact us to arrange on-site training tailored to your needs!

What you will learn

After completing this Excel Introduction course, you will be able to:

  • Get working with Microsoft Excel efficiently and effectively
  • Perform Excel calculations
  • Optimise your worksheets by creating and using formulas
  • Modify worksheets to manipulate and edit data
  • Format and style Excel worksheets to get more impact from data
  • Basic Excel spreadsheet training for business

By the end of this 1-day instructor-led Excel Introduction course, you will know how to use Excel to make sense of your organisation's raw data. You will gain a level of insight into that data which will empower you to make better business decisions.

All with our 100% Money-Back Guarantee and Unlimited Email Support.

Course Outline

  • 1
    Getting Started With Excel
    • Starting Excel
    • Selecting the Blank Worksheet Template
    • The Excel Cell Referencing System
    • Entering Numbers and Text
    • Default Text and Number Alignment
    • Summing a Column of Numbers
    • Entering a Date
    • Worksheets and Workbooks
    • Saving a Workbook to Your Hard Disk
    • Creating,Opening and Closing a Workbook
    • Opening a Recently Used Workbook
    • Saving a Workbook Using another Name
    • Getting Help within Excel
  • 2
    Excel Selection Techniques
    • Why Are Selection Techniques Important?
    • Selecting a Cell, a Row and a Column
    • Selecting a Range of Cells
    • Selecting a Range of Rows
    • Selecting a Range of Columns
    • Selecting the Entire Worksheet
    • Recommended Techniques When Creating or Editing Lists
  • 3
    Manipulating Rows And Columns Within Excel
    • Inserting Rows and Columns into a Worksheet
    • Deleting Rows and Columns within a Worksheet
    • Modifying Column Widths
    • Modifying Column Widths Using 'Drag and Drop'
    • Automatically Resizing the Column Width to Fit Contents
    • Modifying Row Heights
  • 4
    Manipulating Cells and Cell Content within Excel
    • Copying a Cell or Range Contents within a Workbook
    • Deleting Cell Contents
    • Moving the Contents of a Cell or Range within a Workbook
    • Editing Cell Content
    • Undo and Redo
    • Copying or Moving Data between Worksheets (Within the Same Workbook)
    • Copying or Moving Data between Worksheets (In Different Workbooks)
    • AutoFill
    • Copying a Data Range Using AutoFill
    • Searching and Replacing Data
  • 5
    Excel Worksheets
    • Switching between Worksheets
    • Renaming a Worksheet
    • Recommended Techniques with Naming Worksheets
    • Inserting and Deleting a Worksheet
    • Copying or Moving a Worksheet within a Workbook
    • Copying or Moving Worksheets between Workbooks
  • 6
    Alignment Formatting within Excel
    • Horizontally Aligning Contents in a Cell Range
    • Centring a Title over a Cell Range
    • Text Wrapping within a Cell
    • Format Painter
  • 7
    Number Formatting within Excel
    • Number Formatting
    • Decimal Point Display
    • Applying and Removing Comma Style
    • Formatting (To Indicate Thousands)
    • Currency Symbol
    • Date Styles
    • Percentages
  • 8
    Freezing Titles
    • Freezing Row and Column Titles
  • 9
    Excel Formulas
    • Creating Formulas
    • The Easy Way to Create Formulas
    • Copying Formulas
    • Operators
    • Using Operators in Formulas
    • Relative Cell Referencing within Formulas
    • Absolute Cell Referencing within Formulas
  • 10
    Excel Functions
    • What Are Functions?
    • Common Functions
    • Sum and Average Function
    • Max and Min Function
    • Count and Counta Function
  • 11
    Excel Charts
    • Inserting a Column Chart
    • Changing the Chart Type
    • Formatting Charts
  • 12
    Customising Excel
    • Modifying Basic Excel Options

Private courses.

We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!

  • Tailored
  • Post Course Support
  • Cost Effective
Enquire

Reviews

  • Lee was a very good trainer and his pace of learning was excellent

    Elizabeth
  • Excellent, well structure course with clear and concise demonstrations and explanations

    Adam
  • Highly informative and excellently delivered

    Ian