|
| |
Workshop: Excel 2010 Formula and Functions |
|
| |
- Using Formulas
-
Creating Simple Formulas
- Using Basic Excel Functions: Sum, Average, Count, Countif
- Using AutoSum feature
-
Using Excel IF function
|
Date: Sept 23, 2011 (Friday)
Time: 10:00 AM to 12:00 PM
Cost: Free<
 |
|
| |
Workshop: Excel 2010 Managing Data |
|
| |
- Formatting the data
- Sorting and Filtering the data
- Using Find and Replace feature
- Using Conditional Formatting
|
Date: TBA
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
| |
Workshop: Excel 2010 Getting Started |
|
| |
- Starting Microsoft Excel 2010
- Introduction to Excel 2010 Screen Elements
- Undertanding Excel 2010 Ribbon
- Entering Data into the Excel Worksheet
- Saving an Excel Worksheet
|
Date: TBA
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
| |
Workshop: Excel 2010 Creating and Formatting Chart |
|
| |
- Creating Charts using Excel 2010
- Creating and Formating the Chart Title
- Modifying Chart Legend
- Creating a Pie Chart and Histogram
- Creating a Dynamic charts
- Using Trend line
|
Date: TBA
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
| |
Workshop: Excel 2010 Intro to Pivot Table & Pivot Chart |
|
| |
- Create a PivotTable report
-
Use Slicers for filtering data
- Analyze data using PivotCharts
-
The HLookup Dialog Box
-
The VLookup Dialog Box
|
Date: TBA
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
| |
Workshop: Excel 2010 Intro to Macro |
|
| |
- Recording a macro
-Testing a Macro
- Editing a Macro
- Using Visual Basic Editor in Excel (VBE) |
Date: TBA
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
| |
Workshop: Excel 2010 Formula and Functions |
|
| |
- Using Formulas
-
Creating Simple Formulas
- Using Basic Excel Functions: Sum, Average, Count, Countif
- Using AutoSum feature
-
Using Excel IF function
|
Date: Sept 23, 2011 (Friday)
Time: 10:00 AM to 12:00 PM
Cost: Free
|
|
Location:
NR Computer Learning Center,
2100 W. Orangewood, Suite 110,
Orange, CA
|
