Microsoft Excel Advanced
Excel
Training
Provided by Computer Training Source, Inc.
We will learn importing and exporting, use data forms and named ranges, format numbers, use the solver, sort and filter lists, create macros, learn spreadsheet protection and validation, master data validation, merge and link workbooks, and use advanced data analysis tools. 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 Advanced
Looking At This Course
Examining The Projects
Setting Up Excel
Using Templates
Follow-up
Using Data Forms
Using Named Ranges
Formatting Numbers
Using Custom And Conditional Formatting
Follow-up
Sorting Lists
Using Macros
Using Grouping And Outlines
Applying Data Filters
Understanding Advanced Filters
Follow-up
Understanding Importing
Importing From Text Files
Querying Databases
Importing From HTML Files
Exporting To Other Applications
Follow-up
Understanding Solver
Using Solver
Understanding Scenarios
Understanding Goal Seek
Auditing A Worksheet
Follow-up
Understanding Shared Workbooks
Applying Protection And Sharing
Setting File Passwords And Properties
Follow-up
Using Data Validation
Using Comments
Tracking Changes
Merging Workbooks
Linking Workbooks
Printing Worksheets And Reports
Follow-up
Financial Records
Standard Tools
Formatting Tools
Navigation Shortcuts
Lesson 1 - Getting Started
Looking At This Course
Examining The Projects
Setting Up Excel
Using Templates
Follow-up
Lesson 2 - Working With Records And Ranges
Using Data Forms
Using Named Ranges
Formatting Numbers
Using Custom And Conditional Formatting
Follow-up
Lesson 3 - Sorting, Outlining, And Filtering Lists
Sorting Lists
Using Macros
Using Grouping And Outlines
Applying Data Filters
Understanding Advanced Filters
Follow-up
Lesson 4 - Importing And Exporting Data
Understanding Importing
Importing From Text Files
Querying Databases
Importing From HTML Files
Exporting To Other Applications
Follow-up
Lesson 5 - Using Data Analysis Tools
Understanding Solver
Using Solver
Understanding Scenarios
Understanding Goal Seek
Auditing A Worksheet
Follow-up
Lesson 6 - Protecting And Sharing Workbooks
Understanding Shared Workbooks
Applying Protection And Sharing
Setting File Passwords And Properties
Follow-up
Lesson 7 - Managing Workbooks
Using Data Validation
Using Comments
Tracking Changes
Merging Workbooks
Linking Workbooks
Printing Worksheets And Reports
Follow-up
Lesson 8 - Application Project
Financial Records
Lesson 9 - 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...
