Microsoft Excel Professional

[voska89]

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 4.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.

Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

Download (Uploadgig)
https://uploadgig.com/file/download/f35eb14F890F3dc6/9wlhu.Microsoft.Excel.Professional.part1.rar
https://uploadgig.com/file/download/6a84Ace1fa2456c1/9wlhu.Microsoft.Excel.Professional.part2.rar
Download ( Rapidgator )
https://rapidgator.net/file/1935357444757784e8715d9da1adb9a4/9wlhu.Microsoft.Excel.Professional.part1.rar
https://rapidgator.net/file/653b86f3bc9208af1128f220ec4ffbc0/9wlhu.Microsoft.Excel.Professional.part2.rar
Download ( NitroFlare )
http://nitroflare.com/view/87E48ACBEF6E032/9wlhu.Microsoft.Excel.Professional.part1.rar
http://nitroflare.com/view/C85D9B19873B16F/9wlhu.Microsoft.Excel.Professional.part2.rar