Excel Skills for Business: Advanced

  • 4.7
Approx. 25 hours to complete

Course Summary

Excel Advanced is a course designed for experienced Excel users who want to take their skills to the next level. It covers advanced functions, data analysis tools, and automation techniques.

Key Learning Points

  • Learn advanced Excel functions and data analysis tools
  • Automate tasks using macros and Visual Basic for Applications (VBA)
  • Create interactive dashboards and reports

Related Topics for further study


Learning Outcomes

  • Ability to use advanced Excel functions and data analysis tools
  • Proficiency in creating automated tasks using macros and VBA
  • Ability to create interactive dashboards and reports

Prerequisites or good to have knowledge before taking this course

  • Basic knowledge of Excel
  • Access to Microsoft Excel

Course Difficulty Level

Advanced

Course Format

  • Online
  • Self-paced

Similar Courses

  • Excel VBA
  • Data Analysis and Visualization

Related Education Paths


Notable People in This Field

  • Excel MVP and Author
  • Excel MVP and Trainer

Related Books

Description

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.

Outline

  • Spreadsheet Design and Documentation
  • Week 1 Introduction
  • Week 1 Discussion
  • Practice Video: Spreadsheet Design Principles
  • Practice Video: Calculations
  • Practice Video: Formatting
  • Practice Video: Documentation
  • Practice Video: Interface and Navigation
  • Welcome
  • Course Structure & Assessments
  • Course goals and weekly learning objectives
  • Read me before you start: Quizzes and navigation
  • Read me before you start: Versions and regions
  • Download the Week 1 workbooks
  • Keyboard Shortcuts, Terminology, and Ninja Tips
  • Spreadsheet Design Principles
  • Calculations
  • Formatting
  • Documentation
  • Week 1 Final Assignment
  • Advanced Formula Techniques
  • Week 2 Introduction
  • Week 2 Discussion
  • Practice Video: Tables and Structured Referencing
  • Practice Video: Using Functions to Sort Data
  • Practice Video: Introduction to Array Formulas
  • Practice Video: Working with an Array Function (TRANSPOSE)
  • Practice Video: Solving Problems with Array Formulas
  • Download the Week 2 workbooks
  • Keyboard Shortcuts, Terminology, and Ninja Tips
  • Tables and Structured Referencing
  • Using Functions to Sort Data
  • Introduction to Array Formulas
  • Week 2 Practice Challenge
  • Week 2 Final Assignment
  • Data Cleaning and Preparation
  • Week 3 Introduction
  • Week 3 Discussion
  • Practice Video: Replace blanks with repeating values
  • Practice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
  • Practice Video: Remove Unwanted Spaces (TRIM, CLEAN)
  • Practice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)
  • Practice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
  • Download the Week 3 workbooks
  • Keyboard Shortcuts, Terminology, and Ninja Tips
  • Replace blanks with repeating values
  • Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
  • Remove Unwanted Spaces (TRIM, CLEAN)
  • Diagnostic Tools (ISNUMBER, LEN, CODE)
  • Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
  • Week 3 Practice Challenge
  • Week 3 Final Assignment
  • Financial Functions and Working with Dates
  • Week 4 Introduction
  • Week 4 Discussion
  • Practice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
  • Practice Video: Financial Functions (FV, PV, PMT)
  • Practice Video: Loan Schedule (PMT, EDATE)
  • Practice Video: Net Present Value and Internal Rate of Return (NPV, IRR)
  • Practice Video: Depreciation Functions (SLN, SYD, DDB)
  • Download the Week 4 workbooks
  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips
  • Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
  • Financial Functions (FV, PV, PMT)
  • Loan Schedule (PMT, EDATE)
  • Net Present Value and Internal Rate of Return (NPV, IRR)
  • Depreciation Functions (SLN, SYD, DDB)
  • Week 4 Final Assignment
  • Advanced Lookup Functions
  • Week 5 Introduction
  • Week 5 Discussion
  • Practice Video: INDIRECT
  • Practice Video: ADDRESS
  • Practice Video: Introduction to OFFSET
  • Practice Video: Solving Problems with OFFSET
  • Download the Week 5 workbooks
  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips
  • INDIRECT
  • ADDRESS
  • Introduction to OFFSET
  • Week 5 Final Assignment
  • Building Professional Dashboards
  • Week 6 Introduction
  • Week 6 Discussion
  • Practice Video: Dashboard Design
  • Practice Video: Prepare Data
  • Practice Video: Construct Dashboard
  • Practice Video: Creative Charting
  • Practice Video: Interactive Dashboard
  • Download the Week 6 workbooks
  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips
  • Dashboard Design
  • Final Assessment
  • Final Assessment

Summary of User Reviews

Excel Advanced is a highly recommended course by many users. It offers comprehensive and practical knowledge on Excel, with hands-on exercises that allow users to apply the concepts learned. One key aspect that many users found great is the instructors' ability to explain complex Excel functions in a simple and easy-to-understand manner.

Pros from User Reviews

  • Comprehensive and practical knowledge on Excel
  • Hands-on exercises to apply concepts learned
  • Instructors explain complex Excel functions in a simple and easy-to-understand manner

Cons from User Reviews

  • Some users found the course too basic for their level of knowledge
  • A few users reported technical issues with the platform
  • The course can be time-consuming, requiring a significant time commitment
English
Available now
Approx. 25 hours to complete
Nicky Bull, Dr Prashan S. M. Karunaratne, A/Professor Yvonne Breyer
Macquarie University
Coursera

Instructor

Nicky Bull

  • 4.7 Raiting
Share
Saved Course list
Cancel
Get Course Update
Computer Courses