MS Office 365 Excel Essentials Training Course

Office 365 Excel is Microsoft's new "cloud" based spreadsheet that's available anywhere.

Use your browser to edit and create Excel workbooks and worksheets, simultaneously edit spreadsheets with your colleagues and securely store them online, making them available on tablets, phones, laptops and desktops.

This exciting new course is available now throughout the US, including Atlanta, Baltimore, Boston, Charlotte, Chicago, Dallas, Los Angeles, Manhattan, Miami, Orlando, Philadelphia, and Seattle.

Learning Outcomes - MS Office 365 Excel Essentials Training Course

By the end of this training course, participants will:

• Open and close spreadsheets
• Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
• Understand the Excel 365 browser interface
• Upload a spreadsheet to the Shared Documents library
• Differentiate between worksheets, workbooks, rows, columns, and cells
• Download and reload workbooks
• Use the Find Command
• Save a Copy
• Open in Editing View
• Open the spreadsheet in the Excel desktop application for more advanced features
• Understand saving and collaborating
• Create a new file
• Enter labels and values
• Edit data
• Use the Wrap Command
• Use cut, copy, and paste
• Use Undo and redo
• Add rows and columns
• Delete cells
• Understand shortcuts
• Build, copy and edit formulas
• Use absolute referencing appropriately
• Understand the difference between Formulas and Functions
• Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
• Understand Autocomplete
• Sort and filter data
• Collaborate with others on a spreadsheet
• Refresh and recalculate data
• Format text and numbers
• Use alignment options
• Apply borders and fill color
• Insert and work with Tables
• Insert and work with Charts
• Insert links

Times

Public classes start at 9:00am and finish around 4:30pm.

Class Size

Public classes will be a small relaxed group of between 4 and 12 people.

The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.

What is provided?

All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and a MS Office 365 Excel Essentials Training Course Certificate of Completion.

Certificates of Completion are issued to each participant