SP921 - Excel Data Manipulation
Course Description
Discover ways to save time and increase your efficiency, whether you are working with one large spreadsheet or multiple tables. Find out how you can combine portions of several lists or tables into one consolidated table. Learn how to navigate with hyperlinks through multiple sheets of a workbook, multiple workbooks, or even to other programs. Save valuable time by accessing custom-made views of your spreadsheet. Topics include how to eliminate repetitive typing by creating, modifying, and printing comments for compressed notations on spreadsheets; use Group and Outline to quickly show and print totals in sections of your spreadsheet; and create styles to use in multiple spreadsheets.
In this course, you will learn to:
-
Create and manipulate comments for notating your spreadsheets.
-
Tile views of a spreadsheet or multiple sheets within a workbook.
-
Freeze panes to keep headings on the screen as you scroll through the spreadsheet.
-
Use the Go To command to quickly access certain cells or highlight a range.
-
Correct some common error messages that occur when you create a formula.
-
Save time by creating a custom list for labels.
-
Switch the orientation of your spreadsheet to a different configuration efficiently.
-
Sort data from left to right instead of top to bottom.
-
Efficiently move columns to a different location on your spreadsheet.
-
Shift cells left, up, or down to avoid interrupting an entire row of data.
-
Use the Paste Special command.
-
Create custom views to quickly access areas of your spreadsheet.
-
Organize your data using Group and Outline.
-
Consolidate multiple data sources into one workbook.
-
Use Data Validation to control data entry in a spreadsheet or list.
-
Create hyperlinks.
Prerequisites
Intermediate Applications of Excel or equivalent experience.Applies Towards the Following Certificates
- Business Applications Certificate : Spreadsheet
- Excel Certificate : Data Analysis & Visualization, Electives