Excel includes commands designed to make it faster and easier to work with data that is arranged in a table. If your data is arranged in a table, you will find the Excel's Table Tools very beneficial.
Estimated completion time (hours): 1.6By the end of this course, you will be able to do the following:
- Describe a table
- Insert a table
- Change the table style and the worksheet theme
- Insert a total row and then insert functions
- Describe how to resize the table
- Insert a calculated column
- Sort and filter data
- Remove duplicate records from the table
- Convert a table to a range
Estimated Time (Hrs): 1.6
Language: English
There is an old saying that a picture is worth a thousand words. Excel's chart tools enable you to present complex data in an easy to understand visual format.
Estimated completion time (hours): 1.4By the end of this course, you will be able to do the following:
- Create a chart based on Excel data
- Define common chart elements
- Describe how to change the chart layout, colors, style, or other options
- Explain how to reposition or resize a chart
- Create and edit Sparklines
Estimated Time (Hrs): 1.4
Language: English
The printing process enables you to print physical copies of your worksheet. Excel provides many options to specify what is included on the printout and how it should look.
Estimated completion time (hours): 1.0By the end of this course, you will be able to do the following:
- Explain the printing process
- Describe the print window and print preview
- Switch between different document views
- Change the margins, orientation, and paper size
- Select a print area
- Understand manual and automatic page breaks
- Change the scale of the document
- Insert headers and footer
Estimated Time (Hrs): 1.5
Language: English
Excel provides
several different options that enable you to prevent unauthorized users from
seeing confidential information or changing information that shouldn’t be
changed.
Estimated completion time (hours): 1.1
Objectives
By the end of this course, you will be able to do the following:
- Explain the reasons for protecting a worksheet or workbook
- Describe the different levels of protection you can apply to a worksheet or workbook
- Understand what happens if you forget the password used to protect a worksheet or workbook
Estimated Time (Hrs): 1.1
Language: English