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.
