AdvantEdge Training

This introductory Microsoft Access course introduces students to the tools and concepts needed to understand and work with relational databases. This course covers a range of database essentials and teaches students how to navigate within Microsoft Access, how to organize and manage data stored in Access tables, how to use queries to join, sort, and filter data, how to use forms to enhance workflow, and how to create custom reports. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This intermediate Microsoft Access course introduces students to more advanced tools and concepts needed to be proficient in managing databases. This course covers a range of intermediate to advanced concepts and teaches students how to design a relational database, how to join tables and perform data validations, how to write advanced queries, how to organize a database efficiently, how to use advanced reports, and more. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This advanced Microsoft Access course introduces students to a range of advanced tools and concepts needed to be an expert database professional. This course covers a range of advanced concepts and teaches students how to implement advanced form design, share data across apps, use macros to improve UI design, work with VBA, use advanced database management, how to distribute and secure a database, how to manage switchboards, and more. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This comprehensive Microsoft Access bootcamp introduces students to a range of beginner, intermediate, and advanced concepts to understand the tools and concepts needed for working with relational databases. Students will learn how to navigate within Microsoft Access, design a database, create a relational database, manage data in a table, query a database, and design forms and basic reports, and maximize their databases with advanced queries. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This introductory class covers basic PowerPoint skills. Students will learn how to create professional-grade slide presentations, use different slide formats, add powerful graphics, create tables, and add polish to their presentations. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

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 will learn how to deliver compelling presentations. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Students who complete this advanced six-hour PowerPoint class will be able to create presentations with animations and interactivity. Students will 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. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

In this beginner course, students will learn the fundamentals of project management. Students will learn how to identify, select, charter, and scope a project. As students progress to the planning phase, they will discover how to break down work and distribute tasks, define and sequence activities, create network diagrams, estimate activity resources, establish start and completion times, and much more. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Journey from novice user to advanced expert in this intensive, fast-paced, three-day Microsoft Word bootcamp. No matter where you currently fall on this user continuum, you can benefit greatly from this course. Students will learn how to use this software to edit and correct documents, format paragraphs, modify documents to publish them in various forms, and seamlessly add design elements to text documents. They will also learn advanced Word skills, such as adjusting page layout and orientation, creating notation additions, using comments and track changes, customizing document security features, and using Mail Merge and other tools. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This introductory 7-hour Microsoft Word course introduces students to a range of beginner Word concepts to be able to get up and running in no time with Word. This course covers many of the most used beginner Word components, including how to navigate around a document, formatting documents, working with text and paragraphs, using tables in Word, working with lists, inserting endnotes and footnotes, and how to insert images into documents. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This intermediate Microsoft Word course teaches students a range of intermediate Word concepts to propel students from a novice user to a near expert. This course covers a wide range of intermediate to advanced Word components, including working with tables and charts, customizing formats, inserting content with quick parts, using templates to automate formatting, how to simplify lengthy documents, how to use mail merge for labels, and more Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Learn to manage long Microsoft Word documents in this advanced course. The curriculum includes the development of documents such as ebooks, whitepapers, and academic works. Specific course topics include assembling long documents, using cross-references, inserting footnotes, adding cover pages and reference tables, and building indices and bibliographies. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Learn the basics of Microsoft Project in this course. Students will explore topics like task listing, resource assigning, task detailing, plan formatting, task scheduling, and progress tracking. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Go beyond the basics of Microsoft Projects with this intermediate course. Students will learn about topics such as resource consolidation, project customization, resource planning, progress tracking, and report status. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

In this comprehensive Microsoft Office bootcamp, IT professionals will gain the skills needed to implement and manage Microsoft Office 365 for enterprise use. Students will learn how to set up, configure, and deploy Microsoft Office 365, including SharePoint and OneDrive. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Master the time management features of Microsoft Outlook like email encryption, enhanced messaging, inbox organization, contact management, user customization, calendar management, and automated email maintenance, in this two-day intermediate course. Students will learn to use features such as journals, distribution lists, and public and shared folders. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This introductory Excel course is meant to get new users up and running with the fundamentals of Excel. Students will learn to perform basic calculations, navigate the workbook, and more as they get comfortable with Excel. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

This intermediate Excel course teaches users more advanced skills in Excel. Students will learn to work across multiple sheets and workbooks to create sparklines and trendlines, write formulas, consolidate data, and use lookup functions. Students will have access to free retakes of this course for six months and will receive a hard copy training manual for future reference.

Significantly improve your Microsoft Excel skills in this advanced course. The curriculum focuses on practical tips and little-known shortcuts that allow you to work smarter instead of harder. Specific course topics include using all available Excel functions, including ISBLANK and COUNTBLANK, nesting conditional formulas, utilizing different arrays, transposing data, using macros, and exploring advanced Excel tools.

During this three-day intermediate-level bootcamp, participants become more comfortable with Microsoft Excel’s many features. Go past basic data entry and learn data analysis functions as well as some user-friendly features. Specific course topics include creating and formatting PivotTables, using Excel Charts, managing the database, incorporating conditional formulas, using macros, and mastering some common collaboration tools.