- Platform
- Coursera
- Provider
- Macquarie University
- Effort
- 2-4 hours/week
- Length
- 6 weeks
- Language
- English
- Credentials
- Paid Certificate Available
- Part of
- Course Link
Overview
In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses.
We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come.
Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
Who is this class for: Completing the course Excel Skills for Business: Essentials will be a highly valuable asset for anyone wanting to improve their employment portfolio. This course is for newcomers to Excel, for self-taught learners who want to fill gaps in their knowledge and for anyone wanting to consolidate their foundational knowledge of Excel in order to progress to a more advanced level of Excel.
Taught by
Dr Yvonne Breyer
In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.
Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses.
We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come.
Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
Who is this class for: Completing the course Excel Skills for Business: Essentials will be a highly valuable asset for anyone wanting to improve their employment portfolio. This course is for newcomers to Excel, for self-taught learners who want to fill gaps in their knowledge and for anyone wanting to consolidate their foundational knowledge of Excel in order to progress to a more advanced level of Excel.
Syllabus
WEEK 1
Critical Core of Excel
In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
WEEK 2
Performing calculations
The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions - learn how to write them, use them to perform calculations and understand the different cell references.
WEEK 3
Formatting
Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.
WEEK 4
Working with Data
This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
WEEK 5
Printing
Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.
WEEK 6
Charts
Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.
Final Assessment
WEEK 1
Critical Core of Excel
In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
WEEK 2
Performing calculations
The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions - learn how to write them, use them to perform calculations and understand the different cell references.
WEEK 3
Formatting
Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.
WEEK 4
Working with Data
This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
WEEK 5
Printing
Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.
WEEK 6
Charts
Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.
Final Assessment
Taught by
Dr Yvonne Breyer