Search courses 👉
Professional Training
5.0 (23 Reviews)

Excel Introduction

Future Savvy, In London (+4 locations)
Length
1 day
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Length
1 day
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Leave your details so the provider can get in touch

Course description

Excel Introduction

This course will provide you with the foundational Excel knowledge and skills necessary for business today. As you apply the robust functionality that's part of Excel to your organization's raw data, you will be able to gain a level of insight into that data that would have been almost impossible years ago. Excel helps you organize, calculate, analyze, revise, amend, and present your data in ways that will help you and the decision makers in your organization steer forward in the right direction

Upcoming start dates

Choose between 4 start dates

Enquire for more information

  • Classroom
  • Birmingham

Enquire for more information

  • Classroom
  • London

Enquire for more information

  • Classroom
  • Manchester

Enquire for more information

  • Classroom
  • Reading

Suitability - Who should attend?

Learners must be confident using a mouse and keyboard.

Outcome / Qualification etc.

What will you learn

In particular you will be able to:

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

Training Course Content

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

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

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

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

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

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

Number Formatting within Excel

  • Number Formatting
  • Decimal Point Display
  • Applying and Removing Comma Style
  • Formatting (To Indicate Thousands)
  • Currency Symbol
  • Date Styles
  • Percentages

Freezing Titles

Freezing Row and Column Titles

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

Excel Functions

  • What Are Functions?
  • Common Functions
  • Sum and Average Function
  • Max and Min Function
  • Count and Counta Function

Excel Charts

  • Inserting a Column Chart
  • Changing the Chart Type
  • Formatting Charts

Customising Excel

Modifying Basic Excel Options

Reviews

Average rating 5

Based on 23 reviews.
Reviews are published according to our review policy.
Write a review!
Elizabeth
5/5
06 Sep 2023

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

Ian
5/5
07 Aug 2023

Highly informative and excellently delivered

Adam
5/5
07 Aug 2023

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

Request info

Contact form

Fill out your details to find out more about Excel Introduction.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Future Savvy

Welcome to Future Savvy, your gateway to a world of boundless learning and professional growth! At Future Savvy, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals...

Read more and show all courses with this provider

Ads