Excel Skills for Business: Intermediate

Categories: All Department
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

There are 7 modules in this course

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 this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to

Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.

Show More

Course Content

Data Validation – Week 1

  • 01_01_welcome-to-excel-skills-for-business-intermediate_instructions
  • 01_02_course-goals-and-weekly-learning-objectives_instructions
  • 02_01_week-1-introduction
    02:22
  • 02_02_Week-1-Discussion
    04:28
  • 03_02_read-me-before-you-start-versions-and-regions_instructions
  • 03_03_download-the-week-1-workbooks_instructions
  • 03_04_practice-video-data-validation
    06:58
  • 03_05_practice-video-creating-drop-down-lists
    06:28
  • 03_06_practice-video-using-formulas-in-data-validation
    07:00
  • 03_07_practice-video-working-with-data-validation
    07:38
  • 03_08_practice-video-advanced-conditional-formatting
    05:20
  • 03_09_week-1-wrap-up
    00:00
  • 04_01_keyboard-shortcuts-excel-terminology-and-ninja-tips_instructions

Conditional Logic – Week 2

Automating Lookups – Week 3

Formula Auditing and Protection – Week 4

Data Modelling – Week 5

Recording Macros – Week 6

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?