Informações sobre o curso: 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.
Para quem é direcionado este curso: 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.
Desenvolvido por: Macquarie University
Ministrado por: Dr Yvonne Breyer, Director, Learning and Teaching
Faculty of Business and Economics
| Informações básicas | Curso 1 de 4 no Excel Skills for Business Specialization |
| Nível | Beginner |
| Compromisso | 6 weeks of study, 2-4 hours per week |
| Idioma | English |
| Como ser aprovado | Seja aprovado em todas as tarefas para concluir o curso. |
| Classificação do usuário |
Programa
SEMANA 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.
10 vídeos, 8 leituras, 6 questionários de prática
- Reading: Welcome to Excel Skills for Business: Essentials
- Reading: Course goals and weekly learning objectives
- Reading: Important information about versions and regions
- Practice Quiz: Are essential skills too basic for me?
- Discussion Prompt: Set your goals and be successful
- Vídeo: Week 1 Introduction
- Vídeo: Week 1 Discussion
- Reading: Read me before you start: Quizzes and Navigation
- Reading: Download the Week 1 workbooks
- Vídeo: Practice Video: Taking Charge of Excel
- Practice Quiz: Taking Charge of Excel
- Vídeo: Practice Video: Navigating and Selecting
- Practice Quiz: Navigating and Selecting
- Vídeo: Practice Video: View Options
- Practice Quiz: View Options
- Vídeo: Practice Video: Data Entry, Data Types, Editing and Deleting
- Practice Quiz: Data Entry
- Vídeo: Practice Video: Fill Handle
- Practice Quiz: Fill handle
- Vídeo: Week 1 Wrap-up
- Reading: Week 1: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- Vídeo: Copy and Paste
- Vídeo: Templates
- Reading: Excellent Tips and Resources
Nota atribuída: Taking Charge of Excel: Test your skills, Part 1
Nota atribuída: Taking Charge of Excel: Test your skills, Part 2
SEMANA 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.
11 vídeos, 5 leituras, 6 questionários de prática
- Vídeo: Week 2 Introduction
- Vídeo: Week 2 Discussion
- Reading: Download the Week 2 workbooks
- Vídeo: Practice Video: Formulas
- Practice Quiz: Formulas
- Vídeo: Practice Video: Formulas in Context
- Practice Quiz: Formulas in Context
- Vídeo: Practice Video: Functions I: SUM and AUTOSUM
- Practice Quiz: Functions I
- Vídeo: Practice Video: Functions II: AVERAGE, MIN and MAX
- Practice Quiz: Functions II
- Vídeo: Discussion: Absolute Cell References
- Vídeo: Practice Video: Absolute Cell References
- Practice Quiz: Absolute Cell References
- Vídeo: Practice Video: Calculations across sheets
- Practice Quiz: Calculations across Sheets
- Vídeo: Week 2 Wrap-up
- Reading: Week 2: Practice Challenges
- Reading: Word Search Puzzle: Master ranges
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- Vídeo: Excel Options
- Reading: Excellent Tips and Resources
Nota atribuída: Performing Calculations: Test your skills
SEMANA 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.
10 vídeos, 4 leituras, 6 questionários de prática
- Vídeo: Week 3 Introduction
- Vídeo: Week 3 Discussion
- Reading: Download the Week 3 workbooks
- Vídeo: Practice Video: Formatting
- Practice Quiz: Formatting
- Vídeo: Practice Video: Borders
- Practice Quiz: Borders
- Vídeo: Practice Video: Alignment Tools
- Practice Quiz: Alignment Tools
- Vídeo: Practice Video: Format Painter
- Practice Quiz: Format Painter
- Vídeo: Practice Video: Number Formats
- Practice Quiz: Number Formats
- Vídeo: Practice Video: Styles and Themes
- Practice Quiz: Styles and Themes
- Vídeo: Week 3 Wrap-up
- Reading: Week 3: Practice Challenge
- Reading: Keyboard Shortcuts and Ninja Tips
- Vídeo: Graphics
- Reading: Excellent Tips and Resources
Nota atribuída: Formatting: Test your skills
SEMANA 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.
9 vídeos, 3 leituras, 5 questionários de prática
- Vídeo: Week 4 Introduction
- Vídeo: Week 4 Discussion
- Reading: Download the Week 4 workbooks
- Vídeo: Practice Video: Managing Rows and Columns
- Practice Quiz: Managing Rows and Columns
- Vídeo: Practice Video: Find and Replace
- Practice Quiz: Find and Replace
- Vídeo: Practice Video: Filtering
- Practice Quiz: Filtering
- Vídeo: Practice Video: Sorting
- Practice Quiz: Sorting
- Vídeo: Practice Video: Conditional Formatting
- Practice Quiz: Conditional Formatting
- Vídeo: Week 4 Wrap-up
- Reading: Week 4: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- Vídeo: Accessibility
Nota atribuída: Working with Data: Test your skills
SEMANA 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.
9 vídeos, 5 leituras, 5 questionários de prática
- Vídeo: Week 5 Introduction
- Vídeo: Week 5 Discussion
- Reading: Print to PDF - Setup Tips
- Reading: Download the Week 5 workbooks
- Vídeo: Practice Video: Print Preview
- Practice Quiz: Print Preview
- Vídeo: Practice Video: Orientation, Margins and Scale
- Practice Quiz: Orientation, Margins and Scale
- Vídeo: Practice Video: Page Breaks
- Practice Quiz: Page Breaks
- Vídeo: Practice Video: Print Titles
- Practice Quiz: Print Titles
- Vídeo: Practice Video: Headers and Footers
- Practice Quiz: Headers and Footers
- Vídeo: Week 5 Wrap-up
- Reading: Week 5: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- Vídeo: Save Options
- Reading: Excellent Tips and Resources
Nota atribuída: Printing: Test your skills
SEMANA 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.
8 vídeos, 4 leituras, 4 questionários de prática
- Vídeo: Week 6 Introduction
- Vídeo: Week 6 Discussion
- Reading: Download the Week 6 workbooks
- Vídeo: Practice Video: Basic Chart Types: Pie, Column and Line Charts
- Practice Quiz: Basic Chart Types
- Vídeo: Practice Video: Move and Resize Charts
- Practice Quiz: Move and Resize Charts
- Vídeo: Practice Video: Change Chart Style & Type
- Practice Quiz: Change Chart Style & Type
- Vídeo: Practice Video: Modify Chart Elements
- Practice Quiz: Modify Chart Elements
- Vídeo: Week 6 Wrap-up
- Reading: Week 6: Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
- Vídeo: Sharing Charts
- Reading: Excellent Tips and Resources
Nota atribuída: Charts: Test your skills
Final Assessment
Nota atribuída: Course 1 Final Assessment
Perguntas frequentes
Como funciona
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Desenvolvedores
Macquarie University
Macquarie is a hub of inspired and unconstrained thinking. Macquarie was founded with a unique purpose: to bring minds together unhindered by tradition. Created to challenge the education establishment, Macquarie has a rich track record of innovation. Macquarie actively shapes the complex issues that define the future of humanity.
Custo
| Comprar curso | |
|---|---|
| Acesso aos materiais do curso | Disponível |
| Acesso a materiais valendo nota | Disponível |
| Receba uma nota final | Disponível |
| Obtenha um Certificado de Curso compartilhável | Disponível |
Classificações e avaliações
Good
This is perfect course for beginners
Great course and very in-depth!
O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.
© 2018 Coursera Inc. Todos os direitos reservados.
excellent, easy to follow with achievable exercises, tests and exam. A definite requirement to gain all basics of the tool and make one competent at daily excel tasks.