Microsoft Office Excel Advanced, SC 541
About this Course:
In this course, advanced features of Microsoft Excel are covered.
This course may be taken in MS Office 2003 or MS Office 2007. Course schedule will indicate which version is included in each offering.
Knowledge of the Windows Operating System, entry and editing of data in Excel worksheets, working knowledge of Excel's formatting menus, knowledge of formula structure, editing and copying and printing worksheets and workbooks.
Who Should Attend:
This course is a follow-on to the Excel : Basics (SC 531) and Excel : Intermediate (SC 567) courses that expanding on the advanced capabilities of Excel. The course is designed to promote usage of Excel beyond the basic spreadsheet functions and calculations.
Participants will be able to apply the following operations to their workbooks.
Generate information based on the data entered in selected cell.
Query and filter data to display specific information.Format reports using styles or auto formats.
Use pivot tables and pivot charts for interactive display of information.
Link to workbooks and/or worksheets for calculations.
Work with macros for repetitive tasks, their creation and editing.
Work with workbooks on the Web.
Consolidate information in large worksheets.
Work with text strings.
Working with Advanced Formulas
Lookup and Data Tables
Advanced List Management
Working with Pivot Tables
Exporting and Importing
Using Analytical Options
Working with Macros
Interactive Web Pages
Text or String Functions
Professional Learning Programs