Microsoft Excel 2016 for Beginners

Giorgi Kavtaradze, Microsoft Excel Master Tutor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
74 Videos (3h 20m)
    • Trailer

      1:17
    • Introduction to your Tutor

      0:43
    • Introduction to the Class

      0:29
    • Who This Class is For

      0:56
    • What can Excel 2016 Do For You

      1:49
    • Understanding Common Terms - Title Bar

      0:54
    • Understanding Common Terms - Ribbon & Tabs

      0:56
    • Understanding Common Terms - Ribbon & Tabs

      1:08
    • Understanding Common Terms - Range & Object

      0:34
    • Understanding Common Terms - Formula Bar, Name Box, Addresses

      0:44
    • Understanding Common Terms - Sheet Tab

      0:20
    • Navigating Your Way Around Excel

      3:39
    • Navigating Your Way Around Excel - Part 2

      1:42
    • Navigating Your Way Around Excel - Part 3

      1:20
    • Navigating Your Way Around Excel - Part 4

      2:17
    • Excel General Options

      2:47
    • Excel General Options Part 2

      0:57
    • Excel General Options Part 3

      2:09
    • Excel General Options Part 4

      1:41
    • Excel General Options Part 5

      1:20
    • Adding, Copying, and Moving Worksheets

      1:21
    • Adding, Copying, and Moving Worksheets - Part 2

      2:29
    • Adding, Copying, and Moving Worksheets - Part 3

      2:27
    • Adding, Copying, and Moving Worksheets - Part 4

      1:55
    • Working with Cells, Columns and Rows

      1:08
    • Working with Cells, Columns and Rows - Part 2

      2:07
    • Working with Cells, Columns and Rows - Part 3

      2:13
    • Working with Cells, Columns and Rows - Part 4

      1:00
    • Working with Cells, Columns and Rows - Part 5

      1:51
    • Working with Cells, Columns and Rows - Part 6

      1:34
    • Excel Basic Formatting

      4:53
    • Excel Basic Formatting - Part 2

      4:19
    • Excel Basic Formatting - Part 3

      2:05
    • Excel Basic Formatting - Part 4

      3:02
    • Excel Basic Formatting - Part 5

      2:34
    • Autofill and Flash Fill Options

      2:27
    • Autofill and Flash Fill Options - Part 2

      6:14
    • Workbook View Options

      5:51
    • Workbook View Options - Part 2

      2:41
    • Saving Workbooks

      4:47
    • Basic Calculations and Cell References

      4:44
    • Basic Calculations and Cell References - Part 2

      4:17
    • Basic Calculations and Cell References - Part 3

      3:04
    • Basic Calculations and Cell References - Part 4

      2:45
    • Basic Calculations and Cell References - Part 5

      1:30
    • Basic Calculations and Cell References - Part 6

      2:49
    • Working with Comments

      3:45
    • Working with Paste Special Commands

      5:15
    • Working with Paste Special Commands - Part 2

      5:42
    • Optimizing the Data (Autofilter)

      3:54
    • Optimizing the Data (Autofilter) - Part 2

      2:50
    • Optimizing the Data (Autofilter) - Part 3

      5:29
    • Optimizing the Data (Autofilter) - Part 4

      2:18
    • Basic Sorting Methods

      2:47
    • Basic Sorting Methods - Part 2

      3:01
    • Basic Sorting Methods - Part 3

      3:46
    • Using Subtotal Function to Analyze the Data

      3:21
    • Using Subtotal Function to Analyze the Data - Part 2

      4:29
    • Search and Editing the Data

      3:51
    • Search and Editing the Data - Part 2

      3:12
    • Search and Editing the Data - Part 3

      2:08
    • Search and Editing the Data - Part 4

      2:55
    • Data Visualization - Basic Illustrations

      4:25
    • Building Basic Charts

      3:41
    • Manipulate with Chart Elements

      3:15
    • Manipulate with Chart Elements - Part 2

      5:35
    • Manipulate with Chart Elements - Part 3

      0:22
    • Building Sparklines

      4:50
    • Page Layout Options

      4:24
    • Page Layout Options - Part 2

      1:10
    • Page Layout Options - Part 3

      1:42
    • Page Layout Options - Part 4

      2:59
    • Page Layout Options - Part 5

      3:26
    • Conclusion

      1:29

About This Class

This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those just wanting to refresh or upgrade their current Excel skills.

At the beginning, this course covers simple topics such as:

  • What can Excel 2016 do for you?
  • Understanding common terms used in Excel and the world of spreadsheets
  • Finding your way around Excel
  • Saving and printing your work
  • Understanding formulas and why people create them; and
  • What’s new in Excel 2016

 

The course then progresses onto more complex subjects such as performing basic calculations and using cell references, understanding how to use Autofill and Flash Fill options, analyzing and editing data, understanding data visualization, working with paste special commands, getting to grips with the view options, and building sparklines, plus much more. The course is presented in logical order starting from the bare basics.

Animations are used during the introductory stages to bring the course to life and help the learner to better absorb information. Lessons are taught with the add of video capture software. You can see exactly what parts of Excel 2016 the tutor is referring to when delivering the lesson, whether it be a spreadsheet or save menu.

This course also includes quizzes and project files to practice your skills and test your knowledge.

Who is the target audience?

  • This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those that are just wanting to refresh or upgrade their current Excel skills.
  • This course can also be taken by individuals who consider themselves as Excel novices

What Will I Learn?

  • Understand common terms used in Excel and spreadsheets
  • Learn how to add, copy and move worksheets
  • Learn how to work with cells, columns and rows
  • Learn how to conduct basic formatting
  • Understand Autofill and Flash Fill options and how to use them
  • Understand workbook view options and how to use them to your advantage
  • Learn how to save workbooks the correct way
  • Perform basic calculations and use cell references
  • Learn how to work with comments
  • Learn how to optimize data using the Autofilter feature
  • Learn how to conduct basic sorting methods
  • Learn how to use the subtotal function to analyze dataLearn how to search and edit data effectively
  • Understand data visualization and how best to use it
  • Learn how to build basic chartsUnderstand chart elements
  • Learn how to build sparklines

12

Students

--

Projects

0

Reviews (0)

Giorgi Kavtaradze

Microsoft Excel Master Tutor

So a bit about me...

I'm a certified Microsoft Office Specialist in Excel.

I have 8 years of working experience with Microsoft Excel and Visual Basic for Applications. For those of you who don't know, Visual Basic for Applications - or VBA for short - is a computer programming language developed by Microsoft which allows the automation of processes and calculations.

Over the years I have overseen many projects in budgeting and financial modelling in a variety of industrie...

See full profile