AcademyX

In this beginner Excel course, students will start working in Excel and build foundational skills. This course covers navigating spreadsheets, 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 upon 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 upon basic Excel skills, including cell references, formulas, and basic functions.

This advanced Excel course is designed for intermediate users who want to learn advanced Excel functions, lookups, and macros. This course covers lookup functions, advanced pivot tables, 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 and programming fundamentals, control flow, dialog 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 interface, and obtaining help. Additional topics include sending and receiving emails, 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 and calendaring 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 operations, as well as basic MS Windows platforms. This six-hour course is available online and at five live locations.

Educators, marketers, salespeople, and anyone else who must make compelling presentations to audiences of any size could benefit from this introductory PowerPoint course. This updated class covers fundamental PowerPoint concepts 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 themes with backgrounds and effects that enhance presentations. Students will also learn basic animation techniques, such as transition triggers and Animation Painter, and how to pull data from other sources into their PowerPoint presentations. Students also learn how to effectively deliver advanced presentations. That includes topics such as 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 that truly engage their audience. Mastery of the Slide Master 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 features allow input from multiple 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 a solid foundation and more. Students learn MS Word fundamentals, so they spend more time composing documents and less time scrolling through menus. Other skills taught include managing selection and navigation tools, advanced editing techniques, including special characters and time/date stamps, and simple paragraph formatting and page layout techniques. Inserting graphics and tables, also covered in this course, helps writers emphasize key points. Finally, this six-hour course teaches students how to effectively proofread and edit their documents.