Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Intermediate Microsoft Excel

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

This Instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to work with multiple worksheets within the same workbook.  Students will also learn how to use statistical, logical, and text functions like COUNT, COUNTIF, IF, CONCATENATE, TRIM, LEFT, MID, RIGHT, UPPER, LOWER and PROPER.  The course also covers how to graph information to create pie and bar charts.

Course objectives:

  • Create formulas to summarize data across worksheets and multiple files
  • Save multiple files as a workspace to create a shortcut for easy access
  • Create a shared workbook to allow multiple people to work at the same time
  • Use a variety of statistical and text functions
  • Turn numeric data into a pie, bar, and line charts

Creating and Working with Multiple-Sheet Workbooks

  • Reviewing Excel Fundamentals
  • Copying Worksheets
  • Writing 3-D References
  • Formatting Multiple Worksheets Simultaneously
  • Grouping Multiple Worksheets
  • Ungrouping Worksheets

Writing Formulas that Link Different Excel Workbooks

  • Creating Links Between Workbooks
  • Viewing Linked Information
  • Watching Formulas
  • Editing Source Files
  • Inserting Rows and Columns in the Source File

Working with Statistical and Logical Functions

  • Understanding Absolute vs. Relative Cell References
  • Using the IF Function to Calculate Based on a Condition
  • Writing IF Statements
  • Nesting IF Statements
  • Using the COUNT Function to Count a List of Numbers
  • Using the COUNTA Function to Count Non-Empty Cells
  • Using the COUNTBLANK Function to Count Blank Cells
  • Using the COUNTIF Function to Count Based on a Condition
  • Using the COUNTIFS Function to Count Based on Multiple Conditions

Using Text Functions and Features

  • Using the Text to Columns Feature
  • Inserting Columns
  • Splitting Text over Multiple Columns

Using Text Functions and Features (cont'd)

  • Using Text Functions
  • Using the CONCATENATE Function to Join Cells
  • Accelerating Data Insertion with Flash Fill
  • Using the TRIM Function to Remove Extra Spaces
  • Using the UPPER, LOWER, and PROPER Functions to Change Case
  • Using the LEFT, MID, and RIGHT Functions to Extract Characters
  • Using the Paste Values Feature

Working with Shared Workbooks

  • Creating Shared Workbooks
  • Highlighting Changes
  • Accepting and  Rejecting Changes

Charting Data to Visualize Results

  • Creating Pie Charts
  • Overview of Chart Tools
  • 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

Appendix: Auditing Formulas

  • Tracing Precedents
  • Removing Tracer Arrows
  • Tracing Dependents
  • Tracing Errors

View Upcoming Schedule or Register for a Class

Not Sure What Level to Take?

Before taking the Intermediate or Advanced level class for this application, we ask that you determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.

Back to Agenda

 

Investment

Public Class

$275 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$850 flat fee for up to 8 students
$950 for up to 12 students
$50 per additional student

Conducted at Softek’s Facility

$1000 flat fee for up to 8 students
$1100 for up to 12 students
$50 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Softek also offers a 3-hour series for this application. Visit our agendas page  to view our 3-hour classes. 

Why choose Softek?

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