Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 25 Minute(s)
Language
English
Taught by
Hudson Courses
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Learn how to use Microsoft Excel 2016 from a beginner level and up with confidence
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.
Course Content
- 51 section(s)
- 77 lecture(s)
- Section 1 About this Course
- Section 2 Course Introduction
- Section 3 Introduction to Microsoft Excel 2016
- Section 4 Understanding Common Terms used in Excel and Spreadsheets
- Section 5 Navigating your Way Around Excel
- Section 6 Excel General Options
- Section 7 QUIZ: Excel General Options
- Section 8 Adding, Copying and Moving Worksheets
- Section 9 QUIZ: Adding, Copying and Moving Worksheets
- Section 10 Working with Cells, Columns and Rows
- Section 11 QUIZ: Working with Cells, Columns and Rows
- Section 12 Excel Basic Formatting
- Section 13 QUIZ: Excel Basic Formatting
- Section 14 QUIZ - Basic Formulas and Functions
- Section 15 Autofill and Flash Fill Options
- Section 16 QUIZ: Autofill and Flash Fill Options
- Section 17 Workbook View Options
- Section 18 QUIZ: Workbook View Options
- Section 19 Saving Workbooks
- Section 20 QUIZ: Saving Workbooks
- Section 21 PROJECT FILE: Workbooks
- Section 22 Basic Calculations and Cell References
- Section 23 QUIZ - Basic Calculations
- Section 24 QUIZ - Cell References
- Section 25 PROJECT FILE - Basic Calculations
- Section 26 Working with Comments
- Section 27 QUIZ - Working with Comments
- Section 28 Working with Paste Special Commands
- Section 29 QUIZ - Working with Paste Special Commands
- Section 30 Optimizing the Data (Autofilter)
- Section 31 QUIZ - Optimizing the Data
- Section 32 PROJECT FILE - Optimizing the Data
- Section 33 Basic Sorting Methods
- Section 34 QUIZ - Basic Sorting Methods
- Section 35 Using Subtotal Function to Analyze the Data
- Section 36 QUIZ - Using Subtotal Function to Analyze the Data
- Section 37 Search and Editing the Data
- Section 38 QUIZ - Search and Editing the Data
- Section 39 Data Visualization - Basic Illustrations
- Section 40 QUIZ: Data Visualization - Basic Illustrations
- Section 41 PROJECT FILE: Data Visualization
- Section 42 Building Basic Charts
- Section 43 QUIZ: Building Basic Charts
- Section 44 Manipulate with Chart Elements
- Section 45 QUIZ: Manipulate with Chart Elements
- Section 46 Building Sparklines
- Section 47 QUIZ: Building Sparklines
- Section 48 Page Layout Options
- Section 49 QUIZ: Page Layout Options
- Section 50 PROJECT FILE: Page Layout Options
- Section 51 Conclusion
What You’ll 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 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
Skills covered in this course
Reviews
-
KKate Sinha
Great beginners course that covers a range of excel skills. Recommended for anyone looking to learn basics or as a refresher course.
-
TTrista Hayton
The only thing that was really bad is that the sections are out of order. If you are going to give a quiz make sure the content of the quiz is taught first. Same with application of knowledge. The applications sections had you doing things you weren't taught yet because it was not in the correct order. The instructor was clear and showed multiple ways to do things which is nice!
-
MMohannad AlFadhal
The course is amazing, and I liked it a lot because of the vast amount of exercises, and the projects at the end of the sections. The instructor is direct to the point and doesn't waste time, which provided me with a lot of information even though the lectures are small.
-
RRaj K Patel
The course is great for the beginners as well as the intermediate highly recommended for graduates
