Power Excel One Course

This Virtual course is designed to equip you with the much-needed techniques as well as methodology for working with Excel, and exposes how the Excel application really works. The course highlights many shortcuts, tips and tricks to make you more productive and efficient on the job you do. This course has 126 Lessons which you would need to cover within a study time not less than 28.5 hours.

Buy now $500 BUY NOW ₦ 172,000 Free Preview

DOWNLOAD BROCHURE

Course Description

Identify and Recall the new features and shortcuts in the latest versions of Excel.
Demonstrate general Excel spreadsheet skills by working with tabs, ribbons, dialogue boxes, Excel options and formats.
Interpret exactly how the Excel engine works and use this knowledge in proffering solution to case studies.
Employ formulas, functions and data tools to perform simple data analysis.
Build simple yet dynamic templates for “on the job use” .
Reporting with pivot tables.

Course curriculum

1. Virtual Course Overview
  FREE PREVIEW
2. Power Excel 1 (the Essentials)
3. How to use our Virtual Training Platform on GoToTraining
4. Download Course Manual
5. Your Expectations
6. Ask the Trainer
  FREE PREVIEW
1. How Excel Works
2. Introduction to Formatting in Excel
3. Excel Formatting Syntax
4. Reporting Framework & the 7 Golden Rules of Data
5. The role of the Control & Report Sheets
  FREE PREVIEW
6. Managing Dates, Validations & Format Styles
7. Basic Excel Chapter Quiz
1. Download the Exercise Files
2. Overview of lookup Functions
3. The VLOOKUP Function
4. The MATCH Function
5. MATCH Function to the rescue of the VLOOKUP function
6. The HLOOKUP Function
7. MATCH Function to the rescue of the HLOOKUP Function
8. VLOOKUP Hidden Feature part 1 of 2
  FREE PREVIEW
9. VLOOKUP Hidden Feature part 2 of 2
10. Using INDEX
11. Using INDEX & MATCH
12. Using OFFSET
  FREE PREVIEW
13. Using OFFSET & MATCH
14. Using CHOOSE
15. Lookup Functions Chapter Quiz
1. Get Data with Power Query
2. Lab - Get Data with Power Query
3. Getting External Data Into Excel
4. Connect To Excel Files in a Folder
5. Consolidate Excel Work Books
6. Transforming Data Types
7. Loading Your Query to Excel
8. Power Query Chapter Quiz
1. Report Building Blocks
2. Lab - Report Building Blocks
3. Simple Report Template
4. Identify your Report Criteria
5. Automate with SUMIFS
6. SUMIFS and the Date Criteria Hack
7. Reporting Building Blocks Chapter Quiz
1. Download the Exercise Files
2. 5 ways of Reporting in Modern Excel.mp4
3. 5 Reasons to use PivotTables
4. Understanding 7 Golden rules of Data
5. Overview of PivotTables
1. Working with the Excel Table Tool
2. Planning your PivotTable reports with Fields List
3. Creating a simple PivotTable Report
4. Using PivotTable recommendations
5. Designing a PivotTable Report
6. Managing dates in PivotTables
7. Creating weekly Report with PivotTables
1. Showing Percentage Calculations in PivotTables
2. Creating Running Total Calculations in PivotTables
3. Filtering a PivotTable with slicers
4. Sorting a PivotTable Report
1. Download Exercise File
2. Build a smart Dashboard with Pivot Charts
3. Planning your Pivot Chart Dashboard Build
4. Building a Simple Chart Based on a Plan
5. Adding Data Labels to your Pivot Chart
6. Inserting Modifying Slicers in Pivot Charts
7. Comparing Monthly Performance with Pivot Charts
8. Smart Formatting Tricks for Pivot Charts
9. Finalising your Pivot Chart Dashboard
10. Using AI for extract insights from your Data
1. Introduction
1. PE1 Files
2. Content Overview
3. Download Exercise Files
4. Session_01 Assignment
1. Content Overview
2. Download the Session's Files
3. Session Assignment (applying VLOOKUP Function in Excel)
1. Content Overview
2. Session Assignment
1. Content Overview
1. Instructions
2. More resources for you
3. 50 Excel Keyboard Shortcuts for Mac
4. 50 Excel Keyboard Shortcuts for Windows
5. Changing your default currency symbol to ₦ - Naira (1 of 2)
  FREE PREVIEW
6. Changing your default currency symbol to ₦ - Naira (2 of 2)
  FREE PREVIEW
7. Evaluate & get your Certificate
8. How to Attach your Certificates to your LinkedIn Profile

About this course

$500.00
88 lessons
4 hours of video content

Other Course Start Dates

live sessions delivered via GoTo Training

Starting 15 Mar 2021

Registration Options

dbrownconsulting, Virtual Training Methodology

Watch Intro Video

Video

FAQ

How does Virtual Training Work?

You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.
How long is each Virtual Session?

Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.
How long do I have access to the course content and platform?

You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.
Can I defer my Session?

Deferral requests are treated on a case by case basis. Please email [email protected] with your request.
Are the videos available offline?

Our videos are only available for streaming online. But you can download all exercise files and materials.

Your Instructors

With over 100 completed training

Adewale Yusuf

Microsoft MVP & MCT

[email protected]

Adewale is a Microsoft Most Valuable Professional (MVP) in the Data Platform and a Microsoft Certified Trainer (MCT) in Business intelligence and analysis, among other certifications he is a Microsoft certified Solution Associate and a Microsoft Certified Power Platform Functional Consultant. Wale facilitates our Data Analytics courses including, Excel, Office 365, Power BI, Power Apps and Advanced Presentation Skills. He is passionate about impacting knowledge to the community and currently leads many usergroups and communities driving Data Analytic Competencies.