Microsoft Office Classes
Los Angeles
Classes near you
Classes near you
0 classes with availability
Word Beginning: Your First Documents
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 before printing. Prerequisites This class is designed for people who are very new to computers or...
SharePoint for Site Owners
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
SharePoint for Site Owners: Pages, Sites, Permissions and... In this one-day class, you will learn how to administrate Office 365 SharePoint websites, starting with controlling access permissions. You will then learn how to create custom lists, change the design and layout of the home page, and create additional pages, adding text, images, links and apps (web parts). You will also create entire new subsites using the powerful built-in site...
Excel Intermediate 2: Queries, Subtotals & Tables
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will import external data, create simple queries to bring in data from SQL sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting and totals and use AutoFilter to show only rows that meet your criteria. Prerequisites This class is suited for people who have taken Excel levels...
Excel Intermediate 1: Simple Formulas
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This three-hour session teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, PMT and PV, write arithmetic formulas by hand, perform calculations on dates, and parse text strings with the LEFT, MID, RIGHT and SEARCH functions. You will also learn when and why to use absolute referencing (like $A$4) when duplicating formulas. Prerequisites: This class is ideally suited for people with basic Excel...
Excel 2016 (Mac) Session 3
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will learn Excel's data management and summarization tools, which let you turn large amounts of raw data into concise, meaningful reports and charts. This course will let you import external data, convert data into a table, apply automatic totals and use AutoFilter to show only rows that meet your criteria. You will sort by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals....
Excel 2016 (Mac) Session 4
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will learn how to work on multiple worksheets simultaneously. You will also learn how to set up several what-if analysis models using Goal Seek, Scenario Manager and one- and two-input data tables. And for maximum efficiency, you will learn to use styles-based formatting to format worksheet cells globally as well as how to record and edit simple macros. Course Outline Group Mode: Working in Multiple Sheets:...
Excel 2016 (Mac) Session 5
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will create sophisticated charts and complex formulas using functions. You will learn to chart noncontiguous data, create dual-axis charts for comparing vastly disparate data sets, and combine column and areas markers on the same chart. You will learn how to make 3-D charts more effective by controlling the stacking order of the series, and add trendlines to 2-D charts. You will also expand your ability to write complex...
PowerPoint (Mac) Beginning: Effective Presentations
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
PowerPoint (Mac) Beginning: Create Effective Presentations In this class, you will learn how to create effective, engaging presentations using the most efficient techniques available. You will start a new presentation, apply a template or theme, add and import text, and then use Slide Masters to customize backgrounds, color schemes, text formatting and placement of text throughout the entire presentation. Prerequisites This class is designed for...
Excel Beginning 2: Simple Formulas
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This three-hour session introduces you to creating formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, PMT and PV, write arithmetic formulas by hand, perform calculations on dates, and parse text strings with the LEFT, MID, RIGHT and SEARCH functions. You will also learn when and why to use absolute referencing (like $A$4) when duplicating formulas. Prerequisites: This class is ideally suited for people with basic...
Excel (Mac) Basics: Your First Worksheets
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This half-day session introduces you to Excel's interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel's Ribbon-based interface, able to enter and edit labels and values, write basic math formulas, use calculation functions, move and copy entries and duplicate formulas using absolute and relative referencing. Course Outline Introduction to Excel: what can I do with Excel? learning the...
Word Advanced 2: Produce Long Documents
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 for you automatically. Prerequisites This class is ideally suited for people who have attended...
Excel Dashboard Reporting: Intro to Dashboards ..
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Excel Dashboard Reporting: Intro to Dashboards Using Excel A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and troubleshooting skills. The last thirty minutes of the class will be spent addressing specific questions...
Excel Beginning 2: Cell Formatting and Charting
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create and enhance dual-axis and combination charts. Prerequisites: This class is ideally suited...
PowerPoint Beginning: Create Presentations Efficiently
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session for Windows and Mac users, you will learn how to create effective, engaging presentations using the most efficient techniques available. You will start from a blank presentation, apply a design theme, add and import text, and then use Slide Masters to customize backgrounds, color schemes, text formatting and placement of text throughout the entire presentation. Prerequisites This class is ideally suited for people with...
PowerPoint Intermediate: Illustrate Your Presentations
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn how to strengthen the message of any PowerPoint presentation by adding SmartArt graphics, AutoShapes, photos, charts and tables. You will insert clip art and photographic images, remove image backgrounds and optimize images to reduce file size. You will transform plain bullet text into captivating SmartArt graphics and use the built-in drawing tools to create custom illustrations. You will create pie charts...
Excel Tips and Tricks: Essential Time-Saving Techniques
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering! Class Outline Formulas Display Formulas Instead of Results Display Cell Values When Creating or Editing Formulas Highlight All...
Visio Pro 2: Create Process Diagrams and Org Charts
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Upon successful completion of this three-hour course, you will create process diagrams like flowcharts and workflow diagrams and represent an organization hierarchy as a Visio diagram. This course will focus on creating process diagrams and org charts. You will have the opportunity to put all your Visio skills to work in a final exercise under the close guidance of your expert instructor. Course Outline Creating Process Diagrams: Create a fllowchart...
Word Intermediate 1: Tabs, Indents, Graphics & Proofing
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
How your documents look reflects on you, so make them look sharp! In this three-hour session, you will learn how to format paragraphs precisely with indents, tab stops, and line and paragraph spacing, edit text with spell and search-and-replace, and insert professional-looking images and illustrations to strengthen your message. Prerequisites This class is designed for people who have attended our Word Beginning class or who are comfortable performing...
Excel Intermediate 1: Cell Formatting and Charts
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn the most efficient ways to format text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create and enhance dual-axis and combination charts. Prerequisites This class is ideally suited for people...
Excel Pivot Table Workshop
Los Angeles Harbor College Extension See all classes by this school @ 1111 Figueroa Pl, Wilmington, CA
Take advantage of Microsoft Excel’s most powerful tool, the Pivot Table. This class will introduce participants to Pivot Table which will help you to reorganize and summarize your data to create the most visual desired report. This class is perfect for those who use pivot tables, but need additional knowledge, and those who use excel but have yet to explore the pivot table feature. Important: Students must have a basic ability to...