Excel Skills for Business: Intermediate I

  • 4.9
Approx. 30 hours to complete

Course Summary

This intermediate-level course on Excel covers advanced functions, data analysis, and visualization techniques to improve productivity and efficiency. By the end of the course, you will have a solid understanding of Excel's capabilities and be able to apply them in a professional setting.

Key Learning Points

  • Learn advanced Excel functions such as IF statements, VLOOKUP, and pivot tables
  • Master data analysis techniques and visualization tools
  • Develop Excel skills that will enhance your productivity and efficiency in the workplace

Related Topics for further study


Learning Outcomes

  • Ability to apply advanced Excel functions in a professional setting
  • Proficiency in data analysis and visualization techniques
  • Increased productivity and efficiency in the workplace

Prerequisites or good to have knowledge before taking this course

  • Basic knowledge of Excel
  • Access to a computer with Microsoft Excel installed

Course Difficulty Level

Intermediate

Course Format

  • Online
  • Self-paced
  • Video lectures

Similar Courses

  • Excel for Beginners
  • Excel for Data Analysis

Related Education Paths


Related Books

Description

Spreadsheet software remains 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. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs.

Outline

  • Working with Multiple Worksheets & Workbooks
  • Week 1 Introduction
  • Week 1 Discussion
  • Practice Video: Multiple Worksheets
  • Practice Video: 3D Formulas
  • Practice Video: Linking Workbooks
  • Practice Video: Consolidating by Position
  • Practice Video: Consolidating by Category (Reference)
  • Week 1 Wrap-Up
  • Welcome to Excel Skills for Business: Intermediate I
  • Course Goals and Weekly Learning Objectives
  • Read me before you start: Quizzes and Navigation
  • Download the Week 1 workbooks
  • Read me before you start: Versions and regions
  • Week 1: Practice Challenge
  • Week 1: Advanced Practice Challenge
  • Keyboard Shortcuts, Excel Terminology and Ninja Tips
  • Multiple Worksheets
  • 3D Formulas
  • Linking Workbooks
  • Consolidating by Position
  • Consolidating by Category (Reference)
  • Test your Skills: Working with Multiple Worksheets & Workbooks
  • Text and Date Functions
  • Week 2 Introduction
  • Week 2 Discussion
  • Practice Video: Combining Text (CONCAT, &)
  • Practice Video: Changing Text Case (UPPER, LOWER, PROPER)
  • Practice Video: Extracting Text (LEFT, MID, RIGHT)
  • Practice Video: Finding Text (FIND)
  • Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)
  • Week 2 Wrap-Up
  • Download the Week 2 workbooks
  • Week 2: Practice Challenge
  • Keyboard Shortcuts, Excel Terminology and Ninja Tips
  • Combining Text (CONCAT, &)
  • Changing Text Case (UPPER, LOWER, PROPER)
  • Extracting Text (LEFT, MID, RIGHT)
  • Finding Text (FIND)
  • Date Calculations (NOW, TODAY, YEARFRAC)
  • Test your Skills: Text and Date Functions
  • Named Ranges
  • Week 3 Introduction
  • Week 3 Discussion
  • Practice Video: Introducing Named Ranges
  • Practice Video: Creating Named Ranges
  • Practice Video: Managing Named Ranges
  • Practice Video: Named Ranges in Formulas
  • Practice Video: Apply Names
  • Week 3 Wrap-Up
  • Download the Week 3 workbooks
  • Week 3: Practice Challenge
  • Keyboard Shortcuts, Terminology and Ninja Tips
  • Introducing Named Ranges
  • Creating Named Ranges
  • Managing Named Ranges
  • Named Ranges in Formulas
  • Apply Names
  • Test your Skills: Named Ranges
  • Summarising Data
  • Week 4 Introduction
  • Week 4 Discussion
  • Practice Video: COUNT functions
  • Practice Video: Counting with Criteria (COUNTIFS)
  • Practice Video: Adding with Criteria (SUMIFS)
  • Practice Video: Sparklines
  • Practice Video: Advanced Charting
  • Practice Video: Trendlines
  • Week 4 Wrap-Up
  • Download the Week 4 workbooks
  • Week 4: Practice Challenge
  • Keyboard Shortcuts, Excel Terminology and Ninja Tips
  • COUNT functions
  • Counting with Criteria (COUNTIFS)
  • Adding with Criteria (SUMIFS)
  • Sparklines
  • Advanced Charting
  • Trendlines
  • Test your Skills: Summarising Data
  • Tables
  • Week 5 Introduction
  • Week 5 Discussion
  • Practice Video: Creating and Formatting Tables
  • Practice Video: Working with Tables
  • Practice Video: Sorting and Filtering in Tables
  • Practice Video: Automation with Tables
  • Practice Video: Converting to Range and Subtotaling
  • Week 5 Wrap-Up
  • Download the Week 5 workbooks
  • Week 5: Practice Challenge
  • Keyboard Shortcuts, Excel Terminology and Ninja Tips
  • Creating and Formatting Tables
  • Working with Tables
  • Sorting and Filtering in Tables
  • Automation with Tables
  • Converting to Range and Subtotaling
  • Test your Skills: Tables
  • Pivot Tables, Charts and Slicers
  • Week 6 Introduction
  • Week 6 Discussion
  • Practice Video: Creating and Modifying a Pivot Table
  • Practice Video: Value Field Settings
  • Practice Video: Sorting and Filtering a Pivot Table
  • Practice Video: Reporting Filter Pages
  • Practice Video: Pivoting Charts
  • Practice Video: Pivoting Slicers
  • Week 6 Wrap-Up
  • Download the Week 6 workbooks
  • Week 6: Practice Challenge
  • Keyboard Shortcuts, Excel Terminology and Ninja Tips
  • Creating and Modifying a Pivot Table
  • Value Field Settings
  • Sorting and Filtering a Pivot Table
  • Report Filter Pages
  • Pivoting Charts
  • Pivoting Slicers
  • Test your Skills: Pivot Tables, Charts and Slicers
  • Final Assessment
  • Final Assessment

Summary of User Reviews

Find out what users are saying about Excel Intermediate 1 course on Coursera. Overall, the reviews are positive with many users commending the hands-on approach in teaching Excel. One key aspect that many users thought was good is the practical exercises that help learners apply what they have learned in real-life situations.

Pros from User Reviews

  • The course provides a clear and concise overview of intermediate Excel functions and features.
  • The practical exercises are helpful in reinforcing the concepts taught in the lectures.
  • The instructors are knowledgeable and engaging, making the course enjoyable to follow.
  • The course materials are well-structured and easy to follow, even for beginners.

Cons from User Reviews

  • The course is not challenging enough for advanced Excel users.
  • Some users found the pace of the course to be too slow.
  • The videos could be shorter to make the course more concise.
  • The course could benefit from more advanced topics and real-life examples.
English
Available now
Approx. 30 hours to complete
Nicky Bull, Dr Prashan S. M. Karunaratne, A/Professor Yvonne Breyer
Macquarie University
Coursera

Instructor

Nicky Bull

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