Acerca de este 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 quién es esta clase: 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.
Creada por: Universidad de Macquarie
Enseñado por: Dr Yvonne Breyer, Director, Learning and Teaching
Faculty of Business and Economics
| Información básica | Curso 1 de 4 en Excel Skills for Business Specialization |
| Nivel | Beginner |
| Compromiso | 6 weeks of study, 2-4 hours per week |
| Idioma | English |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
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 videos, 8 readings, 6 practice quizzes
- 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
Calificado: Taking Charge of Excel: Test your skills, Part 1
Calificado: 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 videos, 5 readings, 6 practice quizzes
- 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
Calificado: 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 videos, 4 readings, 6 practice quizzes
- 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
Calificado: 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 videos, 3 readings, 5 practice quizzes
- 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
Calificado: 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 videos, 5 readings, 5 practice quizzes
- 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
Calificado: 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 videos, 4 readings, 4 practice quizzes
- 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
Calificado: Charts: Test your skills
Final Assessment
Calificado: Course 1 Final Assessment
Preguntas Frecuentes
Cómo 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.
Creadores
Universidad de Macquarie
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.
Tarifa
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
Calificaciones y revisiones
I overestimated my Excel skills and this course filled in all my knowledge gaps. Thank you for this great course!
It is an important class for professionals because I was lucky to me
The class was challenging, yet explained very well. I felt much more confident in my basic knowledge of Excel. Would definitely recommend it to others! I work exceptionally long hours, and though it was challenging at times, I felt a strong sense of accomplishments! Thank you!
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
md
It's a great course! In just a couple of weeks I learned so many useful things which have already helped me to improve my daily tasks. Throughout the course I found a couple of questions hard to answer to because of the the way they were formulated, but I contacted the support and they helped straight away