Discover Classes. Earn Rewards.
Course Details
Price:
$250 12 seats left
Start Date:

Tue, Dec 17, 8:00am - 12:00pm

Next start dates (3)

Location:
Centennial
7343 S Alton Way Ste 100
Near S Alton Ct
Centennial, Colorado 80112
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 16 and older
Average Class Size: 18

What you'll learn in this excel class:

This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level, and you will learn in the comfort of one of our state of the art training centers.

Training Class Goal:

In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.

Prerequisites:

Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Basic and Intermediate Excel courses. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.

Topics Covered:

Advanced Formulas
  • Viewing available Excel functions
  • Basic text functions
  • Basic “IF” conditional formulas
  • Nesting “IF” statements
  • Concatenate and “IF” statements with concatenate
  • ISBLANK Function
  • COUNTBLANK Function
  • Arrays
  • Using name ranges in formulas
  • Other classes covering Formulas and Functions
Look Ups and Other Functions
  • Lookups and Lookup functions
  • HLookup
  • VLookup
  • Calculating days of the week
  • Calculating number of weekdays from a date
  • Calculating months between 2 dates
  • SUMIF Function
  • Other classes covering Lookups
Data Views, Layouts, and Rules
  • Transposing Data
  • Validations for length and drop-down lists
  • Custom Views
Introduction to Macros
  • Developer Tools
  • Saving Macros
  • Absolute vs Relative Macros
  • Recording Macros
  • Creating Macro buttons
Additional Tools in Advanced Excel
  • Embedding and linking
  • Editing and embedded object
  • Editing a linked object
  • Linking as an icon
  • Protecting worksheets
  • Locking cells
  • Protecting a workbook
Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation. Mission Critical Training’s Advanced Excel class will give you a mastery of the functions of this important business application.

Still have questions? Ask the community.

Map

Google Map

Mission Critical Training

All classes at this location

Directions: Take I-25 to the Dry Creek exit and turn West on Dry Creek. Take a right at Yosemite and then another right on S. Alton way. The building is 2 blocks down on the left. Their are 2 entrances to the building. Go to the one on the right (#100) to access our training center. FREE PARKING! This building offers free parking. The training center entrance has a handicap accessible ramp if needed. Do not park on Alton Way.

Start Dates (4)
Start Date Time Teacher # Sessions Price
8:00am - 12:00pm TBD 1 $250
8:00am - 12:00pm TBD 1 $250
8:00am - 12:00pm TBD 1 $250
8:00am - 12: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...