Certificate In Excel 365 Essentials Online Course

Access Your Speadsheets Anytime, Anywhere!

Certificate In Excel 365 Essentials Online 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
48%
4 star
31%
3 star
14%
2 star
5%
1 star
2%
(3369)
Average rating 4 out of 5 stars

15 September 2019 05:46:33 PM

I enjoyed completing this.

15 September 2019 02:54:17 PM

It was a good refresher for me and gave me a few tips to improve my own workspace.

12 September 2019 03:47:49 PM

Excellent Course, thoroughly enjoyed it.

12 September 2019 02:21:35 PM

cool

9 September 2019 08:35:35 PM

Awesome course

9 September 2019 02:40:01 AM

I found the course very helpful and it was presented well. I enjoyed it very much

8 September 2019 09:15:59 PM

I found the course an eye opener, inspiring and I found that personal success is halted by fear. But fear is merely a story about the future that has not been told yet.

8 September 2019 02:01:29 PM

i finish my personal success,and about this course is very good they gave me alot of idea how to be success of supervisor.

7 September 2019 12:40:10 PM

The greatest course around

5 September 2019 03:59:51 AM

This course is a true resource to apply in any field. Persoanally or professionally, the organizational skills that I received help to improve the quality of my life regarding to the time and energy invested in each activity. It is an usefull tool to kkep in mind always.

4 September 2019 10:23:14 PM

I HIGHLY RECOMEND THIS COURSE TO EVERYONE THAT COME ACROSS IT. IT HELPS BRING YOU BACK ON FOCUS.

4 September 2019 10:15:50 PM

IT IS AN ESSENTIAL COURSE FOR EVERYONE TO SET YOU ON THE RIGHT TRACK.
I RECOMMEND IT FOR EVERYONE TO BRING YOU BACK TO FOCUS

4 September 2019 09:16:27 PM

My review is very good. I love this course to many things that I can learn to be a good supervisor and leadership

4 September 2019 05:21:01 PM

Course material was good - content was kept light, but relevant. made the course easy to manage

3 September 2019 04:27:33 PM

thankyou very much.

2 September 2019 07:36:45 AM

I think it was a very inspiring type of course. It helped me realize certain things that I do that are obvious obstacles once I think about it, but I'm rarely conscious of, especially the part of emotion-managing. Thank you!

28 August 2019 09:19:38 PM

Great course

27 August 2019 12:22:52 AM

I've found the content of this course useful for improving my organization skills

26 August 2019 09:59:44 PM

This was very inspiring and has really got me excited about studying again

26 August 2019 01:05:37 PM

Very thorough and complete.

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 
(3369)
Average rating 4 out of 5 stars
5 star
48%
4 star
31%
3 star
14%
2 star
5%
1 star
2%

15 September 2019 05:46:33 PM

I enjoyed completing this.

15 September 2019 02:54:17 PM

It was a good refresher for me and gave me a few tips to improve my own workspace.

12 September 2019 03:47:49 PM

Excellent Course, thoroughly enjoyed it.

12 September 2019 02:21:35 PM

cool

9 September 2019 08:35:35 PM

Awesome course

9 September 2019 02:40:01 AM

I found the course very helpful and it was presented well. I enjoyed it very much

8 September 2019 09:15:59 PM

I found the course an eye opener, inspiring and I found that personal success is halted by fear. But fear is merely a story about the future that has not been told yet.

8 September 2019 02:01:29 PM

i finish my personal success,and about this course is very good they gave me alot of idea how to be success of supervisor.

7 September 2019 12:40:10 PM

The greatest course around

5 September 2019 03:59:51 AM

This course is a true resource to apply in any field. Persoanally or professionally, the organizational skills that I received help to improve the quality of my life regarding to the time and energy invested in each activity. It is an usefull tool to kkep in mind always.

4 September 2019 10:23:14 PM

I HIGHLY RECOMEND THIS COURSE TO EVERYONE THAT COME ACROSS IT. IT HELPS BRING YOU BACK ON FOCUS.

4 September 2019 10:15:50 PM

IT IS AN ESSENTIAL COURSE FOR EVERYONE TO SET YOU ON THE RIGHT TRACK.
I RECOMMEND IT FOR EVERYONE TO BRING YOU BACK TO FOCUS

4 September 2019 09:16:27 PM

My review is very good. I love this course to many things that I can learn to be a good supervisor and leadership

4 September 2019 05:21:01 PM

Course material was good - content was kept light, but relevant. made the course easy to manage

3 September 2019 04:27:33 PM

thankyou very much.

2 September 2019 07:36:45 AM

I think it was a very inspiring type of course. It helped me realize certain things that I do that are obvious obstacles once I think about it, but I'm rarely conscious of, especially the part of emotion-managing. Thank you!

28 August 2019 09:19:38 PM

Great course

27 August 2019 12:22:52 AM

I've found the content of this course useful for improving my organization skills

26 August 2019 09:59:44 PM

This was very inspiring and has really got me excited about studying again

26 August 2019 01:05:37 PM

Very thorough and complete.

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
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 No.: 020E3EOSC
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6-8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner