Microsoft Excel Managing Data
Managing Data
Microsoft Excel Managing Data
Course Overview
Students on this Microsoft Excel – Managing Data half-day course will learn best practices for managing your Excel data, including the use of Outlining, before moving on to the What If Analysis tools to assist in planning and managing projections for your business.
The course assumes you have a good grasp of the fundamentals of Excel, those who are involved in business and project planning will benefit from attending this course.
Course Details
Advanced
10 Students (max)
½ Day Training Course
9:00am -12:30pm
$350+GST
Upcoming Public Courses
There are no upcoming courses at this time.
However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.
Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.
Course Content
Overview of Managing Data
- Introduction to Managing Data
Grouping and Outlining
- Creating Automatic Outlines
- Creating Manual Outlines
- Visible Cells Only Options
Subtotals
- Setting up Subtotals
- Expanding and Collapsing Subtotals
- Removing Subtotals
Data Consolidation
- Consolidating by Position
- Consolidating by Category
What if Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Solver
Learn Today Face to Face Online with Keystroke Learning
Today
Face to Face
Online
Learn with Keystroke Learning
Our training approach is professional yet friendly, motivating participants to learn quickly and easily.
When you complete our training course, you will be ready to apply your new skills right away.
If you have a customised training solution in mind or need to schedule our popular computer courses
call (03) 9999 7780 or email us @ info@keystrokelearning.com.au