Course Duration – 1 day Prerequisites – This course assumes that you are already a confident SharePoint End User. You should be comfortable with the topics that are covered on our SharePoint End User course. Subject Areas – Introduction SharePoint Online overview SharePoint roadmap Office integration points Site hierarchy Building/maintaining SharePoint pages Wiki pages Page … Continued
Course Duration – 1 day Course Subjects Excel Charting Concepts Understanding chart terminology – Identifying chart elements (such as like plot area, chart area, gridlines, and legends) – Selecting the right chart type – Understanding the Ribbon and the Design, Layout, and Format tabs Creating Basic Charts Quickly – Selecting data to display as a … Continued
Course Duration – 1 day Course Subjects:- Overview Power Query Editor and basic transformations Quick insights and data quality & distribution Connecting to multiple data sources Load data into Excel from Multiple Sources such as SharePoint, csv, Web, and even Email Refresh Data and Power Query Refresh options Common Transformations Split Columns (e.g. by delimiter, … Continued
Course Duration: 2 days Prerequisites: It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Introduction, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing … Continued
Course Duration: 1 day Overview: With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows you to then produce detailed reports through a comprehensive range of visualizations. The reward is to then be able to share those reports with … Continued
Course Duration: 1 day Overview: DAX, or Data Analysis Expressions, is the language that’s used to create formulas for Power BI that extend our data model. DAX gives us the ability to create additional information at runtime so that we can quickly and easily generate new information beyond the information that’s in our model already. … Continued
This 2-day course takes experienced Power BI users to the next level in data analytics. Through hands-on excercises, you’ll master integrating Power BI with Azure to handle robust datasets and execute complex data transformations using Power Query’s M language. Level up your data modelling skills by implementing star schemas, optimising relationships, and configuring aggregate tables. … Continued
Overview – This two-day course goes beyond just the basics and includes a comprehensive look at using Power BI Desktop, as well as Microsoft’s Power BI Pro online service. With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows … Continued
Target students Existing users of 2010 who are converting to Office 2016. Course Content General Office Changes Navigate the Microsoft Office 2016 screen Find the commands they commonly use Customise the Quick Access Toolbar and Ribbon Be aware of the new features in Excel, Word, PowerPoint and Outlook Create charts and SmartArt graphics Save files … Continued
Course Summary In this course, you’ll learn fundamental skills while creating several types of diagrams using Microsoft Office Visio Professional. You will create a directional map, a block diagram, a basic and a cross-functional flowchart, an organization chart, and an office layout. As you create these drawings, you will learn techniques to drag and manipulate … Continued