Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
You will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. By the end of this course, you will be prepared to pass the Microsoft Office Specialist core-level exam for Excel 2013.
Microsoft Word is a word processing system that can be utilized for both business and personal use. While already feature rich and critical for productivity, Microsoft continues to improve and enhance Word with each new release.
Microsoft Word training at The American Technical Institute will help you develop or improve your Microsoft Word skills so that you are able to make the most of this industry standard application
New Horizons offers world-class training for several versions of Microsoft
Your Outlook training will help prepare you for Microsoft Office Specialist certification. This certification is helpful if you are new to the job market, or looking to get ahead in your current position
You will learn how to query with SQL; create cross-tab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. By the end of this course, you will be prepared to pass the Microsoft Office Specialist exam for Access 2013.
You will learn to customize PowerPoint by modifying the Ribbon and changing application settings. You will add multimedia content and interactive elements to slides, and they will learn about presentation distribution options including PDF, HTML, and online broadcasts. Finally, you will learn to integrate Power- Point with Word and Excel. By the end of this course, you will be prepared to pass the Microsoft PowerPoint 2013 Advanced exam.