Об этом курсе: Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading. In this last course of our Specialization Excel Skills for Business you will build on the strong foundations of the first three courses: Essentials, Intermediate I + II. In the Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.
Для кого этот курс: Taking Excel Skills for Business: Advanced will complete the learning journey of this Specialization. Attaining the certificate at the end of the fourth course will be a highly valuable asset for anyone wanting to improve their employment portfolio. This course is for anyone who works with Excel on a regular basis, for self-taught learners with well-developed intermediate skills who want to fill gaps in their knowledge and for anyone wanting to consolidate their well-developed knowledge of Excel.
Автор: Macquarie University
Преподаватели: Dr Yvonne Breyer, Director, Learning and Teaching
Faculty of Business and Economics
| Основные сведения | Course 4 of 4 in the Excel Skills for Business Specialization |
| Уровень | Intermediate |
| Выполнение | 6 weeks of study, 2-4 hours per week |
| Язык | English |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
Программа курса
НЕДЕЛЯ 1
Spreadsheet Design and Documentation
As an intermediate Excel user, you have the basics down. The first module of the Advanced course focusses on creating and maintaining accurate, flexible, responsive and user-friendly spreadsheets. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes and formatting to tie it all up in a nice bow.
7 видео, 7 материалов для самостоятельного изучения, 4 practice quizzes
- Reading: Welcome
- Reading: Course Structure & Assessments
- Reading: Course goals and weekly learning objectives
- Discussion Prompt: Excel: Who, Why, How?
- Видео: Week 1 Introduction
- Видео: Week 1 Discussion
- Reading: Read me before you start: Quizzes and navigation
- Reading: Read me before you start: Versions and regions
- Reading: Download the Week 1 workbooks
- Видео: Practice Video: Spreadsheet Design Principles
- Practice Quiz: Spreadsheet Design Principles
- Видео: Practice Video: Calculations
- Practice Quiz: Calculations
- Видео: Practice Video: Formatting
- Practice Quiz: Formatting
- Видео: Practice Video: Documentation
- Practice Quiz: Documentation
- Видео: Practice Video: Interface and Navigation
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
Оцениваемый: Week 1 Final Assignment
НЕДЕЛЯ 2
Advanced Formula Techniques
Excel often requires you to perform complex analysis on large sets of data. This can be made a lot easier using array formulas, which can perform multiple calculations simultaneously and ensure the accuracy of your spreadsheet. This module covers the use of array formulas, how to build them and use them effectively.
7 видео, 2 материалов для самостоятельного изучения, 4 practice quizzes
- Видео: Week 2 Introduction
- Видео: Week 2 Discussion
- Reading: Download the Week 2 workbooks
- Видео: Practice Video: Tables and Structured Referencing
- Practice Quiz: Tables and Structured Referencing
- Видео: Practice Video: Using Functions to Sort Data
- Practice Quiz: Using Functions to Sort Data
- Видео: Practice Video: Introduction to Array Formulas
- Practice Quiz: Introduction to Array Formulas
- Видео: Practice Video: Working with an Array Function (TRANSPOSE)
- Видео: Practice Video: Solving Problems with Array Formulas
- Practice Quiz: Week 2 Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
Оцениваемый: Week 2 Final Assignment
НЕДЕЛЯ 3
Data Cleaning and Preparation
Been handed a messy spreadsheet? This module focuses on data cleaning and preparation. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically. We will use functions to fix dates, replaces blanks and remove unwanted characters from data – all to help us build an efficient solution that lasts.
7 видео, 2 материалов для самостоятельного изучения, 6 practice quizzes
- Видео: Week 3 Introduction
- Видео: Week 3 Discussion
- Reading: Download the Week 3 workbooks
- Видео: Practice Video: Replace blanks with repeating values
- Practice Quiz: Replace blanks with repeating values
- Видео: Practice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
- Practice Quiz: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
- Видео: Practice Video: Remove Unwanted Spaces (TRIM, CLEAN)
- Practice Quiz: Remove Unwanted Spaces (TRIM, CLEAN)
- Видео: Practice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)
- Practice Quiz: Diagnostic Tools (ISNUMBER, LEN, CODE)
- Видео: Practice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
- Practice Quiz: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
- Practice Quiz: Week 3 Practice Challenge
- Reading: Keyboard Shortcuts, Terminology, and Ninja Tips
Оцениваемый: Week 3 Final Assignment
НЕДЕЛЯ 4
Financial Functions and Working with Dates
This module introduces financial functions into our Excel knowledge base. Financial functions are often used in businesses and Excel has a variety of tools to help you with that. This week, you will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.
7 видео, 2 материалов для самостоятельного изучения, 5 practice quizzes
- Видео: Week 4 Introduction
- Видео: Week 4 Discussion
- Reading: Download the Week 4 workbooks
- Видео: Practice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
- Practice Quiz: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
- Видео: Practice Video: Financial Functions (FV, PV, PMT)
- Practice Quiz: Financial Functions (FV, PV, PMT)
- Видео: Practice Video: Loan Schedule (PMT, EDATE)
- Practice Quiz: Loan Schedule (PMT, EDATE)
- Видео: Practice Video: Net Present Value and Internal Rate of Return (NPV, IRR)
- Practice Quiz: Net Present Value and Internal Rate of Return (NPV, IRR)
- Видео: Practice Video: Depreciation Functions (SLN, SYD, DDB)
- Practice Quiz: Depreciation Functions (SLN, SYD, DDB)
- Reading: Keyboard Shortcuts, Excel Terminology, and Ninja Tips
Оцениваемый: Week 4 Final Assignment
НЕДЕЛЯ 5
Advanced Lookup Functions
It is always a good idea to make your spreadsheets (and work!) more automated. Automated lookups can make your work fast and efficient. This module builds on your array capabilities and explores a range of functions to create dynamic lookup ranges – INDIRECT, ADDRESS, OFFSET and INDEX.
6 видео, 2 материалов для самостоятельного изучения, 3 practice quizzes
- Видео: Week 5 Introduction
- Видео: Week 5 Discussion
- Reading: Download the Week 5 workbooks
- Видео: Practice Video: INDIRECT
- Practice Quiz: INDIRECT
- Видео: Practice Video: ADDRESS
- Practice Quiz: ADDRESS
- Видео: Practice Video: Introduction to OFFSET
- Practice Quiz: Introduction to OFFSET
- Видео: Practice Video: Solving Problems with OFFSET
- Reading: Keyboard Shortcuts, Excel Terminology, and Ninja Tips
Оцениваемый: Week 5 Final Assignment
НЕДЕЛЯ 6
Building Professional Dashboards
To bring it home, this module guides you through the steps of building a professional dashboard. Data is meaningless unless it tells a story and can be used as business intelligence. This module will help you set up a dashboard – learn how to visualise data through graphs and charts, create data models, and add interactivity.
7 видео, 2 материалов для самостоятельного изучения, 1 practice quiz
- Видео: Week 6 Introduction
- Видео: Week 6 Discussion
- Reading: Download the Week 6 workbooks
- Видео: Practice Video: Dashboard Design
- Practice Quiz: Dashboard Design
- Видео: Practice Video: Prepare Data
- Видео: Practice Video: Construct Dashboard
- Видео: Practice Video: Creative Charting
- Видео: Practice Video: Interactive Dashboard
- Reading: Keyboard Shortcuts, Excel Terminology, and Ninja Tips
Final Assessment
Оцениваемый: Final Assessment
Часто задаваемые вопросы
Как это работает
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.
Авторы
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.
Стоимость
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| Earn a shareable Course Certificate | Доступен |
Рейтинги и отзывы
this course was awesome, it's full of challenge I like it
thank you
This course gives good examples in lecture, also very good practice after class.
It's a great course for Excel users. I've looked for a course like this for a long time, but have found only either too simple or too complicated (more about data analysis not related to Excel itself) courses. This one is just perfect, and I'm using it in my work and really enjoy it. I've already recommended this course to my colleagues and would recommend it to everybody who uses Excel in their work.
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
MG
Excellent coverage of key concepts, with thorough applications.