AcademyX

In this beginner Excel course, students will get started working in Excel and building foundational skills. This course covers spreadsheet navigation, text functions, formulas, formatting, charting, and more. Participants will walk away with the ability to perform basic workplace tasks using Excel.

In this intermediate Excel course, participants will build off basic concepts of Excel to perform more advanced data analysis. This course covers tables, summarizing data, PivotTables, advanced charting, and more. This intermediate course builds off basic Excel skills, including cell references, formulas, and beginner functions.

This advanced Excel course is designed for intermediate users to learn advanced Excel functions, lookups, and macros. This course covers lookup functions, advanced Pivots, Analysis Toolpak, macros, and more. Participants will learn to use advanced Excel techniques to solve real-world problems with data analysis.

This Excel VBA course is designed to teach experienced Excel users how to take their Excel skills to the next level with VBA programming. Participants will learn to create automated reports, perform complex calculations, and more using VBA. Topics include VBA basics, programming fundamentals, control flow, dialogue boxes, and debugging code.

This beginner-level class teaches students how to use essential Microsoft Outlook functions. Initially, students learn some Microsoft Office basics, such as launching the application, using toolbars, customizing the look, and obtaining help. Advanced topics include email sending and receiving, scheduling meetings with multiple attendees, integrating Outlook’s contact list into other functions, and taking electronic notes. This course is open to beginners in Outlook and requires basic computer skills.

This intermediate Microsoft Outlook course goes beyond basic emailing, calendaring, and other functions. Students master operations such as using folders to organize documents, creating rules to manage emails, customizing their messages and notes, and collaborating with colleagues online. Students should already be familiar with Microsoft Outlook’s basic operation, as well as basic MS Windows platforms.This six-hour course is available online and at five different live locations.

Educators, marketers, salespeople, and anyone else who must make compelling presentations to any sized audience could benefit from this introductory PowerPoint course. This upgraded class covers basic PowerPoint theories and operations, as well as some new program upgrades. After they complete this six-hour class, students should be able to create professional-grade slide presentations, use different slide formats, add powerful graphics, create tables, and add polish to their personal presentations. This course is open to PowerPoint beginners who have basic computer skills.

This PowerPoint intermediate class allows students to take their PowerPoint preparation and presentation skills to the next level. Core concepts include creating a theme, with backgrounds and other effects, which enhance the presentation. Students will also learn basic animation techniques, such as transition triggers and animation painters, and how to pull data from other sources into their PowerPoint presentations. Students also learn how to effectively deliver advanced presentations. That includes things like web publishing and advanced online collaboration. Course requirements include completion of a beginner PowerPoint course and solid understanding of MS Windows functions.

Students who complete this advanced six-hour PowerPoint class will be able to create presentations which truly enhance their listeners’ lives. Mastery of the SlideMaster function helps users create professional-grade presentations. Students also learn how to embed hyperlinks, video, and audio into individual slides. Advanced animation brings slides to life, and advanced collaboration allows input from almost unlimited sources. This course also focuses on the nontechnical aspects of PowerPoint, so students become effective presenters. Students who have a solid understanding of MS Windows and have completed an intermediate PowerPoint course should do well in this class.

Microsoft Word is still the standard when it comes to word processing. This beginner course gives students more than a solid foundation. Students learn some MS Word fundamentals, so they spend more time composing documents and less time scrolling through menus. Other skills taught include management of the updated selection and navigation functions, advanced editing that includes special characters and time/date stamping, and easy paragraph formatting/page layout techniques. Inserting graphics and tables, another area covered in this course, helps writers emphasize key points. Finally, this six-hour course teaches students how to effectively proofread and edit their documents.