facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Test & Excel Tutorial Index Page – Excel 2016 Tutorials & Tests – Microsoft Excel Training 2016

Excel Test & Excel Tutorial Index Page
15 Excel 2016 Tutorials & 17 Excel Tests
Microsoft Excel Training
2016


Excel Tutorials with corresponding Tests
10 Question Multiple Choice Quizzes with Answer Explanations


GO TO EXCEL 2010 (43 TUTORIALS and 45 TESTS)


Excel 2016 Articles

The Best Excel Templates – Excel 2016 – Top 10 Excel Templates for Business & Home
Packaged as part of the Microsoft Office 2016 suite as well as Office 365, Excel 2016 is a powerful productivity tool with some mind-blowing features.  MS Excel spreadsheets are not only great for financial workbooks and budgets, it can also be used for creating calendars and schedules, fitness tracker, invoices, to do lists, weight loss tracker, vehicle service logs, address lists and much more.
* Excel Mileage Log Book Template & Vehicle Log Book Template
* Excel Grocery List Template
* Fitness Tracker Excel Template
* Weight Loss Tracker Excel Template
* Excel Schedule Template – Excel Daily Schedule Template
* To Do List Excel Template
* Contact List Excel Template
* Excel Calendar Template – Personalized Calendar
* Project Plan Template Excel – Gantt Project Planner
* Excel Budget Template – Personal Budget Template



1. Learn Excel Basics – How to use Excel 2016

* Free Excel 2016 Training
* 7 Online Tutorials & 7 Tests with Answer Explanations


What’s New in Excel 2016? Excel 2016 Tutorial
What’s New in Excel 2016? Excel Test

* Tell Me Search Box in Excel
* People Graph Add-In Excel
* Map Chart in Excel
* Quick Analysis Tool Excel 2016
* Smart Lookup

Excel 2016 is the latest version of Microsoft’s well-known spreadsheet program. It is packed full with improvements to existing functions and a host of new useful and exciting features. This tutorial will introduce you to a couple of the highlights of Excel 2016.

The Parts of the Excel Screen Tutorial – Excel 2016 Tutorial
The Parts of the Excel Screen Test – Excel 2016 Test

* The Ribbon in Excel 2016 – How does it work?
* Quick Access Toolbar in Excel – QAT options 2016
* Rows and columns in Excel spreadsheet / worksheet 2016
* Worksheet tabs in Excel workbooks
* The Name Box in Excel and Formula Bar in Excel 2016

If you are new to Excel, it is highly recommended that you familiarize yourself with the layout and terminology for all the parts of the Excel 2016 screen.  The Excel screen comprises elements such as the Ribbon, Tabs, Quick Access Toolbar, Name Box, Formula Bar, Column and Row Labels, cells and Worksheet Tabs.





Navigating the Excel Workbook, Excel Spreadsheet & Excel Sheets Tutorial

Navigating the Excel Workbook, Excel Spreadsheet & Excel Sheets Test

* Moving around rows and columns in Excel 2016
* Selecting cell ranges in Excel 2016
* Moving between Excel worksheets
* Go to specific cells in Excel 2016
* Find Function Excel 2016 – find text in Excel – find numbers in Excel

Navigating around an Excel worksheet is a skill worth developing. Workbooks can contain data that runs over multiple rows, columns and worksheets and finding what you are looking for can be daunting. Knowing how to select cell ranges, quickly move to the beginning or end of a section of data or using Go To and Find to navigate to specific data sets, makes this easy!


The File Tab and Backstage View Excel Tutorial
The File Tab and Backstage View Excel Test

* The areas of the Backstage View – Excel 2016
* How to Open Excel Workbooks in Excel 2016
* Create New Workbooks
* Save Workbooks and Recover Unsaved Workbooks
* Excel to PDF – Create PDF copies of Worksheets to Share in Excel 2016

The File button in Excel provides access to workbook saving, retrieving, information, security settings and a multitude of other options, which are not readily available in the normal workbook view. Aptly named the Backstage View, this is where you will find all the tools you need to create and manage Excel workbooks like an expert!


Excel Views Tutorial
Excel Views Test

* Normal View Excel 2016
* Page Break Preview Excel 2016
* Page Layout View Excel 2016
* Custom Views
Excel 2016
Excel 2016 comes packed with three built-in view types, Normal, Page Break Preview and Page Layout, as well as a set of customizable view options. Using view types effectively is an essential part of worksheet management and layout design.



Excel Ribbon & Quick Access Toolbar Tutorial
Excel Ribbon & Quick Access Toolbar Test

* What is the Ribbon in Excel 2016?
* Show Ribbon in Excel – Hide Ribbon in Excel 2016
* How to find Excel Functions on the Ribbon in Excel 2016
* Contextual tabs that disappear
* Quick Access Toolbar Excel 2016 – The shortcut menu or QAT
* Adding buttons to the Quick Access Toolbar Excel 2016

The Ribbon and Quick Access toolbars in Excel are the control centers for functions, options and settings needed to create and edit worksheets. Both these toolbars work in very specific ways and understanding how they are organized may increase your productivity substantially.


Window Options and Zoom in Excel Tutorial
Window Options and Zoom in Excel Test

* Zoom in Excel 2016 – Zooming in and out of a worksheet
* Zoom in Excel Shortcut
* View different parts of the same Excel Workbook at the same time
* Compare two workbooks in Excel
* Freeze columns and rows in Excel 2016

Manipulate Excel windows to aid viewing, comparing and editing different sections of a workbook or sheet at the same time. The Freeze Pane, New Window, Synchronous Scrolling and Zoom options are a few of the window options that will make mastering Excel a breeze!




2. Data Entry and Formatting Text in Excel 2016

* Excel 2016 Training
* 5 Online Tutorials & 5 Tests with Answer Explanations

Add Text in Excel – Add Numbers in Excel – Excel Spreadsheet & Worksheet Tutorial
Add Text in Excel – Add Numbers in Excel – Excel Spreadsheet & Worksheet Test
* Add Text in Excel – Add Numbers in Excel 2016
* How to align Excel cell content
* Resizing rows and columns to fit cell contents in Excel 2016
* Fitting contents to column width in Excel 2016
* How to add paragraphs to cells
* How to edit and delete cell contents

Adding text or numerical values to a spreadsheet or worksheet requires the ability to insert, edit, fit and delete cell contents. Master the Excel grid of cells, rows and columns by adding headings, paragraphs, row or column headings and capturing values.

 

Formatting Text in Excel – Formatting Numbers Excel Tutorial
Formatting Text in Excel – Formatting Numbers Excel Test
* Selecting a font type, color and size in Excel 2016
* Using bold, italic and underline
* Selecting and applying built-in cell styles in Excel
* Using the format painter Excel 2016
* Excel clear formatting from cells

Formatting functions in Excel provide options that will make the data in your worksheet easier to read and understand. Use different fonts, font colors and sizes, bold, italic, underline and built in styles to create visually appealing worksheets.




Aligning Cell Content in Excel 2016 Tutorial
Aligning Cell Content in Excel 2016 Test
* Horizontal, Vertical and Diagonal Cell Alignment in Excel 2016
* Horizontal Cell Alignment
* Vertical Cell Alignment
* Diagonal Cell Alignment
* Wrap Text in a Cell
* Merge and Center in Excel – Cell Content
* Indent Cell Content in Excel 2016

Use the Alignment Group tools in Excel to merge headings across columns and rows, change the position of text within a cell and set horizontal and vertical alignment of data to improve readability.


Customizing Number & Text Formats in Excel 2016 Tutorial
Customizing Number & Text Formats in Excel 2016 Test
* Currency Format in Excel – Accounting Formats in Excel 2016
* Decimal Places & Percentage Format in Excel – How to add percentage in Excel
* Date Format in Excel – Time Format in Excel 2016
* How to use Custom Formats Excel 2016

Excel treats all data entered in the form of text or numbers in a specific way depending on whether it is a numerical value, percentage, text, date, time, currency, etc. To ensure data is read correctly by Excel and users, format cells, rows and columns with specific value formats to ensure the data displays correctly and behaves as expected.


How to Add Excel Borders & Shading to Cells – Formatting Excel 2016 Spreadsheets Tutorial
How to Add Excel Borders & Shading to Cells – Formatting Excel 2016 Spreadsheets Test

* Excel Cells – How to add borders in Excel 2016
* Deleting Borders from cells in Excel
* Applying Colored Shading to Cells
* Deleting Colored Shading from Cells in Excel 2016
* Applying Built-In Formats – Save your new styles in Excel 2016

Spreadsheets and worksheets are used to display data in row and column format, usually with headings and/or rows containing total values of calculations. To make data easy to read, borders and color shading is used.


3. Excel Formulas and Excel Functions in Excel 2016
* Free Excel 2016 Training
* 2 Tests with Answer Explanations

VLOOKUP in Excel 2016 Test
INDEX-MATCH & VLOOKUP in Excel

* Excel VLOOKUP formula
* Excel INDEX-MATCH formula

Microsoft Excel worksheets can contain a lot of data and knowing which tools to use to find specific information is essential. Looking up data in a worksheet is done using the VLOOKUP and Index-Match functions. Test your skills with the free Excel Quiz.



Excel HLOOKUP, VLOOKUP & INDEX-MATCH Test

* HLOOKUP in Excel
* Excel VLOOKUP formula
* Excel INDEX-MATCH formula

Microsoft Excel 2016 and Office 365 make using data functions to look up information in a worksheet easier than ever before. Searching for specific information can be done using the VLOOKUP function and the Index-Match combination. Build powerful formulas in your worksheet using these functions.


How to use VLOOKUP in Excel 2016 Test
* VLOOKUP in Excel
* INDEX-MATCH Excel
* HLOOKUP in Excel

When building formulas and functions in Excel you may need part of the formula to search for specific data in a worksheet to conditionally apply the formula to. To find specific data in a worksheet you can use a VLOOKUP formula or the Index-Match function. You can find these functions in Microsoft Excel 2016.



4. The Data Analysis Toolpak
* Free Excel 2016 Training
* 1 Online Tutorial & 1 Test with Answer Explanations

t-Test in Excel, F-test and z-Test Tutorial with 4 Videos
t-Test in Excel, F-test and z-Test Quiz
* How to Activate the Analysis ToolPak Add-In
* F-Test in Excel
* t-Test in Excel
* Using the T.TEST Formula in Excel
* z-Test in Excel

How to perform F-tests, t-Tests, and z-Tests using the Analysis ToolPak Excel 2016. The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. It adds functionality to Excel vital to specialized data analysis tasks.



* EXCEL RESOURCES AND ARTICLES

Excel Training – Excel Training & Excel MOS Exams Explained

The Best Excel Templates – Excel 2016 – Top 10 Excel Templates for Business & Home
Packaged as part of the Microsoft Office 2016 suite as well as Office 365, Excel 2016 is a powerful productivity tool with some mind-blowing features.  MS Excel spreadsheets are not only great for financial workbooks and budgets, it can also be used for creating calendars and schedules, fitness tracker, invoices, to do lists, weight loss tracker, vehicle service logs, address lists and much more.

What is Excel? How to use Excel – What is Microsoft Excel? What can Microsoft Excel be used for? What are the benefits of using Microsoft Excel to perform the above functions?

What MS Excel Training is best for you? Quiz.– Being aware of what kind of Excel user you are, what you wish to use the program for, how often you use it and at what level you currently are (for example Novice, Intermediate or Expert), could act as a guide for the type of training you need to pursue.

What Version of Excel are you using? Find out how to find out!




* More from TestsTestsTests.com