Micro Learning - Microsoft Excel - Tables

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.

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.

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.

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?