Microsoft Excel 2016 Beginner Level Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn how to use Microsoft Excel 2016 from a beginner level and up with confidenceDescription
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.
Requirements
- Requirements
- 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.
Knowledge
- 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
Data Analyst's Toolbox: Excel to MySQL
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights Gain a competitive advantage in the job market....
Best Microsoft Excel Hindi- Attractive Dashboard with Charts
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Excel Shortcuts A-Z & Functions हिंदी में। Microsoft Excel 2010, 2013, 2016, Excel 2019 और Office Our Microsoft Excel course has divided into 3 Easy Levels....
Microsoft Excel Power Pivot: Power Pivot , DAX & Pivot Table
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Power Excel with Power Pivot, DAX Formulas and Pivot Tables in Excel Power Pivot 2010-2019 & Power Pivot Office 365. ----------------------------------------...
Microsoft Excel: Excel - Beginner to Advanced (Full Excel)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Became in a master of Excel. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365 (Pivot table, formulas, data) LAST UPDATE - 06/17/2020...
