Microsoft Office

Course starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Many people are afraid of PivotTables, but in this workshop, we’ll quickly have you building your own PivotTables with confidence. Once you understand the key ingredients of a PivotTable, you’ll wonder what all the worry was about. Excel PivotTables are one of the most powerful tools at our disposal, and once you understand how they work, they’re actually quite easy to insert and modify. Forget Filters and Subtotal, Excel PivotTables can do both of these and more in a few seconds.

This FREE Webinar is designed primarily for Decision Makers to get first-hand examples of the benefits of our Product Knowledge Microsoft Office applications training, focusing on features that should be in common use in a day-to-day functioning role in a business environment. Be prepared to learn something new!

Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets. Instruction will be presented for version 2016. Students have the option to attend the course using Microsoft Excel 2013, or Microsoft Excel 2016.

This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, visualize your data with charts.

To provide Managers an avenue to learn among their peers those much needed skillsets to manage and extract data from worksheets within a minimum timeframe. Understand how to customize the Quick Access toolbar, (re)design worksheets for maximum manipulation and extraction of data in filtered, graphical or print format. Understand how to write and use formulas to achieve specific results.

This course are for the those persons who work with large worksheets in terms of the quantity of recorders (rows), review worksheet design, functions and formulas, create and use of Range Names, and working with VLOOKUP.

This evening instructor-led course provides students with the knowledge and skills to work with a computer system. This course focuses on the key aspects of a computer system and the features of various Windows operating systems. In addition, this course offers the students the skills/knowledge to work with Microsoft Word 2016 and Microsoft® Excel 2016 . The most current version of Microsoft Office will be used.

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee more in annual salary than uncertified peers.

This course is for those who have never used a computer and those who have some computer experience but no formal qualification proving their knowledge or skills. Participants will learn introductory topics in areas such as Microsoft Windows 7 and the Internet; how to create documents and spreadsheets send email and back-up files. Introduction to Microsoft Word & Microsoft Excel for users with no previous knowledge, or limited experience in the use of these applications.

At the end of this course you will have a complete understanding of the higher functions of Excel and be able to perform advanced formula, work with data functions, analysis large spreadsheets using advanced PivotTables, Auditing and Scenarios. This course provides an introduction to Macros.

Conditional formatting is a feature in excel spreadsheet that allows you to apply specific formatting to cells/range that meet the specified criteria/condition. Mostly formatting rule is used as color-based formatting to highlight or distinguish among data and information stored in an excel sheet.

This VBA Programming for Excel training course is designed to give experienced Excel users 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.

There are two basic ways to perform calculations in Excel: Formulas and Functions. Formula vs Function A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application. Microsoft Excel has over 500 built-in functions. Which ones do you need to know?

Candidates will expand and prove technical skills by demonstrating how to customize the Outlook user interface format message content, create or insert graphic elements, and send and respond to emails and meeting requests. They can also manage and share multiple calendars, schedule meetings and appointments, create contact records and tasks, and set up contact groups to facilitate communication with other Outlook users. Earning this certification demonstrate the correct application of the principal feature

In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style. This course is the first in a series of two Microsoft Office Outlook 2019 courses. It will provide you with the basic skills you need to start using Outlook 2019 to manage your email communications, contact information, calendar events, tasks, and notes.

In this course, you will configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you'll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

This FREE Webinar is designed primarily for Decision Makers to get first-hand examples of the benefits of our Product Knowledge Microsoft Office applications training, focusing on features that should be in common use in a day-to-day functioning role in a business environment. Be prepared to learn something new!

This course helps any manager to definitively understand the Microsoft PowerPoint different views, their usage, techniques and templates to successfully create corporate presentations. This is a hands on course, and participants are encouraged to bring their own laptop to the training.

This course gives those with little or no experience of working with Microsoft PowerPoint a good understanding of the package. Learn to create a structured presentation featuring text, colour, graphics and animation. You will also learn how to deliver dynamic, professional presentations.

Business depends on EFFECTIVE COMMUNICATION. Presentations and style can win or lose business. Can you depend on your team to perform to their very best when presenting to important clients? This programme, designed to deliver a professional presentation, on a technical and personal level, and is offered to your company in order to make your presentations memorable. Identify areas for development and empower delegates by raising their levels of consciousness, and equipping them with key presenting skills.

This course is for persons wishing to take the Microsoft Office Specialist (MOS) PowerPoint exam.

This hands-on interactive training course will show you how to create effective PowerPoint presentations that display content in a meaningful and professional way. With this course you will feel more confident with the everyday and advanced tools to allow you to save time on creation, whilst allowing your presentation to be memorable and stand out from the crowd. You will learn how to work with the Outline View, Advanced Linked Graphics and Charts, Managing Multiple Masters, Design Templates, Timed and norm

In this Microsoft Publisher 2019 training course, participants learn to perform basic tasks in Microsoft Publisher, including how to add content, format and manage text, work with graphics and how to prepare a publication for sharing and printing. This course will be customized to be delivered in a one-day format covering essentials.

This SharePoint 2013 End User class is for end users working in a SharePoint 2013 environment. The course teaches SharePoint basics such as working with lists and libraries as well as basic page customizations.

Tables are a great way to display information for your readers. For example, let's say that you want to display textual data or numbers. A table will allow you to display this info in a rectangular structure that is visually appealing and easy to read and understand. In this workshop, you'll learn how to add and manage tables in a Microsoft Word document. We'll be using the 2019 version of Microsoft Word. Keep in mind that certain steps might be slightly different if you use an earlier version of the pro

Microsoft Word is an incredibly powerful program, but getting at that power may not be as easy or intuitive as you might like. It is frustrating when you know you should be able to do something with the program but can't, for the life of you, figure out how to do it. This Workshop is designed to help you figure out how to do the things you need to do with Microsoft Word, right now! Here you can find answers to your Microsoft Word questions.

Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

Go way beyond basic mail merge commands. Unlock mail merge properties you can’t get to with Word commands alone and closely target your message to recipients.

This course is designed for users who wish to improve on their existing Word skills to produce more professional documents and collaborate with other Microsoft Applications.

This workshop provides comprehensive information on document formatting options in Microsoft Word. Over 30 years accumulated experience writing Word documents, flyers, certificates, signs and more packed into this 2 hr workshop.

This course is for those who have never used a computer and those who have some computer experience but no formal qualification proving their knowledge or skills. Participants will learn introductory topics in areas such as Microsoft Windows 7 and the Internet; how to create documents and spreadsheets send email and back-up files. Introduction to Microsoft Word & Microsoft Excel for users with no previous knowledge, or limited experience in the use of these applications.

Engage. Instruct. Empower. MOS certification gives people the power and the tools to chart their own course, fulfill their ambition, realize their potential. MOS 2013 Badging All candidates who achieve MOS 2013 exam certification earn a digital badge that is awarded for display in résumés, emails, and social media profiles.

This evening instructor-led course provides students with the knowledge and skills to work with a computer system. This course focuses on the key aspects of a computer system and the features of various Windows operating systems. In addition, this course offers the students the skills/knowledge to work with Microsoft Word 2016 and Microsoft® Excel 2016 . The most current version of Microsoft Office will be used.

The most productivity tips and techniques for accomplishing routine daily tasks. This course is designed to benefit existing users of Microsoft Word who wish to build on their existing knowledge, learn shortcuts and quicker ways of working with documents.

Microsoft Word is used in businesses and organizations throughout the world to create professional documents such as letters, reports, newsletters and handbooks.

This FREE Webinar is designed primarily for Decision Makers to get first-hand examples of the benefits of our Product Knowledge Microsoft Office applications training, focusing on features that should be in common use in a day-to-day functioning role in a business environment. Be prepared to learn something new!

This course is designed for users who wish to improve on their existing Word skills to produce more professional documents and collaborate with other Microsoft Applications.

Microsoft Word is used in businesses and organizations throughout the world to create professional documents such as letters, reports, newsletters and handbooks.

Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets. Instruction will be presented for version 2016. Students have the option to attend the course using Microsoft Excel 2013, or Microsoft Excel 2016.