Excel 2016
Quick Start Tutorials
What is Excel?
Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or, easily spot trends and patterns with data bars, color coding, and icons.
Create a Document
On the File tab, click New.
In the Search for online templates box, enter the type of document you want to create and press ENTER.
Tip: To start from scratch, select Blank document. Or, for practice using Word features, try a learning guide like Welcome to Word, Insert your first table of contents, and more.
Analyze and Format in Excel
Automatically Fill a Column with Flash Fill
For example, automatically fill a First Name column from a Full Name column.
In the cell under First Name, type Molly and press Enter.
In the next cell, type the first few letters of Garret.
When the list of suggested values appears, press Return.
Select Flash Fill Options for more options.
Quickly Calculate with AutoSum
Select the cell below the numbers you want to add.
Select Home > AutoSum .
Press Enter.
Tip For more calculations, select the down arrow next to AutoSum, and select a calculation. You can also select a range of numbers to see common calculations in the status bar.
Create a Chart
Use the Quick Analysis tool to pick the right chart for your data.
Select the data you want to show in a chart.
Select the Quick Analysis button to the bottom-right of the selected cells.
Select Charts, hover over the options and pick the chart you want.
Format and Collaborate in Excel
Use Conditional Formatting
Use Quick Analysis to highlight important data or show data trends.
Select the data to conditionally format.
Select the Quick Analysis button to the bottom-right of the selected cells.
Select Formatting, hover over the options and pick the one you want.
Freeze the Top Row of Headings
Freeze the top row of column headings so that only the data scrolls.
Press Enter or Esc to make sure you're done editing a cell.
Select View > Freeze Top Row.
Share Your Workbook with Others
- Select Share on the ribbon. Or, select File > Share.
- Select who you want to share with from the drop-down, or enter a name or email address.
- Add a message (optional) and select Send.
Note: If your file is not already saved to OneDrive, you'll be prompted to upload your file to OneDrive to share it.
Rows and Columns Video Tutorials & Links
Charts Video Tutorials & Links
- Create a chart from start to finish
- Add or remove titles in a chart
- Format elements of a chart
- Show or hide a chart legend or data table
- Add or remove a secondary axis in a chart in Excel
- Add a trend or moving average line to a chart
- Analyze your data instantly
- Update the data in an existing chart
- Use sparklines to show data trends
Share & Co-Author Video Tutorials & Links
Technology Inventory Specialist / Administrative Technology Trainer
Email: vanessa.arredondo@gccisd.net
Website: www.gccisd.net/tms
Location: 5950 North Main Street, Baytown, TX, USA
Phone: (281) 420-4633