Microsoft Excel Intermediate
Excel
Training
Provided by Computer Training Source, Inc.
In this class you ll create and filter lists, use graphing features to create bar, line and pie charts from spreadsheets, enhance your charts, and link formulas across sheets. You ll also learn Excel s database features, create your own template, and learn how to use pivot tables. Using advanced functions in formulas will also be practiced. Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with practice files to take home. A free repeat, within six months, is included as well as thirty days of technical support.Class is usually one day from 9am to 4pm (unless it& 39;s an evening class or an accelerated class). Click on any class date below to view a class outline.
|
|
||||||||||
Microsoft Excel Intermediate
Looking At This Course
Examining The Projects
Setting Up Excel
Renaming Worksheets
Moving Worksheets
Follow-up
Working With Databases
Working In Lists
Sorting Lists
Using AutoCorrect
Follow-up
Understanding Paste Function
Using Logical Functions
Using Financial Functions
Using Date Functions
Follow-up
AutoFormatting Worksheets
Formatting Worksheets
Using Page Breaks
Working With Objects
Follow-up
Understanding 3-D Workbooks
Linking Worksheets
Showing Formulas And References
Follow-up
Understanding Charts
Creating Charts
Modifying Charts
Finishing Charts
Follow-up
Creating PivotTables
Adjusting PivotTables
Creating PivotCharts
Follow-up
Understanding Templates
Using A Template
Customizing The Template
Entering Data
Follow-up
Lesson 9 - Application Project
Client Project Workbook
Understanding The Web
Saving As Different File Types
Working With Web Pages
Looking At Web Pages
Follow-up
Standard Tools
Formatting Tools
Navigation Shortcuts
Lesson 1 - Exploring Excel
Looking At This Course
Examining The Projects
Setting Up Excel
Renaming Worksheets
Moving Worksheets
Follow-up
Lesson 2 - Using Lists
Working With Databases
Working In Lists
Sorting Lists
Using AutoCorrect
Follow-up
Lesson 3 - Working With Functions
Understanding Paste Function
Using Logical Functions
Using Financial Functions
Using Date Functions
Follow-up
Lesson 4 - Formatting Worksheets
AutoFormatting Worksheets
Formatting Worksheets
Using Page Breaks
Working With Objects
Follow-up
Lesson 5 - Using 3-D References
Understanding 3-D Workbooks
Linking Worksheets
Showing Formulas And References
Follow-up
Lesson 6- Working With Charts
Understanding Charts
Creating Charts
Modifying Charts
Finishing Charts
Follow-up
Lesson 7 Using PivotTables and PivotCharts
Creating PivotTables
Adjusting PivotTables
Creating PivotCharts
Follow-up
Lesson 7 - Using Templates
Understanding Templates
Using A Template
Customizing The Template
Entering Data
Follow-up
Lesson 9 - Application Project
Client Project Workbook
Lesson 10 - Using Excel And The Web Appendix
Understanding The Web
Saving As Different File Types
Working With Web Pages
Looking At Web Pages
Follow-up
Lesson 11 - Common Tools And Shortcuts Appendix
Standard Tools
Formatting Tools
Navigation Shortcuts
About The Training Provider: Computer Training Source, Inc.
Computer Training Source, Inc. - Computer Training Source, Inc. has offered computer training classes in Chicago, Il and New York, NY since 1991. We specialize in instructor-led training in all the popular desktop software applications. Training can be held at our training centers, at your location, or via the Internet. We have training rooms in the Chicago area (downtown, Naperville, and Schaumburg), and in the New York area...
