admin@designated.org.uk - 0151 653 3338

Microsoft Courses

Microsoft Office 365: Excel Microsoft

2017/06/02
2017/06/02
  • 0

    day

  • :
  • 0

    hour

  • :
  • 0

    min

  • :
  • 0

    sec


Use the latest cloud linked Analysis, Chart producing Data tool that is on the market. The worlds insdustry standard spreadsheet programme packs a more powerful punch than ever.

Overview

In this Excel 365 Essentials course, participants will learn ways this new web application can increase collaboration and productivity. Users of this software will share and simultaneously work on spreadsheets, as well as be able to easily access spreadsheets from anywhere and across computers. This course will teach the new interface, as well as all of the basics of creating and using spreadsheets. Techniques for managing data and displaying data visually will be taught.

Welcome to Office 365 Excel

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Spreadsheet

Worksheets and Workbooks

  • Opening a Spreadsheet
  • Overview of the Reading View
  • Understanding Worksheets vs. Workbooks
  • Downloading and Reloading
  • Closing Spreadsheets

Working with Excel Files

  • Using the Find Command
  • Saving a Copy
  • Editing in Browser
  • The Excel Web App Interface
  • Opening in Excel

Editing in the Browser

  • About Saving and Save As
  • A New File and Autosaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts 

Building Formulas

  • Building Formulas
  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Understanding Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using AutoComplete

Working with Data

  • Sorting Data
  • Filtering Data
  • About Collaborating
  • About Refreshing External Data

Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Adding Borders
  • Adding Fill Colour

The Insert Tools

  • Inserting Tables
  • Inserting Charts
  • Working with Charts
  • Inserting Links