Discover Classes. Earn Rewards.

Excel Intermediate

at Mission Critical Training - Westminster

(1)
Course Details
Price:
$250 12 seats left
Start Date:

Wed, Dec 04, 1:00pm - 5:00pm

Next start dates (6)

Location:
Westminster
8601 Turnpike Dr Ste 105
At Sheridan Blvd
Westminster, Colorado 80031
(Map)
Share:
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 16 and older
Average Class Size: 18

What you'll learn in this excel class:

Are you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions, charting, and data tools. Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level.

Training Class Goal:

In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.

Prerequisites:

Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.

Topics Covered:

Formulas & Functions
  • Typing formulas and functions
  • Cell references and reference formulas
  • AutoSum
  • The Functions Library
  • Average, date, and time functions
  • IF statements
  • Nested IF Statements
  • Other classes covering Formulas & Functions
Moving and Copying Data in Excel
  • Cut, copy, and paste data
  • The Fill Handle
  • Absolute and relative references
  • AutoFill and custom Lists
Working with More Functions
  • Date and Time Functions
  • Calculating dates in years
  • IF Statements in Date Functions
  • The Proper Function
  • The Roundup Function
Working with Multiple Worksheets
  • Renaming worksheets
  • Color coding tabs
  • Moving and copying worksheets
  • 3D reference formulas
  • Hyperlinks
  • ScreenTips
Formatting Cells and Appearance
  • Formatting text and numbers in cells
  • Merging cells
  • Wrapping text within a cell
  • Custom number formats
  • Conditional formatting
  • Copying formatting
  • Other classes covering Excel formatting
Viewing Worksheets
  • Showing formulas and references
  • Tracing precedents and dependents
  • Grouping rows and columns
  • Cell comments
  • Headers and footers
  • Other classes covering Navigation and Views
Introduction to Basic Charts
  • Creating and defining a chart
  • Positioning, rotating, and resizing charts
  • WordArt in charts
  • Editing charts in Excel
  • Changing types
  • Formatting a data series
  • Multiple series charts
  • Sparkline charts
  • Other classes covering Excel charts
Intermediate Excel training covers things beyond the basics, to give you more developed skills in building your spreadsheets, creating formulas to automate them, and adding visual impact with formatting and charts. 

Still have questions? Ask the community.

Map

Google Map

Mission Critical Training

All classes at this location

Start Dates (7)
Start Date Time Teacher # Sessions Price
8:00am - 12:00pm TBD 1 $250
1:00pm - 5:00pm TBD 1 $250
1:00pm - 5:00pm TBD 1 $250
1:00pm - 5:00pm TBD 1 $250
1:00pm - 5:00pm TBD 1 $250
Start Date Time Teacher # Sessions Price
1:00pm - 5:00pm TBD 1 $250
1:00pm - 5:00pm TBD 1 $250

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2500 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Mission Critical Training (1)

Similar Classes

School: Mission Critical Training

Mission Critical Training

Mission Critical Training offers training and development services including classes in Microsoft Office products, Adobe, and professional development. Services include public training centers, on-site private training, e-learning development and Instructional Design. Our focus is high quality training...

Read more about Mission Critical Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DEN educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...