Microsoft Office (DPT)

Courses

DPT 7870. Word Advanced Tools. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Advanced tips and tricks essential for the office or home. Microsoft Word is simple to use until you run into problems that won't go away. This class will show users the tools in Word that let you take control and prevent problems. Learn how to use styles to build interactive documents. Store text and graphics so you can reuse them in other documents. Take control of bullets and numbering. Use mail merge to create custom filled form letters and more.

DPT 7871. Word Form Creation. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Forms are easy to create in Word once you know the tricks. Learn the tricks to create forms that allow users to tab from field to field as well as how to automate the entry of repeated data into large documents.

DPT 7890. Excel VLOOKUP. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

VLOOKUP is one of Excel's most useful functions, and it's also one of the least understood. In this workshop you will learn how VLOOKUP works with database tables, or more simply, lists of things in an Excel worksheet. Use VLOOKUP to match two lists and quickly find the data you want which will make working with data easy.

DPT 7891. Excel Pivot Tables. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Don't be tortured by bad data any longer! In this workshop, you will learn the ins and outs of PivotTables, how to connect your PivotTable to multiple data sources and how easy it is to create summary cross-totals by simply clicking and dragging.

DPT 7892. Excel Automation Tools. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

You use Excel 40 hours a week, but do you really know how to unleash its power? In this workshop, you will learn some automation tools that can make your work easier to do and enhance what you do. Work with named ranges, tables, slicers, and nested formulas to see how data can be manipulated and massaged in Excel.

DPT 7893. Excel Power Formulas. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Use Excel power formulas to get the job done in a better and improved way! In this workshop, you will learn a wide variety of excel formulas which will enhance your work tools, such as the text function suite, date and time.

DPT 7894. Excel Macros. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

In this workshop, you will learn what macros are, how to access them, some programming theory and how to record macros. Stop doing time-consuming tasks where you do the same thing over and over, instead learn how to create macros to automate your common tasks.

DPT 7895. Excel Dashboards. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Data is boring unless you know how to make it "pop" and come alive for the stakeholders. In this workshop, you will learn how to turn your data and pivot tables into interactive dashboards that show the key data you need others to see.

DPT 7897. Excel Macros In Depth. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

In this workshop you will learn to create, run, and debug macros. Stop doing time-consuming tasks where you do the same thing over and over, instead learn how to create macros to automate those repetitive tasks. Participants will also learn how to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share macros with other users.

DPT 8014. Excel Basic. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

CPCC login and textbook required. Required: DPX 7000 or equivalent knowledge. Learn the most sought after business productivity tool used by companies today! Begin with the basic operations of Excel which include understanding key concepts, working with the ribbon, backstage as well as basic formulas and functions.

DPT 8015. Excel Intermediate. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

In this course, you will work on real-world problems like the ones you encounter in the work environment. Learn how to format and manage worksheets, and create ranges to manipulate your data with macros and functions. Create analytical and financial reports and begin building a workbook cross-referencing multiple worksheets. This is the second course out of 3 that maps to the MOS Excel certification exam.

Corequisites: Take DPT 8014 with a minimum grade of S

DPT 8035. Excel Advanced. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

In this course, you really see the power of Excel at work and become more efficient and productive crunching numbers with VLOOKUPS, pivot tables and charts. In this class you will also learn how to secure and share your workbooks, and do a final project to prep for your MOS. This is the final course that maps to the MOS Excel certification exam.

Corequisites: Take DPT 8015 with a minimum grade of S

DPT 8410. Installing and Configuring Windows Server 2012 R2. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Get hands-on instruction and practice installing and configuring Windows Server 2012, including Windows Server 2012 R2. This course focuses on the initial implementation and configuration of core services, such as Networking, Storage, Active Directory Domain Services (AD DS), Group Policy, File and Print Services, and Hyper-V. This course maps directly to the Microsoft Certified Solutions Associate (MCP). Register no later than 14 days prior to class to allow for ordering textbook.