Excel 101: Introduction to Spreadsheets - Part 1

Authored by David Ringstrom
About this Course
Topics covered include: Using a custom number format to hide zero amounts within a specific area of a spreadsheet; Becoming familiar with Excel's grid of rows and columns; Jump-starting data visualization with the Quick Analysis feature; Minimizing effort in Excel by only selecting cells when necessary;Gaining control of long lists of data by filtering instead of sorting; Exploring the Recommended Charts feature in Excel 2013 and later; Simplifying repetitive tasks by creating your own keyboard shortcuts; Mastering Excel's order of operations for mathematical formulas; Understanding how to enter dates in an Excel spreadsheet; Learning the nuances of copying formulas within Excel spreadsheets; Learning about the different types of files you can create in Excel; Using free, prebuilt templates in Excel to get a jump start on your spreadsheet projects. Upon completing this course, you should be able to: Identify how to skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts; Define the structural basics of Excel worksheets and workbooks; Recognize and apply basic data-analysis techniques; Identify how to save different Excel formatted workbooks and their requirements; Recognize acceptable Excel text entries; Identify how to use the Freeze Panes feature; Describe how to display a list of worksheets; Recognize which command is used to save a document as a PDF file; Identify Excel keyboard shortcuts; Differentiate Excel formulas and how they are calculated; Recognize ribbon tabs and how they function.
$ 56.97
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Basic
CPE Credits
2.0
Prerequisites
None
Last Updated
07/31/2018
14118