Course description
Many people and organisations always use spreadsheet applications to handle various data visualisation tasks. Google Sheets and Microsoft Excel are among today’s most popular and useful programs. This course explains how to use Microsoft Excel to boost productivity. We begin with the basics such as installing and starting up Excel, saving a workbook and changing preferences and formatting elements to suit your needs.
We then examine the use of formulas and comparison operators in Excel. Some people find it difficult to work with Excel so this course uses simple terms to explain how to perform each function step by step. We demonstrate how to print a workbook and manage your passwords in Excel. We then go through the use of important advanced spreadsheet features like ‘IF’ functions.
This Excel tutorial provides a strong understanding of the program and the skills that make you a spreadsheet expert. These data visualisation skills can also be applied with Google Sheets and boost your professional value in most career fields. Most white collar jobs require some familiarity with spreadsheets so sign up for this MS Excel tutorial to become the office expert with invaluable skills.
Upcoming start dates
Training content
Microsoft Excel Basics
Description: This module will introduce you to Excel basics such as the meaning of spreadsheets and their uses. We will begin on how to start up Excel, formatting elements in Microsoft Excel, and their various applications.
- Learning Outcomes
- Introduction, Excel Basics and Formatting Elements
- Application of Excel Formatting Elements
- Excel Formulas and Saving a Workbook
- Lesson Summary
Advanced Excel Functions and Features
Description: In this module, you will be introduced to Microsoft Excel functions (beginner to advanced functions), how to print excel document (workbook), password management, and other important topics.
- Learning Outcomes
- Excel Functions
- Advanced Functions
- Printing Workbook and Setting Excel Passwords
- Lesson Summary
Course assessment
- Assessment: Mastering the Basics of Microsoft Excel - Course Assessment
Certification / Credits
By the end of this course, you will be able to:
- Define ‘Microsoft Excel’ and ‘spreadsheets’
- Describe how to print an Excel document
- Explain nested ‘IF’ functions
- Outline how to start Microsoft Excel
- Define the ‘workbook’ and demonstrate how to save it
- Discuss how to set passwords in Excel
- Explain ‘IF’ functions
- Summarise selected advanced functions
- List the uses of Microsoft Excel
- Recall MS Excel formulas and formatting elements
- Explain the program's comparison operators
Quick stats about Alison?
Providing Free Online Learning since 2007
Over 45 Million Learners across 193 Countries have studied with us
Over 5 Million people use the Alison Learning App, where you can study anywhere and anytime
Contact this provider
Alison Free Learning
Alison is the world’s largest free online empowerment platform for education and skills training, offering thousands of CPD-accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone,...