Excel is a powerful software tool for organizing and analyzing data. It is widely used by businesses to work with financial data. Before using Excel, you must understand some terminology and the different areas of the Excel screen.
Learning Objectives
- Understand the uses of Excel
- Define workbook and worksheet
- Describe the different areas of the Excel screen
- Define cell and range
- Identify cell and range addresses
- List methods for selecting cells and ranges
Language: English
Estimate Time (Hrs.): 1.3
Creating a worksheet begins with entering text and values. The text and values can be any type of data, such as students' grades, a family budget, customer addresses, sales data, and other financial data.
Learning Objectives
- Explain the difference between text and values
- List the data entry process
- Describe how Excel handles leading and trailing zeros
- Edit data
- Delete data
- Explain how to use Undo and Redo
- Move data
- Copy data
- List common keyboard shortcuts
- Describe how to use Flash Fill, AutoComplete, and AutoFill to enter data
Language: English
Estimate Time (Hrs.): 1.5
Various formatting commands built into Excel enable you to change the look of your worksheet and make important data stand out. Formatting can be applied to single cells or to a range of cells either before or after you enter your data.
Learning Objectives- Define formatting
- Describe the process for formatting text and values
- Change the column width or row height
- Explain the purpose of specific formatting options
- Describe what happens to cells when data is deleted
- Discuss how to clear formatting
- Define cell styles and themes
- Explain what happens when you use Format Painter and F4
Language: English
Estimate Time (Hrs.): 1.8
Formulas and functions enable you to perform calculations on a worksheet. Excel can perform simple calculations, such as summing a column of numbers, or very complex calculations such as calculating financial, statistical or engineering information.
Learning Objectives
- Define formula and function
- List the mathematical operators used in Excel
- Explain how references to cells or ranges are used in formulas and functions
- Use the Sum and Average functions
- Use the AutoSum command
- Understand how to copy formulas and functions
- Explain relative and absolute cell references
- Understand how to move formulas and functions
- Describe methods for troubleshooting formulas and functions
Language: English
Estimate Time (Hrs.): 1.7
Excel enables you to enter dates and times on your worksheet, format them, and use them in calculations like other values. However, there are some rules and limitations you must be aware of so that any calculation using dates and times is accurate.
Learning Objectives
- List uses for dates and times in a worksheet
- Explain the serial numbers Excel uses to create dates and times
- Enter dates and times in valid formats
- Explain how to use the Today and Now functions
- Use keyboard shortcuts to enter the current date and current time
- Format dates and times using predefined formats and custom formats
- Use dates and times in formulas
Language: English
Estimate Time (Hrs.): 1.3
An Excel workbook consists of one or more worksheets. Some Excel commands apply to entire worksheets, such as deleting a worksheet. This course introduces some of the most commonly used worksheet commands.
Learning Objectives
- Insert rows and columns in a worksheet
- Delete rows and columns from a worksheet
- Hide rows and columns in a worksheet
- Add worksheets to a workbook
- Edit worksheet tabs
- Delete, move, and copy worksheets from a workbook
- Zoom in or out of a worksheet
- Use the Freeze Panes command
Language: English
Estimate Time (Hrs.): 1.5
A workbook is a file created in Microsoft Excel that is used to store data, charts, and other information in a digital format. Understanding how to manage workbooks will make it easier and more efficient to work in Excel.
Learning Objectives
- Create a blank workbook
- Create a workbook from a template
- Save a workbook
- Close a workbook
- Open an existing workbook
- Pin a workbook in the recent documents list
Language: English
Estimate Time (Hrs.): 1