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.
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.
Course Preview – Lecture 5: What can Excel 2016 do for you
What are the requirements for this course?
- You must know how to use a PC or Mac desktop computer, or a laptop.
- Parts of this course require a keyboard and mouse, such as the project work.
- In order to use the project files, you will need a copy of Microsoft Excel 2016. If you do not have a copy of Excel 2016, free one month trial versions can be found over the Internet.
What am I going to get from this course?
- 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 data
- Learn how to search and edit data effectively
- Understand data visualization and how best to use it
- Learn how to build basic charts
- Understand chart elements
- Learn how to build sparklines
Course Preview – Lecture 17: Excel general options – Part 3
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
Curriculum:
Section 1: About this Course
Lecture 1: About this course
Section 2: Course Introduction
Lecture 2: Introduction to your tutor
Lecture 3: Introduction to the course
Lecture 4: Who is the course for?
Section 3: Introduction to Microsoft Excel 2016
Lecture 5: What can Excel 2016 do for you
Section 4: Understanding Common Terms used in Excel and Spreadsheets
Lecture 6: Understanding common terms used in Excel and spreadsheets – Part 1
Lecture 7: Understanding common terms used in Excel and spreadsheets – Part 2
Lecture 8: Understanding common terms used in Excel and spreadsheets – Part 3
Lecture 9: Understanding common terms used in Excel and spreadsheets – Part 4
Lecture 10: Understanding common terms used in Excel – Part 5
Lecture 11: Understanding common terms used in Excel and spreadsheets – Part 6
Section 5: Navigating your Way Around Excel
Lecture 12: 6. Navigating your way around Excel – Part 1
Lecture 13: Navigating your way around Excel – Part 3
Lecture 14: Navigating your way around Excel – Part 4
Section 6: Excel General Options
Lecture 15: Excel general options – Part 1
Lecture 16: Excel general options – Part 2
Lecture 17: Excel general options – Part 3
Lecture 18: Excel general options – Part 4
Lecture 19: Excel general options – Part 5
Section 7: Adding, Copying and Moving Worksheets
Lecture 20: Adding, copying and moving worksheets – Part 1
Lecture 21: Adding, copying and moving worksheets – Part 2
Lecture 22: Adding, copying and moving worksheets – Part 3
Lecture 23: Adding, copying and moving worksheets – Part 4
Section 8: Working with Cells, Columns and Rows
Lecture 24: Working with cells, columns and rows – Part 1
Lecture 25: Working with cells, columns and rows – Part 2
Lecture 26: Working with cells, columns and rows – Part 3
Section 9: Excel Basic Formatting
Lecture 30: Excel basic formatting – Part 1
Lecture 31: Excel basic formatting – Part 2
Lecture 32: Excel basic formatting – Part 3
Lecture 33: 10. Excel basic formatting – Part 4
Lecture 34: Excel basic formatting – Part 5
Lecture 35: Autofill and flash fill options – Part 1
Lecture 36: Autofill and flash fill options – Part 2
Section 10: Workbook View Options
Lecture 37: Workbook view options – Part 1
Lecture 38: Workbook view options – Part 2
Section 11: Saving Workbooks
Lecture 39: Saving workbooks
Section 12: PROJECT FILE: Workbooks
Lecture 40: Project File – Workbooks
Section 13: Basic Calculations and Cell References
Lecture 41: Basic calculations and cell references – Part 1
Lecture 42: Basic calculations and cell references – Part 2
Lecture 43: Basic calculations and cell references – Part 3
Lecture 44: Basic calculations and cell references – Part 4
Lecture 45: Basic calculations and cell references – Part 5
Section 14: PROJECT FILE – Basic Calculations
Lecture 46: Project File – Basic Calculations
Section 15: Working with Comments
Lecture 47: Working with comments
Section 16: Working with Paste Special Commands
Lecture 48: Working with paste special commands – Part 1
Lecture 49: Working with paste special commands – Part 2
Section 17: Optimizing the Data (Autofilter)
Lecture 50: Optimizing the data (Autofilter) – Part 1
Lecture 51: Optimizing the data (Autofilter) – Part 2
Lecture 52: Optimizing the data (Autofilter) – Part 3
Lecture 53: Optimizing the data (Autofilter) – Part 4
Lecture 54: Optimizing the data
Lecture 55: Basic sorting methods – Part 1
Lecture 56: Basic sorting methods – Part 2
Lecture 57: Basic sorting methods – Part 3
Section 18: Using Subtotal Function to Analyze the Data
Lecture 58: Using subtotal function to analyze the data – Part 1
Lecture 59: Using subtotal function to analyze the data – Part 2
Section 16: Search and Editing the Data
Lecture 61: Search and editing the data – Part 1
Lecture 61: Search and editing the data – Part 2
Lecture 62: Search and editing the data – Part 3
Lecture 63: Search and editing the data – Part 4
Section 19: Data Visualization – Basic Illustrations
Lecture 64 Data visualization – basic illustrations
Section 20: PROJECT FILE: Data Visualization
Lecture 65: Project File – Data visualization
Section 21: Building Basic Charts
Lecture 66: Building basic charts
Section 22: Manipulate with Chart Elements
Lecture 67: Manipulate with chart elements – Part 1
Lecture 68: Manipulate with chart elements – Part 2
Lecture 69: Manipulate with chart elements – Part 3
Section 23: Building Sparklines
Lecture 70: Building sparklines
Lecture 71: Page layout options – Part 1
Lecture 72: Page layout options – Part 2
Lecture 73: Page layout options – Part 3
Lecture 74: Page layout options – Part 4
Lecture 75: Page layout options – Part 5
Section 24: PROJECT FILE: Page Layout Options
Lecture 76: Project File – Page layout options
Section 25: Conclusion
Lecture 77: Conclusion
