Book a Free Video Consultation!
If you have any questions or would like to speak to one of our team before enrolling feel free to book a free video call with us by clicking the button below, we will be delighted to meet you on Google Meet!
Excel 365 Essentials
Individual Licence (EUR 40)
Rs.6,300.00
Skip to product information
Excel 365 Essentials
Rs.6,300.00
Reliable shipping
Flexible returns
Buying for a team?
Choose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.
Develop practical knowledge and confidence in Excel 365 Essentials.
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.
Why this course matters
This course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.
What you will gain
- Use the key features and workflows covered in Excel 365 Essentials with greater confidence.
- Apply the tools and techniques to practical business tasks.
- Recognise common mistakes and work more efficiently in day-to-day use.
Who is this course for?
This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.
Course at a glance
- Format: self-paced online learning.
- Professional development: CPD course.
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.
Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.
Course Outline
Module One: Getting Started
Workshop Objectives
Module Two: Welcome to Office 365 Excel
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)
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
Continue your learning
Part of this learning pathway: Microsoft Office & Windows
Learners also take: Excel 2013 Advanced | Excel 2013 Essentials | Excel 2013 Expert
Course pathway: eBSI SME Academy > Microsoft Office & Windows > Excel 365 Essentials
Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.