Mastering MS Excel (Udemy.com)
Master MS Excel 2010-2016 in 5hrs of easy to follow videos
Created by: Alvin Pillay
Produced in 2017
What you will learn
- Use MS Excel to advance their career and improve their job prospects.
- Use MS Excel to achieve outputs more quickly, effiecently and intelligently.
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course 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. Noprior knowledge of MS Excel is required. The course will take you from thebeginner level to the advanced level.
The course focuses on those aspects that are important ineveryday working life and helps you get the most out of MS Excel. Intermediateusers will also benefit from this course as it covers the in-depth topics ofComplex Charts, PivotTables, PivotCharts and Interactive Dashboards.
The course is aimed at job seekers trying to gain MS ExcelSkills for todays job market. It will also help existing workers, who use MSExcel, to fascinate and astound their colleagues and managers with their newlygained skills.
Course Breakdown:
Chapter 1 covers important definitions of the terms: spreadsheet, workbook, worksheet and cell. It also covers how to start MSExcel, 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 todazzle people. We discuss conditional formatting.
Chapter 5 looks at how you can move easily andquickly around a worksheet containing data. You will be impressed.
Chapter 6 covers copying, cutting, pasting andmoving data
Chapter 7 is the longest chapter and looks at themost powerful feature of excel that sets it apart from other applications. Youwill learn about formulas and cover functions such as If, Nested Ifs, Countfunctions, String functions, DateTime functions, Random number generatorfunctions and more.
Chapter 8 delves into the powerful VLookUpfunction. You'll wonder how you ever managed without it.
Chapter 9 slows down to a more gentle pace, givingyour tired brain a rest, by covering sorting and filtering data.
Chapter 10 will dazzle you with creating Graphs, orCharts, as it is called in Excel. We'll start with simple graphs and end withsome complex ones that very few people know how to create.
Chapter 11 teaches you about a tool that makes dataanalysis easy-pezee. It's the awesome Pivot table.
Chapter 12 takes this one step further with the powerof pivot charts and slicers. We'll also show you how to create an INTERACTIVEdashboard.
Chapter 13 shows you how to make your life easier byformatting your data as tables.
Chapter 14 covers Macros. This makes repetitive taskseasy-peeze.
Chapter 15 covers the remaining exciting concepts of:Removing duplicate data rows, defining named ranges, creating a pick list usingdata validation, protecting your sheet and workbook, inserting fancy graphics.And finally creating a Contents sheet.
Be rest assured that this course does not cover VBAprogramming. All that you learn is done without any programming.
Best of luck in your future endeavours.
Who this course is for:
The course focuses on those aspects that are important ineveryday working life and helps you get the most out of MS Excel. Intermediateusers will also benefit from this course as it covers the in-depth topics ofComplex Charts, PivotTables, PivotCharts and Interactive Dashboards.
The course is aimed at job seekers trying to gain MS ExcelSkills for todays job market. It will also help existing workers, who use MSExcel, to fascinate and astound their colleagues and managers with their newlygained skills.
Course Breakdown:
Chapter 1 covers important definitions of the terms: spreadsheet, workbook, worksheet and cell. It also covers how to start MSExcel, 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 todazzle people. We discuss conditional formatting.
Chapter 5 looks at how you can move easily andquickly around a worksheet containing data. You will be impressed.
Chapter 6 covers copying, cutting, pasting andmoving data
Chapter 7 is the longest chapter and looks at themost powerful feature of excel that sets it apart from other applications. Youwill learn about formulas and cover functions such as If, Nested Ifs, Countfunctions, String functions, DateTime functions, Random number generatorfunctions and more.
Chapter 8 delves into the powerful VLookUpfunction. You'll wonder how you ever managed without it.
Chapter 9 slows down to a more gentle pace, givingyour tired brain a rest, by covering sorting and filtering data.
Chapter 10 will dazzle you with creating Graphs, orCharts, as it is called in Excel. We'll start with simple graphs and end withsome complex ones that very few people know how to create.
Chapter 11 teaches you about a tool that makes dataanalysis easy-pezee. It's the awesome Pivot table.
Chapter 12 takes this one step further with the powerof pivot charts and slicers. We'll also show you how to create an INTERACTIVEdashboard.
Chapter 13 shows you how to make your life easier byformatting your data as tables.
Chapter 14 covers Macros. This makes repetitive taskseasy-peeze.
Chapter 15 covers the remaining exciting concepts of:Removing duplicate data rows, defining named ranges, creating a pick list usingdata validation, protecting your sheet and workbook, inserting fancy graphics.And finally creating a Contents sheet.
Be rest assured that this course does not cover VBAprogramming. All that you learn is done without any programming.
Best of luck in your future endeavours.
Who this course is for:
- Anyone wanting to learn MS Excel quickly and easily.
Instructor Details
- 4.6 Rating
97 Reviews
Alvin Pillay
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.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
Provider: Chandoo.org
Time: 1h 30m
Free
More courses by Alvin Pillay
Reviews
- Video Duration:
5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2017 - Language:
English, English [Auto-generated] - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
