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.