|
ctc TrainCanada ~ computer training Toronto, Markham, Mississauaga Cancellation Policy
Description:
| Lesson 1.1 Using Formulas In Excel |
| Understanding Relative And Absolute Cell References |
| The Basic Mathematical Operators |
| Using Formulas With Multiple Cell References |
| The Formula Auditing Bar |
| Fixing Formula Errors |
| Displaying And Printing Formulas |
|
|
| Lesson 1.2 Exploring Excel Functions |
| What Are Functions? |
| Finding The Right Function |
| Some Useful And Simple Functions |
|
|
| Lesson 1.3 Using Functions In Excel |
| Inserting Functions |
| Using Functions And Autofill To Perform Difficult Calculations |
| Using The If Function |
| Working With Nested Functions |
|
|
| Lesson 1.4 Working With Names And Ranges |
| What Are Range Names? |
| Defining And Using Range Names |
| Selecting Nonadjacent Ranges |
| What Is Auto Calculate? |
|
|
| Lesson 1.5 Working With Array Formulas |
| What Are Array Formulas? |
| Using Basic Array Formulas |
| Using Functions With Array Formulas |
| Using The If Function In Array Formulas |
|
|
| Lesson 2.1 Working With Lists |
| What Is A List? |
| Creating Lists |
| Modifying Lists |
| What Is The Total Row? |
|
|
| Lesson 2.2 Working With Records And Fields |
| What Are Records And Fields? |
| Adding Fields By Inserting Columns |
| Adding Records By Inserting Rows |
| Adding Records With A Data Form |
| Finding And Deleting Records |
|
|
| Lesson 2.3 Working With Lists And Filters |
| Sorting A List |
| What Is An Autofilter? |
| Custom Autofilters |
| Using An Advanced Filter |
| Copying Filtered Records |
|
|
| Lesson 2.4 Using Excel As A Database |
| Filtering With Wild Card Characters |
| Validating Your Data |
| What Are Database Functions? |
| What Are Lookup Functions? |
|
|
| Lesson 3.1 Creating Macros In Excel |
| What Is A Macro? |
| Creating A Macro |
| Playing A Macro |
| Assigning A Shortcut Key To Macro |
| Macros, Buttons, And Toolbars |
|
|
| Lesson 3.2 Excel Form Controls |
| What Is A Form Control? |
| The Form Toolbar |
| Adding A Control To A Worksheet |
| Assigning A Macro To A Control |
| Using Form Controls |
|
|
| Lesson 4.1 Using Excel In Word |
| Inserting Excel Data In Word |
| Modifying Excel Data After Insertion |
| Linking Excel Data In Word |
| Linking An Excel Chart In Word |
|
|
| Lesson 4.2 Using Excel Other Programs And Files |
| Using Outlook To Send Excel Data |
| Opening An Excel File In A Different Format |
| Importing Data From A Text File |
| Importing Data From A Database |
|
|
Pre-Requisites: Prerequisites include an introductory course in Excel or equivalent working knowledge with the software.
Certificates offered: Certification of Completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: Ottawa Office
Suite 220, 350 Sparks Street
Delta Office Tower
Ottawa
Ontario
Canada
K1R 7S8
| 
