Modern Learning Plus

I. Using Microsoft Excel

Microsoft Excel enables users to identify trends and organize and sort data into meaningful categories. Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.

Table of Contents

I. Using Microsoft Excel
1.1. Starting Ms. Excel
1.2. Ms. Excel Screen
1.3 Command Overview for each Title
1.4 Save and Save as

1.1. Starting Ms. Excel

Locate Excel on your computer.
Click Microsoft Excel to launch the Excel application where you are presented with workbook options to help get you started.
Click the first option; “Blank Workbook”.

1.2. Ms. Excel Screen

1.3 Command Overview for each Title

Title	Description of Commands
File	Also known as the Backstage view of the Excel workbook. Contains all commands for opening, closing, saving, and creating new Excel workbooks. Includes print commands, document properties, e-mailing options, and help features. The default settings and options are also found in this tab.
Home	Contains the most frequently used Excel commands. Formatting commands are found in this tab along with commands for cutting, copying, pasting, and for inserting and deleting rows and columns.
Insert	Used to insert objects such as charts, pictures, shapes, PivotTables, Internet links, symbols, or text boxes.
Page Layout	Contains commands used to prepare a worksheet for printing. Also includes commands used to show and print the gridlines on a worksheet.
Formulas	Includes commands for adding mathematical functions to a worksheet. Also contains tools for auditing mathematical formulas.
Data	Used when working with external data sources such as Microsoft® Access®, text files, or the Internet. Also contains sorting commands and access to scenario tools.
Review	Includes Spelling and Track Changes features. Also contains protection features to password protect worksheets or workbooks.
View	Used to adjust the visual appearance of a workbook. Common commands include the Zoom and Page Layout view.
Help	This tab provides access to help and support features such as contacting Microsoft support, sending feedback, suggesting a new feature, and community discussion groups. This tab is not available with Excel for Mac.
Draw	Provides drawing options for using a digital pen, mouse or finger depending on the type of device (laptop with touch screen, tablet, computer, etc). This tab is not visible by default. See below on how to customize the Ribbon to add or remove tabs.
Developer	Provides access to some advanced features such as macros, form controls, and XML commands. This tab is not visible by default. See below on how to customize the Ribbon to add or remove tabs.