Excel Introduction Training Courses

Page Contents

Excel Introduction Training Course

Excel Introduction Training Course Overview

Our Excel Introduction training course is ideal for complete novices or those who have basic knowledge of Excel. Taking this course will provide you with the skills you need to work quickly and produce functional and well-formatted spreadsheets.

Delegates will leave feeling confident about creating professional worksheets with Excel and be able to navigate the interface intuitively and enhance their productively.

Excel Introduction Training Course

Excel Introduction Five Key Topics

  1. Creating new spreadsheets
  2. Modifying existing Workbooks
  3. Formatting text and numbers
  4. Perform Excel calculations
  5. Present data visually using Excel Charts
Excel Introduction Training Course

Excel Introduction Course Details

Course Duration : 1 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability : Monday – Saturday

Excel Introduction Training Course

Excel Introduction Training Course Details

Course Location : Our Microsoft Excel Introduction training course can be delivered at your offices, Mouse venue or online.

Class Size : Individual or Group.

Course Format : Classroom style or online (Teams or Zoom)

Tailored Course Content : Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.

Next Public Course : Due to COVID, public classroom courses are suspended until March 2021.

Days
Hours
Minutes
Seconds

Centre and Services

Comfortable & modern facilities
Unlimited access to out online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

On Completion of Excel Introduction

  • Use the Excel ribbon
  • Create and modify existing worksheets
  • Edit a worksheet
  • Format a worksheet
  • Work with Excel formulas
  • Print your worksheet
  • Create a chart
  • Control the worksheet display

Excel Introduction Course Outline

  • Setting up a Microsoft account
  • Connect to OneDrive or Business Drive
  • Connect to your Office 365 account
  • Tell me what you want to do 
  • Starting and exiting from Excel
  • Using the Excel ribbon
  • Customise the ribbon
  • Displaying Help information
  • Changing the file type and converting to PDF
  • Using and creating Custom Lists
  • Using Excel sample templates
  • Creating and opening workbooks
  • Adding data to a worksheet
  • Selecting ranges of cells
  • Entering worksheet data
  • Saving a workbook
  • Using the Excel Date Picker
  • Using the Spell Checker
  • Adjusting column widths
  • Inserting and deleting a range of cells
  • Copy, move and delete cell entries
  • Find and Replace specific entries in a worksheet
  • Inserting and renaming sheet tabs
  • Changing the font style, size and colour
  • Adding alignment options, wrap text, orientation and merge cells
  • Applying borders and patterns
  • Adjusting row height and column widths
  • Changing the number format of cell entries
  • Using Styles for consistent formatting
  • Conditional formatting
  • Creating basic formulas
  • Brackets and the order of calculation
  • Excel functions
  • The SUM, AVERAGE, MAX, MIN, COUNT and COUNTA functions
  • Using the AutoSum tool
  • Entering formulas using Insert Function
  • Copying formulas with AutoFill
  • Absolute and relative references
  • Previewing a worksheet
  • Changing the Page setup of a worksheet
  • Setting the print area
  • Printing certain rows or columns on each page
  • Printing selected worksheet entries
  • Plotting a chart
  • Use Recommended Charts 
  • Previewing and printing a chart
  • Adding new data to an existing chart
  • Including multiple data ranges in a chart
  • Uses of the different chart types
  • Creating Sparklines
  • Create Funnel Charts and 2D maps
  • Splitting the workbook window into panes by freezing panes
  • Hiding rows and columns
  • Changing the zoom level for a worksheet
  • Sorting and filtering worksheet data

Related Excel Courses

Excel Introduction Training Course
Excel Introduction Training Course
 

What is Power Bi – Business intelligence like never before

All of our courses are available for private groups, either held at your workplace or at our Excel training London centre.

Excel Introduction Training Course
Excel Introduction Training Course
Excel Introduction Hints and Tips