Excel Intermediate Workshop (Udemy.com)

A hands-on Microsoft Excel course for people who know Excel basics and wish to become more confident Excel users.

( 30 Reviews )

Created by: Grant Gamble

Produced in 2016

What you will learn

Use Microsoft Excel 2013 more confidently and effectively, gain a deeper insight into functions, formulas, charts and pivot tables.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course Description

This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using Microsoft Excel. It provides step-by-step practice in building Excel formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS.
The course also covers Excel charts, sparklines, conditional formating, and graphics. It then moves on to look at all of Excel's key facilities for working with tabular data: customized sorting and filtering, subtotalling and the use of Excel tables and pivot tables.
All of the Excel worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.
Last course update: December 2016
In the most recent update to this course, you will construct a basic invoicing system and at the same time get a chance to practice using advanced formulas, data validation and worksheet protection.Who this course is for:

This course is suitable for those with a basic knowledge of Excel, who have perhaps had some basic training in using the program, or those who are self-taught.

Time: 6h

Instructor Details

Grant Gamble

4.8 Rating
30 Reviews

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.
His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.8

30 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By John Pavlenkov

Explanations are clear. Amount of time for each session is very reasonable to retain and practice skill

By Hamood Sumry

The trainer has amazing way of teaching, he delivers in a very crystal clear way.

By Artur Gotz

So far so good, the instructor is very concise and gets straight to the point.

By Zaira Wilson

I'm learning...love it!

By Mark ElMdy

It's really a very great and awesome course.

I had enrolled 7 courses about Excel but this course is an exception, the instructor gives details and give to students the maximum possible of time and effort for explaining to him the difficult points.

A special thanks to GRANT GAMBLE

By Hamid

Easy to follow, informative, simple explaintion , Thanks Sir for that

By Adewuyi Ayodele Adeyinka

The presenter simplifies the use of excel with clear accent and he is not too swift. Even though am at the early stages of the course, looking through the course outline, it is well organised.

By Mary Saner

Very good course. It has given me a deeper insight into many Excel features I thought I knew.

By Frank Michalak

This course is laid out in a very logical manner and provides some useful training.

By Antonia Denney

Getting a lot out of this course and learning a lot of new skills. The explanations are easy to understand and the practice files are also quite useful.

By Jaciems