Office Productivity Classes in Online

Learn to create and analyze PivotTable data. Pre-requisite(s): Excel Level 1 Outline: Lesson 1 : Preparing Data and Creating PivotTables Prepare Data  Create a PivotTable from a Local Data Source  Create a PivotTable from Multiple Local Data Sources  Create a PivotTable from an External Data Source Lesson 2 : Analyzing Data...

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

Learn to navigate Outlook 2016 to read and respond to email, use the Address Book, format and spell check new messages, attach files and insert illustrations to messages, customize read and response options, use flags, categories, and folders to organize messages, create and work with Contacts, create appointments and schedule meetings in Calendar,...

Learn Excel data analysis in this hands-on course and expand your ability to analyze large amounts of data and professionally present your results. Gain the knowledge and skills to build more sophisticated spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better...

Learn the basic functions and features of Excel. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting...

Learn to use Excel with our live online webinar. All features A-Z help you pass the Microsoft Certification Exam. 90-100 minutes of lecture with hands on practice and 20 minutes for Questions and Answers Benefits:  Become comfortable with every Excel feature. Save hundreds of dollars compared to other courses. Not recorded videos, live instructor...

The class teaches several algorithms, approaches to solving problems with programming. Before you can use VBA to reconcile two workbooks you need to learn a few programming fundamentals.  Fundamental algorithms include: How to find the last row/column of data in a range. How to locate key columns and use named ranges. How to loop through a scenario....

Photoshop is one of the most widely used software programs in the world. It is utilized for designing logos, brochures, websites, books, re-touching photos, digital art, presentations, content creation, and illustrations, etc. This course is designed to get you up and running and proficient on Photoshop, beginning with an exploration of its interface...

Complete Title: Mastering Excel® PivotTables®: How to Crunch Numbers Like an Expert Save a ton of time as you analyze data quickly and easily! When you need to crunch database-like data, you can only go so far with sorting, filtering, and inserting subtotals. What you need are ways to create summary totals based on multiple criteria and the ability...

Learn essential skills to design, create, and use an Access database in Microsoft Office, including relational database concepts, planning and creating a database, data entry guidelines, and working with forms, queries, and reports. Pre-requisite(s): At least one year experience using Windows 10, 8, or 7 Outline: Lesson 1 : Getting Started Database...

Learn the basic tools and techniques of Adobe Photoshop, the premiere imaging editing program used by professionals in all design disciplines. Gain the confidence to start using this versatile program. Topics include workspace and navigation, tools, selections, layers, color and contrast adjustment, retouching and image compositing. This workshop...

This course will teach you how to create professional layouts for business cards, magazines, pamplets, books & more. You'll learn how to flow text around images, style and format text, add multpiple pages, page numbers, titles, and learn several color and typography concepts for use in your InDesign workflow. Work with master pages, paragraph and...

Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data. Pre-requisite(s): ...

Learn essential skills to create effective PowerPoint presentations including adding charts, tables, and images, plus customizing transitions and creating speaker notes. Pre-requisite(s): At least one year experience using Windows 10, 8, or 7 Outline: Lesson 1 : Getting started The PowerPoint interface Lesson 2 : Creating presentations Creating...

Learn essential and timesaving skills to quickly create, edit, format, and proof business documents using Word. Pre-requisite(s): At least one year experience using Windows 10, 8, or 7 Course Outline: Lesson 1 : Getting Started The Word Window  New documents  Document navigation Lesson 2 : Editing Text Working with text  The...