One day hands-on Microsoft® Office Excel 2007 Intermediate class provides you the training in how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports. You will work with various functions to perform specific types of calculations, customize charts, work with pictures or shapes in a worksheet, customize formatting for specific types of data, and look at various features for managing different types of lists using a table or database format.  Students who complete this course can be on their way to preparing for a Microsoft Certified Application Specialist exam. By completing the Excel 2007 Advance course, the students will have reviewed all of the exam objectives.

Topics:

• Using Math and Trigonometric Functions
• Using Statistical Functions
• Working with Financial Functions
• Using Logical Functions
• Using Date and Time Functions
• Using Text Functions
• Using Information Functions
• Using Advanced Functions
• Drawing Shapes
• Using SmartArt Graphics
• Modifying Drawing Objects
• Customizing Charts
• Using Trendlines
• Auditing a Worksheet
• Aligning the Cell Contents
• Using the Format Painter
• Hiding/Unhiding Data
• Using Cell Styles
• Looking at Custom Cell Formats
• Applying Conditional Formatting
• Using Tables
• Working with Named Ranges
• Working with Databases
• Filtering Information
• Using Database Functions
• Sorting Data

After completing this course, you will be able to:

• understand what a function is
• use the correct syntax to insert functions
• use math and trigonometric, statistical, financial, logical, date and time, text, or information functions
• draw different types of objects
• insert and modify graphics such as picture or SmartArt
• customize chart elements
• create and customize trendline charts
• audit a worksheet by finding and identifying errors
• align data in a cell using a variety of methods
• use the Format Painter to duplicate formatting
• hide or unhide rows, columns, or workbooks
• customize formats for numbers, dates, scientific or text data types
• apply conditional formatting using a variety of rules
• create and manipulate a table
• apply cell styles and Quick Styles
• use formulas in tables
• convert a list to a table list
• name, modify or delete a named range
• understand basic database concepts and terminology
• create a database
• use different filter features to find specific data
• use some of the functions for databases such as creating totals or averages

Target Audience

Anyone with basic computer skills, including, but not limited to:

For more information

call 714-505-3475