Register Now      202-747-5000

Charting Data and Automating Tasks in Microsoft Excel

365 | 2019 | 2016
3 Hours

Course Overview

This instructor-led course covers tools needed to illustrate numeric data into pie, bar, line, or column charts. You will also learn how to automate formatting and repetitive tasks by using conditional formatting and macros. It is geared for users who have experience with Microsoft Excel and need to learn these more intermediate/advanced features.

Course Objectives

  • Turn numeric data into a pie, bar, line charts or sparklines
  • Apply Conditional Formatting to automate formatting
  • Create macros to automate repetitive tasks

Course Outline

Chart Data to Visualize Results

  • Creating Pie Charts
  • Overview of Chart Tools
  • Design Tab
  • Layout Tab
  • Format Tab
  • Modifying and Resizing Charts
  • Adding Chart Titles and Labels
  • Formatting Chart Objects
  • Previewing and Printing Charts
  • Creating Column or Bar Charts
  • Changing the Numbering Scale
  • Changing the Data Series to Rows or Columns
  • Working with Trendlines
  • Updating the Source Data
  • Working with Sparklines
  • Understanding Sparklines
  • Creating Sparklines
  • Showing Points and Markers
  • Applying Sparkline Styles
  • Changing the Type of Sparkline
  • Modifying Axis Options
  • Clearing Sparklines

Automate Tasks with Conditional Formatting and Macros

  • Applying Conditional Formatting
  • Applying Preset Conditional Formatting Rules
  • Editing Conditional Formatting Rules
  • Applying Conditional Formatting to Rows
  • Creating Macros Using the Macro Recorder
  • Using Relative vs. Absolute References
  • Running Macros
  • Editing Macros
  • Deleting Macros
  • Adding Macro Buttons to the Quick Access Toolbar

 

Cost/Investment

Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Public Course at Softek Private Course at Your Office Private Course at Softek
This class is $500 flat fee up to 8 students $575 flat fee up to 8 students
only offered $550 flat fee up to 12 students $625 flat fee up to 12 students
for private groups. $35 per additional student $35 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee