You're browsing Microsoft Training in Los Angeles, CA

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

Transform static slideshows into engaging, energetic presentations by learning to tastefully apply motion to bullet text, images, shapes, SmartArt graphics and charts. Your presentations will hold your audience's attention by appearing one point or image at a time as you talk about them, without creating duplicate slides. In this three-hour session,...

This hands-on beginners course is suitable for Access 2010/2013/2016 users. Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.  After this class you will have a very good working knowledge of Microsoft access, including how to design and build an efficient relational database, construct data...

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

On this class you will learn how to use Microsoft Visio to draw a wide variety of drawings such as flowcharts, organization charts, maps, floor plans and more. No prior experience of Visio is needed. What's Included Certificate of Course Completion Training Manual FREE Class Repeat Course Outline Opening and Closing Visio Working with Files...

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

In this three-hour session for Windows and Mac users, you will learn how to efficiently produce long documents. You will assemble subdocuments into a master document, add footnotes, cross-references, bookmarks, and a cover page. You will also learn how to make Word do the work of building your table of contents, table of figures, index and bibliography...

This three-hour session for Windows and Mac users introduces you to the fundamental skills of effective word processing using Microsoft Word. You will become familiar with the Ribbon-based interface, create new documents, add and edit text, cut-and-paste, save and open documents, apply typeface and other font formatting and preview the final document...

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

This hands-on advanced course is suitable for Access 2010/201/2016 users. This course is aimed at Intermediate users of Access and covers topics such as building advanced forms, writing advanced queries, creating advanced reports and automating operations using Macros. Prerequisite: Students should have completed our Intermediate class or...

In this three-hour session for Windows and Mac users, you will learn how to markup or "redline" a document with suggested changes, potentially from multiple authors, and then accept or reject those changes when crafting the final version. You will also learn how to present columnar information in tables and how to draw freeform tables. You will also...

This hands-on beginner class is suitable for Project 2013, 2016, 2019 and 365 users. You will start with basic concepts, before proceeding through all the functions required to effectively plan and manage small to medium-size projects. These include scheduling tasks, allocating resources, creating a timeline, tracking costs and reporting. This course...

This hands-on Project class is suitable for Project 2013, 2016, 2019 and 365 users. You will learn the more advanced features of Project such as working with advanced tasks and resource pools, baselines and resolving conflicts, working on multiple projects, using project data, and closing out a project. Course Outline The Quick Access Toolbar...

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

On this class you will learn the fundamentals of Microsoft Word. You will create, edit and format documents by adding paragraphs, tables, lists, images, design elements, layout options and styles before printing or sharing your documents. No prior experience of Word is needed. Suitable for Word 2010/2013/2016 users.  Detailed course outline...