Brief Introduction
Learn Microsoft Excel Advanced from Microsoft Certified TrainerDescription
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation and Intermediate Level; OR
- Able to use and apply Database function
- Able to use and apply Logical function (IF, AND)
- Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
- Able to use and apply Mathematical function (SUMIF, SUMIFS)
- Able to use and apply Lookup function (VLOOKUP)
- Able to use Auto and Advanced Filter command
- Able to validate data
- Able to apply Conditional Formatting
- Able to Protect worksheet and workbook
Upon completion of this program, participants should be able to:
- Advance Chart function and PowerPivot Function
- Analyze data Using Pivot Tables
- Perform What If Analysis using:
- Goal Seek
- Solver
- Input Table
- Scenarios
- Use VLOOKUP function to extract data
- Nesting INDEX and MATCH Function
- Combining & Consolidating Data
- Create Hyperlink in a workbook
Requirements
- Requirements
- You should be able to use Microsoft Excel at a intermediate level
Power BI Masterclass - beginners to advanced
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Microsoft Power BI How to learn Power BI fast. The best Power BI Training online for beginners. Best Master Class Microsoft Power BI in 6 hours beginners to advanced...
Selenium WebDriver: A Step by Step Guide to Test Automation
- 2.9
-
![]()
![]()
![]()
![]()
![]()
Master Automation Testing via Selenium WebDriver, TestNG, Selenium Testing Framework, Robot framework, Cucumber & Java The average salary of Selenium Automation Engineer as per Indeed Salary Data is $94000...
Power BI Master Class - Query Editor [2021 Edition]
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI Students who have taken this course have this to say:...
Managing Big Data with MySQL
- 4.7
-
![]()
![]()
![]()
![]()
![]()
This course is an introduction to how to use relational databases in business analysis. About this Specialization and Course About this Specialization...
