Page 15

COMPUTERS

MICROSOFT OFFICE

Transitioning to Office 2016

Explore the new features in Microsoft's newest release of Word, Excel, PowerPoint, and Outlook. Students should have training or experience in a previous version of Microsoft Office. $169

Aug 21            M             9 am-4 pm          NEAST           CEMSO 519 06

 

PowerPoint, Introduction

Your presentations can be show stopping. Create slide shows using PowerPoint's most commonly used features. $289

Aug 2-Aug 3   WTh        9 am-4 pm          NEAST           CEPDP 629 35

 

PowerPoint, Advanced

Import from other applications, create photo albums, share presentations, and create templates. Use multimedia effects including sound and video to produce professional, effective presentations. $289

Aug 30-Aug 31               WTh                      9 am-4 pm    NEAST   CEPDP 650 14

 

Outlook, Introduction

Make the most of your email communications. Learn to work with contacts and distribution lists. Find out how Outlook tasks can help you get organized, and use the Outlook calendar to keep up with your busy schedule. $289

Jul 24-Jul 25  MT           9 am-4 pm          HARBN          CESCH 708 42

Jul 26-Jul 27  WTh        9 am-4 pm          FF         CESCH 708 43

Aug 7-Aug 16 MW          6 pm-9 pm          NEAST           CESCH 708 59

 

Outlook, Advanced

Take your Outlook skills to the next level. Learn how to customize Outlook, automate commonly used actions, work with folders, organize Outlook components, and use the Rules Wizard. $249

Aug 24-Aug 25               Th                         9 am-4 pm    HARBN  CESCH 717 06

                         F              9 am-12 pm

 

Creating a Simple Excel Spreadsheet

Learn to create a simple Excel spreadsheet complete with formats and easy formulas. $89

Aug 18            F              9 am-12 pm        NEAST           CESDS 628 32

 

Excel Formulas and Functions

Work with basic math formulas and progress to conditional, lookups, date and time, financial, statistical, and conversion examples. Protect and hide your formulas and create user-defined functions. $169

Jun 6               T              9 am-4 pm          NEAST           CESDS 630 28

 

Excel Graphs

Graphs are very powerful tools for visually representing your important numeric data. Learn how simple it is to create in
Excel. $89

Aug 28            M             9 am-12 pm        NEAST           CESDS 629 21

 

Excel Macros

Enjoy the efficiency of macros as you learn to record mouse clicks and keystrokes for playback later or to record a sequence of commands you use to perform repetitive tasks in Excel. Get the basics in this class. $89

Aug 21            M             1 pm-4 pm          NEAST           CESDS 640 23

 

Excel Pivot Tables

Learn to use Pivot Tables to summarize large amounts of data and analyze it in a variety of ways. $89

Aug 21            M             9 am-12 pm        NEAST           CESDS 631 26

 

Excel, Introduction

Excel is used in most offices. Learn how to create effective and efficient worksheets using formulas, common functions, formatting, and printing. $289

Jun 14-Jun 15                WTh                      9 am-4 pm    NEAST   CESDS 602 14

Jun 5-Jun 6    MT           9 am-4 pm          HARBN          CESDS 602 15

May 17-May 18              WTh                      9 am-4 pm    HARBN  CESDS 602 16

May 8-May 9  MT           9 am-4 pm          FF         CESDS 602 17

May 22-May 31              MW                       6 pm-9 pm    HARBN  CESDS 602 55

 

Excel, Intermediate

Students will learn more specialized functions, like IF, COUNTIF and DSUM, and they will learn how to more effectively analyze, sort and filter data, create outlines, subtotals, range names, and work with tables. They will learn to display data more visually in charts, Pivot tables, and Pivot charts and work with slicers and templates. $289

Jun 14-Jun 15                WTh                      9 am-4 pm    HARBN  CESDS 610 30

Jul 10-Jul 11  MT           9 am-4 pm          NEAST           CESDS 610 31

Jul 17-Jul 26  MW          6 pm-9 pm          NEAST           CESDS 610 54

 

Excel, Advanced

Students will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines and map data and work with data tables, scenarios, goal seek, and forecasting data trends. $289

Jul 31-Aug 1  MT           9 am-4 pm          NEAST           CESDS 611 39

 

Word, Introduction

Learn everything you need to get started creating and editing documents, formatting, proofing, controlling page setup, and more. $289

Jul 17-Jul 18  MT           9 am-4 pm          NEAST           CEWDP 593 38

Jul 10-Jul 11  MT           9 am-4 pm          HARBN          CEWDP 593 39

Jun 19-Jun 20                MT                        9 am-4 pm    FF           CEWDP 593 40

 

Word, Intermediate

Enhance your proficiency with Word using tables, styles, templates, section breaks and columns. Long document features such as table of contents, indexes, and mail merge will also be covered. $289

Jul 19-Jul 20  WTh        9 am-4 pm          HARBN          CEWDP 594 14

 

Jun 21-Jun 29                WTh                      6 pm-9 pm    NEAST   CEWDP 594 70

 

REGISTER @ MIDLANDSTECH.EDU/training | 803.732.0432 | see page 2