The prerequisites for this course are an intermediate Excel course or equivalent working knowledge of the software.
LessonsLearn how to create outlines and subtotals, pivot tables and reports, and create and use macros and forms.
This course will teach you how to create outlines and subtotals, pivot tables and reports, and create and use macros and forms.
What You'll Learn
Upon completion of the course, participants will be able to create use macros, create and use Scenarios, use Goal Seek, and link Excel to an Access Database.
Who Needs to Attend
This course is intended for students who are experienced Excel 2010 users who have a desire or need to advance their skills in working with some of the more advanced Excel features.
Explore the User Interface (If Required for Upgrade Students)
â€¢ Backstage View
â€¢ Ribbon Overview
â€¢ Mini Toolbar
â€¢ Status Bar
â€¢ Shortcut Key Tips
â€¢ Contextual Tabs
â€¢ Change Excel Options
â€¢ Use Automatic Outlining
â€¢ Display and Collapse Levels
â€¢ Manually Group Data
â€¢ Create Subtotals
â€¢ Create a Pivot Table
â€¢ Change and Rearrange Pivot Table Data
â€¢ Modify Pivot Table Format and Structure
â€¢ Chart a Pivot Table
â€¢ Create a Pivot Table from External Data
â€¢ Use Slicer to Filter Pivot Table Data
â€¢ Use Sparklines
â€¢ Use the PowerPivot Add In
Using Excel with Other Programs
â€¢ Link to an Access Database
â€¢ Transform Excel into an Access Database
â€¢ Import and Export Data to and from Text and CSV files
â€¢ Import Data from External Sources
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
your city, your province