Skip to content
Home
About Dawn
Excel Calculators
BUS 233/503 Video Matrix
Doc’s Blog
Menu
Home
About Dawn
Excel Calculators
BUS 233/503 Video Matrix
Doc’s Blog
Basic Excel links
Excel 2016
A. Getting Started
What you’ll learn in this training
Excel spreadsheet structure overview
Creating and saving an Excel file
Interface overview
B. Work with Data and Datasets
Enter data into a cell
Create a dataset
Auto-fill data
Create simple calculations
Referencing cells
Auto-fill cell references
Format cell data
Cut and paste data
C. Create Formulas
Create multiple calculation formulas
Use AutoSum
Create an averaging formula
Retrieve the min and max value
Retrieve the number count
Create a correlation
Access and search for built in formulas
D. Manage Data and Datasets
Trace precedents
Trace dependents
Sort data
Changing text to columns
Setup data validation
Delete and insert columns and rows
E. Format Your Table
Merge cells
Label data
Change cell background color
Change table format
Freeze panes
Create conditional formatting
Insert images and objects
F. Work with Sheets
Name and add sheets
Reference cells in other sheets
G. Work with Charts
Insert a chart
Edit a chart
Change the chart type
Change chart data
H. Share and Secure Data
Protect a sheet
Hide and unhide columns and rows
Add comments to a cell
Save to OneDrive®
Invite people to share
I. Import and Export Data
Import data from text
Import data from Access®
Import data from XML file
Export Excel as CSV
Export spreadsheets to PDF
Export data as tab delimited text
Printing spreadsheets
Leave a Reply
Cancel reply
This site uses Akismet to reduce spam.
Learn how your comment data is processed
.
Dr. Dawn Wright
Subscribe to My YouTube Channel