Mastering MS Excel
4.3 (172 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,119 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering MS Excel to your Wishlist.

Add to Wishlist

Mastering MS Excel

Master MS Excel 2010-2016 in 5hrs of easy to follow videos
4.3 (172 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,119 students enrolled
Created by Mr Alvin Pillay
Last updated 3/2017
English
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use MS Excel to advance their career and improve their job prospects.
  • Use MS Excel to achieve outputs more quickly, effiecently and intelligently.
View Curriculum
Requirements
  • Students will need to know how to use a computer.
  • Students do NOT need to know MS Excel.
  • Students must have MS Office 2010, 2013 or 2016 installed on their computer.
  • A computer with a windows operating system is recommended.
Description

The Mastering MS Excel is aimed at MS Excel 2010 to 2016. The course videos are based on MS Excel 2016, used on a Windows computer. No prior knowledge of MS Excel is required. The course will take you from the beginner level to the advanced level.

The course focuses on those aspects that are important in everyday working life and helps you get the most out of MS Excel. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, PivotCharts and Interactive Dashboards.

The course is aimed at job seekers trying to gain MS Excel Skills for todays job market. It will also help existing workers, who use MS Excel, to fascinate and astound their colleagues and managers with their newly gained skills.


Course Breakdown:

Chapter 1        covers important definitions of the terms : spreadsheet, workbook, worksheet and cell. It also covers how to start MS Excel, and the layout of the window, including the ribbon menu.

Chapter 2        is editing and looks at font sizes, types, colors, text alignment, text wrap, merging cells, borders and shading.

Chapter 3        looks at formatting cells as decimals, currency, percent and date&time.

Chapter 4        opens up new opportunities for you to dazzle people. We discuss conditional formatting.

Chapter 5        looks at how you can move easily and quickly around a worksheet containing data. You will be impressed.

Chapter 6        covers copying, cutting, pasting and moving data

Chapter 7        is the longest chapter and looks at the most powerful feature of excel that sets it apart from other applications. You will learn about formulas and cover functions such as If, Nested Ifs, Count functions, String functions, DateTime functions, Random number generator functions and more.

Chapter 8        delves into the powerful VLookUp function. You’ll wonder how you ever managed without it.

Chapter 9        slows down to a more gentle pace, giving your tired brain a rest, by covering sorting and filtering data.

Chapter 10      will dazzle you with creating Graphs, or Charts, as it is called in Excel. We’ll start with simple graphs and end with some complex ones that very few people know how to create.

Chapter 11      teaches you about a tool that makes data analysis easy-pezee. It’s the awesome Pivot table.

Chapter 12      takes this one step further with the power of pivot charts and slicers. We’ll also show you how to create an INTERACTIVE dashboard.

Chapter 13      shows you how to make your life easier by formatting your data as tables.

Chapter 14      covers Macros. This makes repetitive tasks easy-peeze.

Chapter 15      covers the remaining exciting concepts of: Removing duplicate data rows, defining named ranges, creating a pick list using data validation, protecting your sheet and workbook, inserting fancy graphics. And finally creating a Contents sheet.


Be rest assured that this course does not cover VBA programming. All that you learn is done without any programming.


Best of luck in your future endeavours.


Who is the target audience?
  • Anyone wanting to learn MS Excel quickly and easily.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
53 Lectures
05:10:00
+
Introduction to MS Excel
4 Lectures 28:29

An introduction to this course. It covers - Course Objectives, Minimum Requirements, About Me, Course Chapters and Downloadable materials

All downloadable material for this entire course is available in this lecture. Check under the "Downloadable materials" section. It contains a zip file that has files for some of the chapters in this course as well as an Excel file that lists all the chapters. At the start of the filename, their are two digits that give the chapter to which the spreadsheet refers to.

Preview 08:54

What is a Spreadsheet, Workbook, Worksheet and Cell? Starting Excel and the Menu Ribbon.

Preview 05:56

Entering data in a cell. Entering Numbers vs text. Forcing Excel to treat entry as text. Setting row and column sizes.

Preview 03:54

Creating sheets, Naming Sheets, Deleting Sheets, Rearranging Sheets, Copying Sheets, Selecting multiple sheets and Coloring Sheet Tabs. Also zooming and saving a Excel files.

Preview 09:45
+
Editing
1 Lecture 06:43

Text size, Font type, Text alignment, Wrap text, Merge, Borders and Shading.

Preview 06:43
+
Number Formatting of Cells
1 Lecture 07:24

Formatting cells as number, currency, percentage or date-time. Setting the number of decimal places. Customising date-time format.

Chapter 3.1 Number Formatting of Cells
07:24
+
Conditional Formatting
1 Lecture 08:41

Automatic formatting using the Conditional Formatting feature. This helps to visualise your data and make extremes stand out.

Chapter 4.1 Conditional Formatting
08:41
+
Moving within a Sheet & Selecting Data
3 Lectures 15:54

Moving around Contiguous data using - Ctrl + Home / End / Down / Up / Right / Left. Selecting row / Column. Deleting Rows/columns. Pressing Ctrl when dragging a cell, to increment values.

Chapter 5.1 Moving around Contiguous Data
07:40

Moving around Non-Contiguous data using - Ctrl + Home / End / Down / Up / Right / Left.

Chapter 5.2 Moving around Non-Contiguous Data
05:43

Click and drag to select Contiguous cells. Hold Shift and select Contiguous Cells. Hold Ctrl to select Non-Contiguous Cells.

Chapter 5.3 Selecting Contiguous & Non-Contiguous Data/Cells
02:31
+
Copy/Cut Paste & Move
1 Lecture 10:35

Copy&Paste, Cut&Paste, Move similar to Cut&Paste. Format Painter. Inserting cells - Insert row/column, Shift cells down or right. Paste Special - Transpose, Paste Values and Paste Formats.

Chapter 6.1 Copy/Cut Paste & Move
10:35
+
Formulas & Functions
15 Lectures 01:26:59

Relative cell references in simple formulas.  Drag-Copy or double click formula to extend formulas. Sum, Average, Min and Max functions. We also examine the impact on the relative cell reference when copying and when moving the formulas.

Chapter 7.1 Relative Formula References
09:31

Absolute cell reference. There is no impact on the absolute cell reference when the formula is moved or copied.

Chapter 7.2 Absolute Formula References
03:53

A detailed explanation of Copy&Paste, Cut&Paste, Drag-Move and Drag-Copy effect on formulas. (NB: There are two types of dragging, namely Drag-Copy and Drag-Move. The former copies&pastes cells while the latter Cut&Pastes cells.)

Chapter 7.2.1 Effect on Formulas when Copying/Cutting
09:35

'If' function explained.

Chapter 7.3 'If' Function
02:24

Introduction to 'And' and 'Or'. 'And' function in action.

Chapter 7.4 'And' Fucntion
05:09

'Or' Function in action.

Chapter 7.5 'Or' Function
02:54

Nested 'If' function.

Chapter 7.6 Nested 'If' Function
11:39

'Countif', 'CountA', 'CountBlank' and 'CountIfs' functions.

Chapter 7.7 'Count' Functions
07:48

String manipulation - 'Concatenate', 'left' , 'find', 'len' and 'right' functions.

Chapter 7.8 String Functions - Part 1
06:40

String manipulation - 'Mid' Function.

Chapter 7.9 String Functions - Part 2
05:20

Date Time Functions - 'Now', 'Days', 'YearFrac' functions. How Excel treats dates & times in calculations.

Chapter 7.10 DateTime Functions - Part 1
09:36

Date Time Function - 'NetworkDays' function.

Chapter 7.11 DateTime Functions - Part 2
02:48

The versatile 'Exact' function.

Chapter 7.12 'Exact' Function
01:57

'Rand' and 'Randbetween' random generator functions.

Chapter 7.13 Random Number Generator Functions
03:41

Referencing another worksheet and workbook in formulas.

Chapter 7.14 Referencing Sheets and Workbooks
04:04
+
VLookUp Function
3 Lectures 16:23

Introduction to the 'Vlookup' function.

Chapter 8.1 'VLookUp' Function Example 1
05:57

Returning multiple columns.

Chapter 8.2 'VLookUp' Function Example 2
05:25

Matching two lists with 'Vlookup'.

Chapter 8.3 'VLookUp' Function Example 3
05:01
+
Sorting & Filters
2 Lectures 15:13

Sorting data in ascending or descending order.

Chapter 9.1 Sorting
04:48

Filter, Filter Sort, And/Or Filter Combo, Copy & Paste and Deleting rows. Watch out for blank rows.

Chapter 9.2 Filtering
10:25
+
Graphs / Charts
7 Lectures 26:42


Clustered Column & Pie Charts.

Chapter 10.3 Clustered Column & Pie Charts
04:54

Combination Chart.

Chapter 10.4 Combination Chart
02:52

Using Categories Stacked and Clustered Column Charts.

Chapter 10.5 Categories in Stacked and Clustered Column Graphs
02:50

Clustered Stacked Chart.

Chapter 10.6 Clustered Stacked Chart
03:22

Sparklines.

Chapter 10.7 Sparklines
02:00
5 More Sections
About the Instructor
Mr Alvin Pillay
4.3 Average rating
408 Reviews
6,598 Students
2 Courses
VBA for MS Excel and MS Access Enthusiast

I am an engineer with over 20 years expierence using Microsoft Office products. I have used MSAcess and MSExcel for various data migration and data analysis projects. More recently I have been doing a lot of work with MSExcel VBA. With the knowledge I have gained, I thought it beneficial that I share this with others that are wanting to get up to speed quickly with MSExcel VBA.