Excel Test & Excel Tutorial Index Page
12 Free Excel 2016 Tutorials & matching Tests
Microsoft Excel 2016 Training
Excel Tutorials with corresponding Tests
10 Question Multiple Choice Quizzes with Answer Explanations
GO TO EXCEL 2010 (43 TUTORIALS and 45 TESTS)
ArticlesTop 10 Microsoft Excel Templates for highly effective people
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.
* Free Excel 2016 Training
1. Learn Excel Basics - Excel 2016
* 6 Online Tutorials & 6 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
* Excel Lookup - 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 different parts of the Excel Screen Tutorial - Excel 2016 Tutorial
The different parts of the Excel Screen Test - Excel 2016 Test
* How does the Excel Ribbon work?
* QAT - Quick Access Toolbar options
* Rows and columns in a worksheet
* Worksheet tabs in a workbook
* The Name Box and Formula Bar
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 Excel Workbooks & Excel Sheets Tutorial
Navigating Excel Workbooks & Excel Sheets Test
* Moving around rows and columns
* Selecting cell ranges
* Moving between worksheets
* Go to specific Excel cells
* Excel Find Function find numbers or words
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 Tutorial
The File Tab and Backstage View Test
* The areas of the Backstage View
* Open existing workbooks
* Create new workbooks
* Save workbooks (and recover unsaved ones)
* Create PDF copies of worksheets to share
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!
Making Excel View Types Work for You Tutorial
Making Excel View Types Work for You Test
* Excel Normal View
* Excel Page Break Preview
* Excel Page Layout View
* Excel Custom Views
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.
Mastering the Ribbon & QAT (Quick Access Toolbar) Tutorial
Mastering the Ribbon & QAT (Quick Access Toolbar) Test
* What exactly is the Excel 2016 Ribbon?
* Showing and hiding the Ribbon
* How to find functions on the Ribbon
* Contextual tabs that disappear
* The shortcut menu or QAT - Quick Access Toolbar
* Adding buttons to the QAT
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 and Zoom Options in Excel 2016 Tutorial
Window and Zoom Options in Excel 2016 Test
* Get a better look by zooming in and out of a worksheet
* View different parts of the same workbook at the same time
* How to find functions on the Ribbon
* Freeze rows or columns so that they remain visible when you scroll
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 in Excel 2016
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 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.
* EXCEL RESOURCES AND ARTICLESExcel Training - Excel Training & Excel MOS Exams Explained
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!
Top 10 Microsoft Excel Templates for highly effective people