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 Basics 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​

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

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. Our courses are designed specifically for companies and their employees.

Credits

0.40 Continuing Education Units
Course ID #TECH251



Class Details

Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:12/20/2018
Time:8:00 am to 12:00 pm
List Price:$205.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:01/08/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:01/24/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:02/05/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:02/19/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:03/07/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:03/19/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:04/02/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:04/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:05/01/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:05/15/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:06/04/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:06/17/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:07/02/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:07/17/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:07/29/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:08/14/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:08/28/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:09/10/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:09/27/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:10/08/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:10/24/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:11/07/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:11/19/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:12/05/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:12/17/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:01/09/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:02/13/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:03/20/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:04/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:05/21/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:06/25/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:07/23/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:08/20/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:09/27/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:10/22/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:11/14/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:12/16/2019
Time:8:00 am to 12:00 pm
List Price:$220.00

Don't see what you are looking for?

Contact Us