Excel 365 Essentials Online Certificate Course

Access Your Speadsheets Anytime, Anywhere!

Excel 365 Essentials Online Certificate Course

NOW ONLY

RM799

Save RM300 (27%)
OFF RRP RM1099
Get Info Pack

Make Basic Changes Without Using a Computer Where Your Desktop Office Applications are Installed.

Welcome to the Office 365 Excel Essentials course. 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.

By the end of this Excel 365 Essentials Online Short Course, you should be able to:

  • 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 Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Module One: Getting Started
By the end of this course, you should be able to:

  • 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

Module Two: Welcome to Office 365 Web Apps

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

Module Three: Worksheets and Workbooks

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

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 Five: Editing in the Browser (one)

  • About Saving and Save As
  • A New File and AutoSaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command

Module Six: Editing in the Browser (two)

  • Cut, Copy, and Paste
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts

Module Seven: Building Formulas

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

Module Eight: Understanding Functions

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

Module Nine: Working with Data

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

Module Ten: Formatting Your Data

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

Module Eleven: The Insert Tools

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

Module Twelve: Wrapping Up
Words from the Wise

 

Entry requirements

Students must have basic literacy and numeracy skills.

Open entry

Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

  • Adobe Acrobat Reader 

Customer Reviews

5 star
50%
4 star
30%
3 star
13%
2 star
5%
1 star
2%
(3807)
Average rating 4 out of 5 stars

17 February 2020 10:16:40 PM

Good course

15 February 2020 08:57:11 PM

Very enjoyable course. Now feel much more confident in using Office 365.
Modules and review questions were very well set up and in an easy to learn.
Would definitely recommend.

9 February 2020 01:00:53 AM

Great framework to help one create his/her personal success

8 February 2020 12:11:10 AM

I am being to use all of these organization skills to declutter my home. Taking one room a month.

5 February 2020 07:13:25 PM

Very interesting clear points. Works on changing cognitive behavior thought patterns.

1 February 2020 02:44:39 AM

By learning how to use our imagination we will be able to reach our goals and have success in our progress. this study opens up new way for me to obtain my goals.

31 January 2020 12:08:02 PM

I found this course to be very informative and educational. The different aspects of getting organized and staying that way is important to your being able to continue developing good habits in your work and home environment.
Thank you

31 January 2020 08:54:23 AM

This course was simple to do. I enjoyed reading the contents. I look forward to the rest of the course and working on the work book. Thanks

30 January 2020 08:39:12 PM

This course is helpful.

30 January 2020 06:26:05 PM

This course will help me to organised my working office.

30 January 2020 03:15:17 PM

amazing course !

30 January 2020 12:07:20 AM

Nice, video needs better sound

28 January 2020 10:56:17 AM

EXCELLENT! GOD BLESS! ALL THE BEST!

26 January 2020 07:49:07 AM

Excellent course

26 January 2020 07:13:37 AM

Good information.

25 January 2020 12:37:41 AM

This course have been very instrumental in helping me to understand what is require to be a successful manager and team leader both for work and home

24 January 2020 01:49:25 AM

This chapter is coined to address challenges most of us face in life. So educative and inspiring.

23 January 2020 10:16:09 PM

The course was awesome. It nails the required lesson for greater challenges in all aspect of life.

23 January 2020 02:18:28 AM

This course is awesome. I am blessed to have been given this course freely. Well detailed.

22 January 2020 08:59:33 AM

amazing

Load more reviews Loading...
About this Course

Make Basic Changes Without Using a Computer Where Your Desktop Office Applications are Installed.

Welcome to the Office 365 Excel Essentials course. 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.

By the end of this Excel 365 Essentials Online Short Course, you should be able to:

  • 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 Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Module One: Getting Started
By the end of this course, you should be able to:

  • 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

Module Two: Welcome to Office 365 Web Apps

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

Module Three: Worksheets and Workbooks

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

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 Five: Editing in the Browser (one)

  • About Saving and Save As
  • A New File and AutoSaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command

Module Six: Editing in the Browser (two)

  • Cut, Copy, and Paste
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts

Module Seven: Building Formulas

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

Module Eight: Understanding Functions

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

Module Nine: Working with Data

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

Module Ten: Formatting Your Data

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

Module Eleven: The Insert Tools

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

Module Twelve: Wrapping Up
Words from the Wise

 

Entry requirements

Students must have basic literacy and numeracy skills.

Open entry

Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

  • Adobe Acrobat Reader 
(3807)
Average rating 4 out of 5 stars
5 star
50%
4 star
30%
3 star
13%
2 star
5%
1 star
2%

17 February 2020 10:16:40 PM

Good course

15 February 2020 08:57:11 PM

Very enjoyable course. Now feel much more confident in using Office 365.
Modules and review questions were very well set up and in an easy to learn.
Would definitely recommend.

9 February 2020 01:00:53 AM

Great framework to help one create his/her personal success

8 February 2020 12:11:10 AM

I am being to use all of these organization skills to declutter my home. Taking one room a month.

5 February 2020 07:13:25 PM

Very interesting clear points. Works on changing cognitive behavior thought patterns.

1 February 2020 02:44:39 AM

By learning how to use our imagination we will be able to reach our goals and have success in our progress. this study opens up new way for me to obtain my goals.

31 January 2020 12:08:02 PM

I found this course to be very informative and educational. The different aspects of getting organized and staying that way is important to your being able to continue developing good habits in your work and home environment.
Thank you

31 January 2020 08:54:23 AM

This course was simple to do. I enjoyed reading the contents. I look forward to the rest of the course and working on the work book. Thanks

30 January 2020 08:39:12 PM

This course is helpful.

30 January 2020 06:26:05 PM

This course will help me to organised my working office.

30 January 2020 03:15:17 PM

amazing course !

30 January 2020 12:07:20 AM

Nice, video needs better sound

28 January 2020 10:56:17 AM

EXCELLENT! GOD BLESS! ALL THE BEST!

26 January 2020 07:49:07 AM

Excellent course

26 January 2020 07:13:37 AM

Good information.

25 January 2020 12:37:41 AM

This course have been very instrumental in helping me to understand what is require to be a successful manager and team leader both for work and home

24 January 2020 01:49:25 AM

This chapter is coined to address challenges most of us face in life. So educative and inspiring.

23 January 2020 10:16:09 PM

The course was awesome. It nails the required lesson for greater challenges in all aspect of life.

23 January 2020 02:18:28 AM

This course is awesome. I am blessed to have been given this course freely. Well detailed.

22 January 2020 08:59:33 AM

amazing

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only RM799 Save RM300 (27%)
OFF RRP RM1099
Delivery Method

Online - Certificate

Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value RM700)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID: 020E3EOSC
Delivery Mode: Online
Access: Lifetime Course Access
Time: Study at your own pace
Duration: 6-8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner