Advanced Excel 2003

PT6311
Summary
This course is full of advanced topics that will help students leverage the power of Excel. Begin with using Range Names in formulas rather than having to select the same cells over and over. Youll use these range names in a number of different Functions. Learn about many of the frequently-used Functions such as Logical and Date Functions. Learn to use Excels database features and how to create a data-entry form. Learn to enable and work with Advanced Filters to extract the specific data you need. Work with a variety of Import and Export scenarios. Importing from a website? We can show you how to set timed intervals to update the Excel import. Learn the power of using Pivot Tables to analyze data. Instead of making 10 different reports and having to create 10 different spreadsheets with the same data use a Pivot Table to easily change the way your data is presented. Are you using Templates? If not, why are you working so hard! Templates are easy to make and update. Save time by creating templates that streamline your workflow. Conditional and Custom Formats are advanced features that allows you to set a criteria in your spreadsheet. Anything that meets the criteria can stand out with specific formatting. This will be one of your favorite features. An advanced class means Advanced Functions! Learn the difference in VLOOKUP and HLOOKUP and how these are used daily in your everyday life. Well show you to create and run a macro and how to assign your macro to an Icon or Menu.
Prerequisites
This course is not for novice users. Students should have taken the Introduction and Intermediate level of this course or have equivalent experience.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for those with Excel experience seeking introduction to advanced functions.
Topics
  • Using Range Names
  • Using Other Functions
  • Using AutoFilter
  • Using HTML Files
  • Working with Comments
  • Working with Labels in Formulas
  • Working with Outlines
  • Working with Databases
  • Working with the Data Form
  • Working with Advanced Filters
  • Using List Features
  • Exporting and Importing Data
  • Using Multiple Workbooks
  • Using Conditional and Custom Formats
  • Using Templates
  • Customizing Excel Preferences
  • Using Worksheet Protection
  • Sharing Workbooks
  • Working with Data Series
  • Using Advanced Functions
  • Using Scenarios and Goal Seeking
  • Using Data Tables
  • Using Auditing Tools
  • Consolidating Worksheets
  • Solving Problems
  • Working with Views
  • Using Macros
  • Recording Macros
  • Editing Macros
  • Using Custom Toolbars and Menus
  • Creating Macro Buttons
  • Creating/Revising PivotTables

Related Scheduled Courses