Office 365 Excel Essentials Coursework
STUDY ONLINE WHEREVER YOU ARE!
Office 365 Excel Essentials Certification
Course Duration: 12 hours - Requisition: 28 days
With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.
The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.
Career Pathway
- Personal Development
- Family Business Owner
- Small Business Owner
- Secretarial
- Personal Assistant
- Retail Venture
- Office Assistant
- Office Manager/ Supervisor
- Manufacturer Executive
Assessment
- Case Study
- Multiple choice questions quiz
Benefits
- Gain quality workplace skills and experience to help launch your career.
- Develop work-related skills and experiences that are recognized by employers.
- Develop independence and confidence in an adult learning environment.
- Gain an insight into various industry areas to help you decide on a career pathway.
- Potentially gain recognition for prior learning for your previous study or work.
- High-quality course written by industry experts with easy to understand course content
- Course materials provided online with unlimited tutor support – no textbooks to buy
- Gain an Australian Certificate upon your successful completion of coursework (Certificate hard copy will be posted to you)
- Course may be tax deductible - see your tax advisor
Coursework Objectives:
- 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
- Download and reload workbooks
- Understand saving and collaborating
- Build, copy and edit formulas
- Understand the difference between Formulas and Functions
- Sort and filter data
- Collaborate with others on a spreadsheet
- Use alignment options
- Apply borders and fill color
- Insert and work with Tables and Charts
- Insert links
Course Contents
Administrative Skills
Module One: Getting Started
Coursework Objectives
Module Two: Welcome to Office 365 Web Apps
The Home Page
The Team Site
Shared Documents
Uploading a Spreadsheet
Module Two: Review Questions
Module Three: Worksheets and Workbooks
Opening a Spreadsheet
Overview of the Reading View
Understanding Worksheets vs. Workbooks
Downloading and Reloading
Closing Spreadsheets
Module Three: Review Questions
Module Four: Working with Excel Files
Using the Find Command
Saving a Copy
Editing in Browser
The Excel Web App Interface
Opening in Excel
Module Four: Review Questions
Module Five: Editing in the Browser (I)
About Saving and Save As
A New File and AutoSaving
Entering Data
Editing Data
Using the Wrap Command
Module Five: Review Questions
Module Six: Editing in the Browser (II)
Cut, Copy, and Paste
Using Undo and Redo
Adding Rows and Columns
Deleting Cells
Using Timesaving Shortcuts
Module Six: Review Questions
Module Seven: Building Formulas
The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References
Module Seven: Review Questions
Module Eight: Understanding Functions
Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions
Using AutoComplete
Module Eight: Review Questions
Module Nine: Working with Data
Sorting Data
Filtering Data
About Collaborating
About Refreshing External Data
Module Nine: Review Questions
Module Ten: Formatting Your Data
Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Adding Borders
Adding Fill Color
Module Ten: Review Questions
Module Eleven: The Insert Tools
Inserting Tables
Inserting Charts
Working with Charts
Inserting Links
Module Eleven: Review Questions
Module Twelve: Wrapping Up
Words from the Wise
Course curriculum
-
1
MODULE 01
- Office 365 Excel Essentials Getting Started
-
2
MODULE 02
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 02
- Office 365 Excel Essentials Module 02 Quiz
-
3
MODULE 03
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 03
- Office 365 Excel Essentials Module 03 Quiz
-
4
MODULE 04
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 04
- Office 365 Excel Essentials Module 04 Quiz
-
5
MODULE 05
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 05
- Office 365 Excel Essentials Module 05 Quiz
-
6
MODULE 06
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 06
- Office 365 Excel Essentials Module 06 Quiz
-
7
MODULE 07
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 07
- Office 365 Excel Essentials Module 07 Quiz
-
8
MODULE 08
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 08
- Office 365 Excel Essentials Module 08 Quiz
-
9
MODULE 09
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 09
- Office 365 Excel Essentials Module 09 Quiz
-
10
MODULE 10
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study 10
- Office 365 Excel Essentials Module 10 Quiz
-
11
MODULE 11
- Office 365 Excel Essentials
- Office 365 Excel Essentials Case Study Module 11
- Office 365 Excel Essentials Module 11 Quiz
-
12
Module 12
- Office 365 Excel Essentials Wrapping it Up
-
13
Rate
- Rate Office 365 Excel Essentials Course
Our courses can be used to turn your career towards a new direction
Those who have completed courses in fields unrelated to their careers show an open and interested mind, an enthusiastic attitude and a lust for life.
-
$199.00