MICROSOFT EXCEL
Microsoft Excel
introduces spreadsheet terminology and Excel’s window components. Students will learn how to use the Help system
and navigate worksheets and workbooks. Then they will enter and edit text,
values, formulas, pictures and they will save workbooks in various formats.
Students will learn
how to use multiple worksheets and workbooks efficiently, and they will start working
with more advanced formatting options including styles, themes, backgrounds and watermarks. They will also learn how to create outlines
and subtotals, how to create and apply cell names and how to work with lists
and tables. Students will learn about data validation and forcasting data.They
will learn how to work with PivotTables and Pivot Charts, how to import and export data, and how to query external
databases.
PRE-REQUISITES: Computer Fundamentals
and Microsoft Word, Excel, PowerPoint
COURSE OUTLINE
Overview
·
Starting Excel
·
Working in Excel Window
·
Changing Excel’s View
·
Working with an Existing Workbook
·
Working with Excel’s Help System
Using
Backstage
·
Accessing and Using Backstage View
·
Printing with Backstage
·
Changing the Excel environment in Backstage
·
Accessing and Using Excel Templates
Working
with Microsoft Excel
·
Creating Workbooks
·
Entering and Editing Basic Data in a Worksheet
·
Using Data Types to Populate a Worksheet
·
Cutting, Copying, and Pasting Data
·
Editing a Workbook’s Keywords
·
Saving the Workbook
Formatting
Cells and Ranges
·
Inserting and Deleting Cells
·
Manually Formatting Cell Contents
·
Copying Cell Formatting with the Format Painter
·
Formatting Cells with Styles
·
Working with Hyperlinked Data
·
Applying Conditional Formatting to Cells
·
Clearing a Cell’s Formatting
Formatting
Worksheets
·
Working with Rows and Columns
·
Using Themes
·
Modifying a Worksheet’s Onscreen
·
Inserting Headers and Footers
·
Preparing a Document for Printing
Managing
Worksheets
·
Organizing Worksheets
·
Working with Multiples Worksheets
·
Using Zoom and Freeze to Change the Onscreen View
·
Finding and Replacing Data
Working
with Data
·
Ensuring your Data’s Integrity
·
Sorting Data
·
Filtering Data
·
Subtotaling Data
·
Setting up Data in a Table Format
Using
Basic Formulas and Functions
·
Building Basic Formulas
·
Using Cell References in Formulas
·
Using Cell ranges in Formulas
·
Summarizing Data Functions
·
Using Formulas to Create Subtotals
·
Controlling the Appearance of Formulas
Using
Advanced Formulas and Securing Workbooks
·
Using Formulas to Conditionally Summarize Data
·
Using Formulas to Look Up Data in a Workbook
·
Adding Conditional Logic Functions to Formulas
·
Using Formulas to Format Text
·
Securing Your Work Before Sharing it with Others
·
Distributing a Workbook by Email
·
Tracking Changes to a Workbook
·
Adding Comments to a Workbook
Creating
Charts and PivotTables
·
Building Charts
·
Formatting a Chart with Quick Style
·
Formatting the Parts of a Chart Manually
·
Modifying a Chart
·
Creating PivotTables
·
Macros and Custom Function
·
Running and Recording a Macro
·
Working with Visual Basic Code
Adding
Picture and Shapes to a Worksheet
·
Inserting Pictures
·
Adding Shapes
·
Copying or Moving a Graphic
·
Formatting Graphics
·
Adding Graphic Enhancements Using Picture Tools
No comments:
Post a Comment