Micro Learning - Microsoft Excel - Mastering Lists and Databases

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.

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.

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 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.

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!

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.

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.

Less than 2% of Excel users are making use of the huge efficiency gains available with Excel Tables, which is crazy because Tables are dead easy to use and they automate time saving techniques like: • Dynamic named ranges that automatically update formulas, PivotTables and charts • Formatting, like banded rows or columns • Sorting and filtering • Totals and statistics

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.

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 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.

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.

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?