Microsoft Office Classes in Los Angeles, CA

Our Intro to Excel class will familiarize you with modifying, creating, printing and formatting worksheets. You will learn formulas for calculations and functions to help automate tasks.  This training will cover: Spreadsheet basic concepts Navigating the Excel interface Creating new files and opening existing ones Entering and editing data Modifying...

Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for...

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Macros, collaboration, security are the foundations of this advanced Excel class. You will learn about different scenarios and how to use what if analysis.  Advanced functions and much more are also covered: Using IF, SUMIF, and COUNTIF to process data based on rules Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets...

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...

The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation, entry techniques, cell references, using the command groups & settings, formulas & functions, charts & graphs and simple database operations. Continuing classes include a overview of Excel's vast collection of formulas and functions. ...

Once you are able to navigate your way through the basics of Word and Excel, you’re probably ready to explore what more these two powerful Microsoft Office programs can offer: After a short review, we’ll guide you through:  Word:  We’ll take a closer look at formatting pages; working with styles and themes, creating bullets and...

This hands-on class is suitable for Excel 2010, 2013 and 2016 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,...

Become the leader in creating spreadsheets and data presentation, Topics include:  Basic worksheet navigation Entry techniques Cell references Using the command groups & settings Formulas & functions Charts & graphs Simple database operations Note: Continuing classes include a overview of Excel's vast collection of formulas...

Microsoft Project is a powerful program that will assist you in managing your projects with ease and efficiency. In this class you will learn how to create update, implement and modify projects.  This class will cover: Organize tasks and milestones with descriptions, durations, and dates in a Gantt Chart View and modify task dependencies in Network...

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,...

The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation, entry techniques, cell references, using the command groups & settings, formulas & functions, charts & graphs and simple database operations. Continuing classes include a overview of Excel's vast collection of formulas and functions. ...

In this three-hour training session, you will learn to create and manage a simple Access database. You will navigate within the Microsoft Access application environment, work in Datasheet view, create a simple database, import data from Excel, and work with records. Version covered: 2016 for Windows Prerequisites This class is ideally suited for...

In this one-day course, you will learn how to write formulas, creating calculated fields, doing math with dates, and writing expressions in queries and validation rules. You will also create sophisticated data entry forms, including navigation forms and subform containers. Finally, you will design reports and subreports, including using variables as...

Microsoft Word still reigns as the world's most popular word processor. Our Microsoft Word classes at AcademyX have been designed to help you build skill and proficiency in Word by providing you with a wealth of sophisticated techniques. Prerequisites: A strong understanding of Microsoft Windows file management Familiarity with the concepts of right-clicking...