08039356492 xplorerscomputer.training@gmail.com

Microsoft PowerBI

Analyzing Data with Power BI certification course imparts skills and knowledge to analyze, visualize and report data using Microsoft Power BI. Power BI is a suite of tools for Business Analytics that allows corporate users to analyze data and get insights that can help in making the right business decisions. This Power BI training covers the latest tools to monitor business growth and quickly get answers on any device through rich reporting features and dashboards. Learn how to connect and import your data, author reports, publish reports, create dashboards, and share with business users so that they utilize the business intelligence gathered in dashboards through the web as well as mobile devices.

Prerequisite:

NBasic understanding of data analysis is a plus but not required

An email address is required to sign up

Learn to use Power BI Desktop to create queries, data connections, and reports that can easily be shared with others. Through Power BI Desktop learn to integrate proven Microsoft technologies such as the Query engine, data modelling, and visualizations. Discover how to harness Power BI Service to share these connections, models and reports in accessible ways for users to view and interact with on all kinds of devices.

  • Data Analyst
  • Business Intelligence Executives
  • Marketing Executives
  • Software Developers
  • Accountants
  • Statisticians
  • Economists
  • Financial Analysts
  • Introducing the PowerBI Ecosystem
  • Getting Started with PowerBI Desktop
  • PowerBI Desktop and Data Sources
  • PowerBI Desktop to Create Data Models
  • PowerBI Desktop For Visualization Workshop
  • PowerBI Desktop and DAX
  • PowerBI Desktop and Advanced DAX Functions
  • PowerBI Desktop and Queries
  • PowerBI Service Publishing
  • PowerBI Service and Importing Cloudbased Data
  • PowerBI Service and Excel PowerPivote
  • Sharing Data with PowerBI
  • Refreshing Data
  • PowerBI on MObile Device
Training Sessions
Session Days Periods
Daytime Mon-Fri (2hrs) 9am-11am, 11am-1pm, 1pm-3pm, 3pm-5pm
Evening Mon-Fri (2hrs) 6pm-8pm
Weekends Sat (3hrs) 10am-1pm, 1pm-4pm
Duration: 1 Months

Interested individuals can pay using the following methods:

Pay cash or through the bank using the following details

Account Number: 0111553951

Account Name: Xplorers Computer Training School

Bank: GTBank

Full Payment (Attracts 5% discount of Course Fee)

Installmental Payments (First Payment= 60% of Course Fee)

Course Fee: ₦60,000

Advanced Microsoft Excel

Advanced Microsoft Excel is much more than a quick way to add up numbers. In this course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This course also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

Prerequisite:

You are expected to have either completed the stated prerequisite course(s) or possess the basic knowledge prior to enroling in this course:

  • Basic Excel Course
  • Scenario & Sensitivity Analysis

The courses that are covered in this program include:

  • Using Logical Functions
  • Naming Ranges
  • Creating Named Ranges
  • Using Named Ranges In Formulas
  • The IF Function (Recap)
  • Creating Nested IF Functions
  • AND and OR Functions
  • Combining Logical Functions
  • Working with Lookups
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Advanced List Management
  • Using Data Validation
  • Setting Criteria for entry of Text, Values, and Dates
  • Creating a Dropdown List
  • Using Database Functions
  • Setting up Criteria
  • DSUM
  • DCOUNT
  • Pivot Tables and Pivot Charts
  • Using Slicers to Manupulate Pivote Tables
  • Using Goal Seek
  • Using the Solver Add-in
  • Working With Scenarios
  • Creating and Saving Scenerios
  • Viewing Scenarios
  • Macros
  • Business Analyst
  • Administrative Assistants
  • Secretaries
  • Marketing Managers
  • Project Managers
  • Accountants
  • Financial Analysts
  • Job Seekers or anyone that is required to work with computers on a day-to-day basis.
Training Sessions
Session Days Periods
Daytime Mon-Fri (2hrs) 9am-11am, 11am-1pm, 1pm-3pm, 3pm-5pm
Evening Mon-Fri (2hrs) 6pm-8pm
Weekends Sat (3hrs) 10am-1pm, 1pm-4pm
Duration: 1 Months

Interested individuals can pay using the following methods:

Pay cash or through the bank using the following details

Account Number: 0111553951

Account Name: Xplorers Computer Training School

Bank: GTBank

Full Payment (Attracts 5% discount of Course Fee)

Installmental Payments (First Payment= 60% of Course Fee)

Course Fee: ₦30,000

© Xplorers Computer Training School 2019
Designed by Emmatech Digital World