Microsoft Office Intensive - Interm. & Advanced Users

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

In our Intermediate Word class students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with SmartArt graphics and drawing tools. They will also use document templates, manage document revisions, and work with Web features. Course Outline...

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Learn to perform mail merges. Create forms and master documents that include a table of contents; table of figures; footnotes; endnotes; and more. Create macros, customize the ribbon and Quick Access toolbar. Course Content Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 1 teaches basic skills to create, edit, and format texts. Students must have MS Office Word software installed on their computer. Previous knowledge or experience: Understanding of the basics of Windows Note: Class time...

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Target Student This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisites Basic Windows, keyboarding and mouse skills. Course Outline Getting Started Starting Excel Opening...

These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on...

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management...

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Overview Microsoft Teams is the hub for teamwork in Office 365. This course will provide an overview of how to use features within Teams such as chat, online meetings, calls and more. Learn the core features of Teams and how it relates to other Office 365 apps to make your team more productive. Audience profile The course is for team members and...

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!

This course is intended for people who have a basic understanding of Microsoft® Windows® and want to know how to use Outlook’s advanced features to manage their email communications, calendar events, contact information, search functions, and other communication tasks. This course is also designed for students who are preparing for the Microsoft...

Office 365 is Microsoft’s cloud based collaborative suite of apps. Outlook on the web is the app that handles email, Appointments, meetings, contacts, and tasks. In this course you will learn the features of Outlook being used purely in a web browser. While Outlook on the web synchronize with the desktop app, this course will focus only on the web...

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks Viewing,...

Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.

Whether you are in business, management, or simply interested in getting more organized, this Excel Bootcamp will cover the tools and functions you need to automate and enhance the way you analyze and restructure your data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of course, leveraging the ultra-powerful...