Menu
Menu
Menu
Menu
Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.
No prerequisites for this course
Module 1: Describe the business value of the Microsoft Power Platform
Learn about the components of Microsoft Power Platform, the business value for customers, and how the technology works with other Microsoft products.
Module 2: Identify foundational components of Microsoft Power Platform
Learn about the basics of Dataverse and explore ways you can connect and customize data connections to Microsoft Power Platform applications.
Module 3: Describe how to build applications with Microsoft Power Apps
Learn about the value and capabilities of Microsoft Power Apps and ways citizen and professional developers use this technology to build simple applications for their business.
Module 4: Describe building automation with Microsoft Power Automate
Microsoft Power Automate is all about process automation. Power Automate allows anyone with knowledge of the business process to create repeatable flows that when triggered leap into action and perform the process for them.
Module 5: Describe the capabilities of Microsoft Power BI
Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations and see how other organizations have used this solution to drive business results with actionable insights.
Module 6: Describe complementary Microsoft Power Platform solutions
Learn about the value and capabilities of Microsoft Power Virtual Agents, Power Pages and AI Builder and how organizations can use them to create solutions for their business
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.
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
Topic A: Outlining and Grouping Data
– Using Automatic Outlining
– Displaying and Collapsing Levels
– Grouping Data Manually
– Creating Subtotals
Topic A: Using Data Analysis Tools
– Using a One or Two
– Input Data Table
– Using Goal Seek
Topic B: Exploring Scenarios
– What is a Scenario?
– Creating a Scenario
– Saving Multiple Scenarios
– Creating a Scenario Summary Report
Topic C: Using Solver
– Understanding Solver
– Generating Reports and Scenarios with Solver
– Changing Solver Values
– Managing Solver Constraints
– Using Solver as a Goal Seek Tool
Topic A: Working with Array Formulas
– What are Array Formulas?
– Using Functions within Array Formulas
Topic B: Using the LOOKUP Function
– Using VLOOKUP to Find Data
– Find Exact Match with VLOOKUP
– Find Closest Match with VLOOKUP
– Find with HLOOKUP
Topic C: Alternative LOOKUP Function
– Using the INDEX Function
– Using the MATCH Function
– Combining the MATCH and INDEX functions
Topic D: Linking, Consolidating, and Combining Data
– Linking Workbooks
– Consolidating Workbooks
– Combining Worksheets
Topic A: Create Combo Chart
– Comparing 2 Types of Values with high Variance
– Creating Combo Chart
– Editing Combo Chart
Topic A: Create a PivotTable
– Create PivotTable Dialog Box
– PivotTable Fields Pane
– Summarize Data in a PivotTable
– Show Values as Functionality of a PivotTable
– Personalize the default PivotTable layout
Topic B: Filter Data by Using Slicer
– Slicers
– Insert Slicers Dialog Box
Topic C: Analyzing Data with PivotChart
– Creating PivotChart
– Editing a PivotChart
Topic A: Customizing Workbooks
– Inserting Hyperlinks
– Editing Hyperlinks
– Formatting Hyperlinks
– Using Hyperlinks in Excel
Topic A: Macros
– Recording Macros
– Saving to Macros Enabled Workbook
– Closing and Re-Opening a Macro Workbook
– Security Warning Message
– Playing a Macro
– Assigning a Keystroke to a Macro
Topic A: Protecting Worksheet and Workbook
– Protecting the Current Sheet
– Protecting an Entire Workbook
– File Protection
4.5
Working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations. He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development. He has a strong ability to develop team growth, people skills and technology in a well-organized workforce.
4.5
With 20 years of experience in technical support, I have deep expertise in mobile devices, computer devices, and operating systems. I specialize in Microsoft technology, including Windows, Microsoft 365, Endpoint Management, Azure, and Windows Server 2022. I am also skilled in Android and Chrome OS. My diverse background includes roles in mobile phone repair, multifunction photocopier service, IT sales and refurbishment, IT support, and IT helpdesk industries. Through these experiences, I have developed technical skills as well as valuable soft skills such as communication, public speaking, and team leadership.
FREE QUOTATION!
THIS PUBLIC COURSE INCLUDES
CLASS DETAILS
ALL IN FROM ONLY
RM0/PAX
*T&C Applies
5
5
5
5
5
5
5
4
4
4
4
4
3
3
3
3
2
Live chat, call or email, we’re here for you
Quorse is Asia’s #1 online training marketplace that connects learners with trainers who seek a value-added training experience on a single platform. Discover training courses from diverse categories, ranging from technical IT certifications to personal development programs.
All contents Copyright since 2015. Quorse © Network Mileage Sdn Bhd (874066-V). All rights reserved.
Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly
Sign in with your social account
or
By signing up, you agree to our Terms of Use and Privacy Policy
