Microsoft Excel Professional

MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.74 GB
Becoming a Professional user of Microsoft Excel

What you’ll learn

This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010, 2013 or 2016 in order to further increase their knowledge and productivity.

Requirements

Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

Description

MODULE 1: Advanced Conditional Formatting

Learning outcomes: Looking at the more advanced Conditional Formatting features and how to manage them effectively.

Topics covered:

Editing Standard Formatting Rules

Using Formulas in Conditional Formatting

MODULE 2: Using Form Controls and Templates

Learning outcomes: Introducing Form controls and using them to manage user interaction to help ensure they enter/search for information both accurately and effectively.

Topics covered:

Using Form Controls

Creating Templates

MODULE 3: Advanced Lookup Functions

Learning outcomes: An in-depth look into Excel’s specialist lookup functions and the concept of arrays.

Topics covered:

Using the Index Function

Using the Match Function

Using Index and Match Together

Using Index and Match with Array Formula

Using the Indirect Function

MODULE 4: Advanced Functions in Excel

Learning outcomes: Effectively using Error, Logical and Rounding functions along with array formulas.

Topics covered:

Using Error Functions

Using Logical Functions

Using Array Formulas

Using Rounding Functions

MODULE 5: Advanced Pivot Table Tools

Learning outcomes: How to import Pivot Table data from external source along with adding custom fields and formulas.

Topics covered:

Importing Pivot Table Data

Calculated Fields in Pivot Tables

Showing Pivot Data as a Percentage

Creating Custom Pivot Tables Styles

MODULE 6: Introduction to User Defined Functions Using VBA

Learning outcomes: Using VBA to create specialist procedure and to define your own Excel functions.

Topics covered:

Creating a User Defined Function

Creating an Interactive Procedure

Create and Share a Function Add-in

Who this course is for:

Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010, 2013 or 2016 who want to increase their ability in a short space of time.

Password/解压密码-0daydown

Download rapidgator
https://rg.to/file/2fa11eafe082f85f99089eb4fb51ed68/Microsoft_Excel_Professional.part1.rar.html
https://rg.to/file/18336bc49c500c6fc6d8205e0482b4c8/Microsoft_Excel_Professional.part2.rar.html
https://rg.to/file/28e41cdb507dd0ea8bbed1dce296fe72/Microsoft_Excel_Professional.part3.rar.html
https://rg.to/file/5506472e910b64d86346e4c6b17d0646/Microsoft_Excel_Professional.part4.rar.html

Download nitroflare
http://nitroflare.com/view/F862E8C41528B39/Microsoft_Excel_Professional.part1.rar
http://nitroflare.com/view/0D670B93A6D2C53/Microsoft_Excel_Professional.part2.rar
http://nitroflare.com/view/FF2B063500642A2/Microsoft_Excel_Professional.part3.rar
http://nitroflare.com/view/D442FDC696A55A5/Microsoft_Excel_Professional.part4.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员，