Microsoft Excel 365 Part 1 Training Course

Table of Contents

Excel 365 Part 1 Training Course Overview

Our Excel 365 Part 1 Training course is intended to help all users creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable.

Course Details

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

Excel 365 Part 1 Course Details

Course Location: This Microsoft Excel 2019 Power Pivot DAX training course can be delivered either at our London training venue, online or at your offices.

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 your course to meet your requirements.

Rate: £220+VAT

Centre and Services

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

Microsoft Excel 365 Part 1 Course Outline

  • Launching Excel 365
  • The Excel Online Interface
  • Creating a New Workbook
  • Closing Excel Online
  • What are Spreadsheets, Worksheets and Workbooks?
  • What are Columns, Rows, Cells and Ranges?
  • Navigating in Excel
  • Keyboard Navigation Options
  • Excel Formulas
  • Opening a Workbook
  • Editing Your Workbook in Excel Desktop
  • Accessing Save Options
  • Using the Accessibility Checker
  • Printing a Workbook
  • Sharing a Workbook
  • Using Tell me what you want to do
  • Accessing Advanced Help Options
  • Getting Accessibility Help
  • The Formula Bar
  • Elements of an Excel Formula
  • Mathematical Operators
  • The Order of Operations
  • Types of References
  • A closer look at Formulas
  • About Functions
  • Creating a Function with AutoComplete
  • Using the Insert Function Dialog Box
  • Using AutoSum
  • Viewing AutoSum Calculations in the Status Bar
  • Automatic Workbook Calculations
  • Selecting Cells
  • The Cut, Copy and Paste Commands
  • Using Paste Options
  • Moving Data with Drag and Drop
  • The Undo and Redo Commands
  • Using AutoFill
  • Using Flash Fill
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Clearing Data from Cells
  • Changing Column Width and Row Height
  • The Hide and Unhide Options
  • The difference between Sorting and Filtering
  • Sorting Data
  • Enabling Filtering
  • Using the Filter Dialog Box
  • Using Text Filters
  • Clearing a Filter
Excel Hints * Tips