AAIM St. Louis Office

This course will familiarize students with Excel, helping them to learn how to create, entering and editing text, values, and formulas and how to save workbooks. They will learn to move and copy data and formulas, and work with ranges (contiguous versus non-contiguous), rows, and columns. Students will also learn to use simple functions and […]

This course will familiarize students with Excel, helping them to learn how to create, entering and editing text, values, and formulas and how to save workbooks. They will learn to move and copy data and formulas, and work with ranges (contiguous versus non-contiguous), rows, and columns. Students will also learn to use simple functions and […]

Excel macros and VBA are utilized to automate repetitive tasks, customize Excel's functions, and streamline data processing. With VBA, custom functions and procedures can be created, making complex calculations and data manipulation possible, extending Excel's capabilities, and making it a more powerful and efficient tool for data analysis and reporting.

Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that seemingly endless jumble of numbers on your screen. It lets you group your data differently to draw helpful conclusions more quickly. If […]

This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time […]

Building on the skills and concepts taught in Outlook Level 1, students will learn how to customize Outlook, use Quick Steps, create Folder pane shortcuts, customize their messages and signatures, and set up automatic replies. Then, students will learn how to set rules for organizing messages and use advanced techniques for managing and maintaining their […]

This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time […]