Data Analysis and Visualization with Microsoft Excel

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

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.

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?