EXCEL 2010:
LEVEL1
► Click
here for Excel Level 2
► Click
here for Excel Level 3
COURSE
OBJECTIVES:
You will
create and edit basic Microsoft Office Excel 2010 worksheets
and workbooks.
TARGET STUDENT:
This course is
designed for people who desire to gain the necessary skills
to create, edit, format, and print basic Microsoft Office
Excel 2010 worksheets.
PREREQUISITES:
To be
successful in this course, you should be familiar with using
personal computers and you should have used the mouse and
keyboard. You should be comfortable in the Windows
environment and be able to use Windows to manage information
on the computer. Specifically, you should be able to launch
and close programs; navigate to information stored on the
computer; and manage files and folders.
DURATION:
1 Day
|
Course Content:
|
LESSON 1: GETTING STARTED WITH EXCEL
-
Identify the Elements of the Excel Interface
-
Navigate and Select Cells in Worksheets
-
Customize the Excel Interface
-
Create a Basic Worksheet
LESSON 2: PERFORMING CALCULATIONS IN AN EXCEL
WORKSHEET
LESSON 3: MODIFYING A WORKSHEET
LESSON 4: MODIFYING THE APPEARANCE OF A
WORKSHEET
LESSON 5: MANAGING AN EXCEL WORKBOOK
LESSON 6: PRINTING EXCEL WORKBOOKS
-
Define the Page Layout
-
Print a Workbook
|
| |
.
EXCEL 2010:
LEVEL2
► Click
here for Excel Level 1
► Click
here for Excel Level 3
COURSE
OBJECTIVES:
You will
use advanced formulas and work with various tools to analyze
data in spreadsheets. You will also organize table data,
present data as charts, and enhance the look and appeal of
workbooks by adding graphical objects.
TARGET STUDENT:
This course is meant for those desiring to gain advanced
skill sets necessary for calculating data using functions
and formulas, sorting and filtering data, using PivotTables
and PivotCharts
for analyzing data, and customizing workbooks.
PREREQUISITES:
Before starting this course, learners are recommended to
take Microsoft® Office Excel® 2010: Level 1.
DURATION:
1 Day
|
Course Content:
|
LESSON 1:
CALCULATING DATA WITH ADVANCED FORMULAS
-
Apply Cell and Range Names
-
Calculate Data Across Worksheets
-
Use Specialized Functions
-
Analyze Data with Logical and Lookup
Functions
LESSON 2:
ORGANISING WORKSHEET AND TABLE DATA
LESSON 3: PRESENTING DATA USING CHARTS
-
Create a Chart
-
Modify Charts
-
Format Charts
LESSON 4:
ANALYSING DATA USING PIVOTTABLES, SLICERS &
PIVOTCHARTS
-
Create a PivotTable Report
-
Filter Data Using Slicers
-
Analyse Data Using PivotCharts
LESSON 5: INSERTING GRAPHIC OBJECTS
-
Insert and Modify Pictures and ClipArt
-
Draw and Modify Shapes
-
Illustrate Workflow Using SmartArt Graphics
-
Layer and Group Graphic Objects
LESSON 6: CUSTOMIZING AND ENHANCING THE EXCEL ENVIRONMENT
|
| |
.
EXCEL 2010:
LEVEL3
► Click
here for Excel Level 1
► Click
here for Excel Level 2
COURSE
OBJECTIVES:
You will automate some common Excel tasks, apply advanced
analysis techniques to more complex data sets, troubleshoot
errors, collaborate on worksheets, and share Excel data with
other applications.
TARGET STUDENT:
This course was designed for people desiring to gain the
skills necessary to create macros, collaborate with others,
audit and analyze worksheet data, incorporate multiple data
sources, and import and export data.
PREREQUISITES:
To ensure your success, we recommend that you first take
Microsoft® Office Excel® 2010: Level 1 and Microsoft® Office
Excel® 2010: Level 2.
DURATION:
1 Day
|
Course Content:
|
LESSON 1:
STREAMLINING WORKFLOW
-
Update Workbook Properties
-
Create a Macro
-
Edit a Macro
-
Apply Conditional Formatting
-
Add Data Validation Criteria
LESSON 2:
COLLABORATING WITH OTHER USERS
LESSON 3: AUDITING WORKSHEETS
-
Trace Cells
-
Troubleshoot Invalid Data and Formula Errors
-
Watch and Evaluate Formulas
-
Create a Data List Outline
LESSON 4:
ANALYSING DATA
LESSON 5:
WORKING WITH MULTIPLE WORKBOOKS
LESSON 6: IMPORTING
AND EXPORTING DATA
LESSON 7:
INTEGRATING EXCEL DATA WITH THE WEB
LESSON 8:
STRUCTURING WORKBOOKS WITH XML
|
| |
