Microsoft Excel Professional: Become an Excel Power User

Microsoft Excel Professional: Become an Excel Power User, available at $34.99, has an average rating of 4.05, with 52 lectures, based on 23 reviews, and has 3424 subscribers.

You will learn about Our EXCEL PROFESSIONAL course provides you with a formidable array of skills that will enable you to use Excel at an exceptionally high level The course has its own workbook with exercises – downloadable within the first “Introduction” module – so you can practice and reinforce what you have learned You'll take what you know in Conditional Formatting, LOOKUPs, PivotTables to a whole new level, and be introduced to User Defined Functions (UDFs) using VBA Advanced Conditional Formatting – Editing Standard Formatting Rules – Using Formulas in Conditional Formatting Using Form Controls and Templates – Using Form Controls – Creating Templates Advanced LOOKUP Functions – Using Index & Match Functions – Using Index & Match Together – Using Index & Match with Array Formula – Using the Indirect Functions Advanced Functions in Excel – Using Error Functions – Using Logical Functions – Using Array Formulas – Using Rounding Functions Advanced Pivot Table Tools – Importing Pivot Table Data – Calculated Fields in Pivot Tables – Showing Pivot Data as a Percentage – Creating Custom Styles Introduction to User Defined Functions Using VBA – Creating a User Defined Function – Creating an Interactive Procedure – Create and Share a Function Add-in This course is ideal for individuals who are You may have a solid understanding of, and experience with, Microsoft Excel, and want to become a real power user or Or you may already have many of the skills, but want a "refresher" to tidy up and complete your understanding of them or IMPORTANT NOTE: This is not a technical course, so if you are looking for high level programming content, this isn't for you It is particularly useful for You may have a solid understanding of, and experience with, Microsoft Excel, and want to become a real power user or Or you may already have many of the skills, but want a "refresher" to tidy up and complete your understanding of them or IMPORTANT NOTE: This is not a technical course, so if you are looking for high level programming content, this isn't for you.

Enroll now: Microsoft Excel Professional: Become an Excel Power User

Summary

Title: Microsoft Excel Professional: Become an Excel Power User

Price: $34.99

Average Rating: 4.05

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

• Our EXCEL PROFESSIONAL course provides you with a formidable array of skills that will enable you to use Excel at an exceptionally high level
• The course has its own workbook with exercises – downloadable within the first “Introduction” module – so you can practice and reinforce what you have learned
• You'll take what you know in Conditional Formatting, LOOKUPs, PivotTables to a whole new level, and be introduced to User Defined Functions (UDFs) using VBA
• Advanced Conditional Formatting – Editing Standard Formatting Rules – Using Formulas in Conditional Formatting
• Using Form Controls and Templates – Using Form Controls – Creating Templates
• Advanced LOOKUP Functions – Using Index & Match Functions – Using Index & Match Together – Using Index & Match with Array Formula – Using the Indirect Functions
• Advanced Functions in Excel – Using Error Functions – Using Logical Functions – Using Array Formulas – Using Rounding Functions
• Advanced Pivot Table Tools – Importing Pivot Table Data – Calculated Fields in Pivot Tables – Showing Pivot Data as a Percentage – Creating Custom Styles
• Introduction to User Defined Functions Using VBA – Creating a User Defined Function – Creating an Interactive Procedure – Create and Share a Function Add-in

Who Should Attend

• You may have a solid understanding of, and experience with, Microsoft Excel, and want to become a real power user
• Or you may already have many of the skills, but want a "refresher" to tidy up and complete your understanding of them
• IMPORTANT NOTE: This is not a technical course, so if you are looking for high level programming content, this isn't for you

Target Audiences

• You may have a solid understanding of, and experience with, Microsoft Excel, and want to become a real power user
• Or you may already have many of the skills, but want a "refresher" to tidy up and complete your understanding of them
• IMPORTANT NOTE: This is not a technical course, so if you are looking for high level programming content, this isn't for you