Home » Blog » Excel Skills for Business: Intermediate I

Excel Skills for Business: Intermediate I

Online Course. This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today.

About 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 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.

In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.

Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel – shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma’s trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.

Syllabus – What you will learn from this course

  • Working with Multiple Worksheets & Workbooks
  • Text and Date Functions
  • Named Ranges
  • Summarising Data
  • Tables
  • Pivot Tables, Charts and Slicers

Skills you will gain

  • Concatenation
  • Microsoft Excel
  • Consolization
  • Pivot Table
  • Pivot Chart
 

See more Excel Courses

See also...

Excel VBA - How to Write Macros Like a Professional online course for health economists

Excel VBA: How to Write Macros Like a Professional

Online course. Learn how to write real-world Excel VBA Macros from scratch. No experience required! ... Read more

SAS Programming Course For Beginners online course

Learn SAS. SAS Programming Course For Beginners

Learn SAS and Become a Data Ninja. SAS Base Programming. What Will I Learn? Apply ... Read more

Online Course on Data Analysis and Presentation Skills: The PwC Approach

Data Analysis and Presentation Skills

Online Course. Make Smarter Business Decisions With Data Analysis. Understand data, apply data analytics tools ... Read more

Complete Python Bootcamp: Go from zero to hero in Python 3 online course for health economists

Complete Python Bootcamp: Go from zero to hero in Python 3

Learn Python like a Professional! Start from the basics and go all the way to ... Read more

Google Sheets - Dashboard Design an Online Course for health economists

Google Sheets – Dashboard Design

Online Course. Creating a dynamic page with custom user input. What you’ll learn? Filter and ... Read more

Microsoft Excel - Data Visualization, Excel Charts and Graphs Online course for heath economists

Microsoft Excel – Data Visualization, Excel Charts & Graphs

Online Course. Master 20+ Excel charts & graphs in Microsoft Excel 2016 with hands-on demos ... Read more