Learn how to create and develop Excel worksheets and workbooks in order to work with and analyze data.
Topics covered include:
- Get started with Microsoft Office Excel
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbooks
- Manage workbooks
Create, Open and Save Workbooks
- What is Excel?
- Create a New Blank Workbook
- Create a Workbook From a Template
- Open Excel Files
- Get Help
- Save Workbooks
- Navigate a Workbook
Explore the User Interface
- Backstage View
- Ribbon Overview
- Mini Toolbar
- Status Bar
- Shortcut Key Tips
- Contextual Tabs
Work with Data
- Enter, Edit and Delete Data
- Data Selection Methods
- Use Autofill and Autocomplete
- Cut, Copy, Paste and Paste Special
- Resize Columns and Rows
- Insert and Delete Columns, Rows, Cells
- Use Undo, Redo and Repeat
- Spellcheck and AutoCorrect
- Use Find, Replace and Go To
- Use Basic Functions
- Use SmartTags and Options Buttons
- Add, Edit, and Remove Comments
Format A Workbook
- Format Using the Home Ribbon
- Format Using the Mini-Toolbar
- Format Using Dialog Boxes
- Use and Modify Conditional Formatting
- Use the Format Painter
- Create and Modify Styles
- Add, Name, Move, Delete and Colour Sheets
Charts
- Create and Format a Chart
- Modify Chart Layout and Structure
- Change Chart Types, Options, Location and
- Data Source
- Save a Chart as a Template
Printing and Viewing A Workbook
- Use the View Ribbon
- Split and Freeze
- Manage Multiple Windows
- Use Page Layout, Print Preview and Basic
- Print Options
- Add Headers and Footers
Customize
- Customize the Quick Access Toolbar
- Show/Hide the Ribbon
University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.
