ACPEN: K2’s Microsoft Power Tools

Overview

Unlock the full potential of your Microsoft 365 subscription with our exclusive session on Microsoft's Power Tools! Discover the incredible capabilities of Power BI, Power Query, Power Pivot, and Power Automate, and learn how these tools can revolutionize your productivity and efficiency.

Many professionals are unaware that they already have access to these powerful tools, leading to missed opportunities and suboptimal performance. Don't let this be you! Participate in this session to explore the practical applications of these tools and elevate your productivity and internal control structure to new heights

Highlights

• Creating effective dashboard-style reports using Power BI
• Using Power Query to access and manipulate data, specifically for reporting purposes
• Taking advantage of Power Pivot to build reports from large quantities of data
• Automating routine tasks for improved efficiency and accuracy

Prerequisites

Fundamental knowledge of computer operations

Designed For

Business professionals seeking to elevate productivity and internal controls by taking advantage of Power BI, Power Query, Power Pivot, and Power Automate

Objectives

• Identify opportunities to improve internal controls and efficiency using Power Automate
• Compare reporting options available in Power BI
• Differentiate between conventional PivotTables and those create using Power Pivot
• Identify examples of data manipulation techniques using Power Query 

Preparation

 None