At PetroPlays International, we run an on-demand skill acquisition and talent development platform for job readiness, where we've helped students and professionals gain valuable and practical skills needed to propel their careers.
Our Courses are Internationally recognized and our Certificates are CPD Verified. Accredited CPD training means that the learning you have undertaken has met the required standards and benchmarks as dictated by the CPD Group Certification Service. This ensures that the value of what you’re learning is of the utmost quality, and is globally recognised.
This is an opportunity to learn from top professional experts and earn a CPD verified certificate. Don’t miss this opportunity.
Microsoft Excel is one of the most influential and popular data analysis software applications around the world. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought-after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
The Excel Analysis and Dashboard Reporting course cover some of the most popular data analysis Excel functions and Dashboard tools.
Microsoft Excel is one of the most used Math software packages in the world. It is an extremely powerful tool and easy to use once the user knows how to perform the many functions available. Excel is still the most popular tool used by analysts in all industries, across all roles. It is used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.
Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you will be able to apply your knowledge to a broad range of software applications. Whether you are starting from square one or aspiring to become an absolute Excel power user, you have come to the right training platform. Everything in the course is taught step-by-step in an easy, stress-free way.
Welcome Message (READ IT CAREFULLY)
Introduce Yourself
Training Requirement
Training Instructions:
Software Download and Instructions
Course Files for Practical Session
Course Outline / Content Video Course
1. Microsoft Excel Fundamentals Video Course
2. Entering and Editing Text and Formulas Video Course
3. The structure of an Excel Function Video Course
4. Modifying an Excel Worksheet Video Course
5. Formatting Data in an Excel Worksheet Video Course
6. Inserting Images and Shapes into an Excel Worksheet Video Course
7. Creating Basic Charts in Excel Video Course
8. Printing an Excel Worksheet Video Course
9. Working with Excel Templates Video Course
Course Outline / Content Video Course
1. Working with an Excel List Video Course
2. Excel List Functions Video Course
3. Excel Data Validation Video Course
4. Importing and Exporting Data Video Course
5. Excel PivotTables Video Course
6. Working with Excel's PowerPivot Tools Video Course
7. Working with Large Sets of Excel Data Video Course
Course Content / Outline Video Course
1. Working with Excel's Conditional Functions Video Course
2. Working with Excel's Lookup Functions Video Course
3. Working with Excel's Text Based Functions Video Course
4. Auditing an Excel Worksheet Video Course
5. Protecting Excel Worksheets and Workbooks Video Course
6. Mastering Excel's What If Tools Video Course
7. Automating Repetitive Tasks in Excel with Macros Video Course
Course Content / Outline Video Course
1. Course Introduction and Overview Video Course
2. Project 1 Using Excel's Macro Recorder Tool Video Course
3. Excel VBA Concepts Video Course
4. Project 2 Moving Beyond the Basics and Into VBA Video Course
5. Project 3 Preparing and cleaning up Data with a little VBA Video Course
6. Project 4 Using VBA to automate Excel Formulas Video Course
7. Project 5 Bringing it all together and create a weekly report Video Course
8. Project 6 Working with VBA Forms Video Course
9. Project 7 Importing Data from Text Files Video Course
Section 1: Getting Started Video Course
Section 2: Analyzing Data Effectively with Microsoft Excel Video Course
Section 3: Building the Excel Dashboard - LOOK UP DATA - Part 1 Video Course
Section 4: Building the Excel Dashboard - FILTERING DATA - Part 2 Video Course
Section 5: Building the Excel Dashboard - SUBTOTALS - Part 3 Video Course
Section 6: Building the Excel Dashboard - PivotTables and Pivot Charts - Part 4 Video Course
Section 7: Building the Excel Dashboard - Interactive Buttons - Part 5 Video Course
Section 8: Building the Excel Dashboard - Final Touches - Part 6 Video Course
A Sample of the certificate you will recieve after completing the course. Your certificate will be generated immediately after your course completion. Download and then Share.
The course was well explanatory and eye opening
The course was well explanatory and eye opening
Read LessThe course is very impactful and educating. I have really learnt a lot in the course. Thanks to PetroPlays International.
The course is very impactful and educating. I have really learnt a lot in the course. Thanks to PetroPlays International.
Read LessTaking this course has improved my career positively and its an added advantage.
Taking this course has improved my career positively and its an added advantage.
Read LessPetroplays Excel Class is one of best online class I have attended so far
Petroplays Excel Class is one of best online class I have attended so far
Read LessThank you for making me skill up.
Thank you for making me skill up.
Read LessThis is a very simplified, instructional and clear learning process. Getting to work on things myself others is very encouraging. I have learnt a lot from the lessons
This is a very simplified, instructional and clear learning process. Getting to work on things myself others is very encouraging. I have learnt a lot from the lessons
Read LessTraining was explanatory and direct....very apt and crystal.
Training was explanatory and direct....very apt and crystal.
Read LessFollow this steps to register and get enrolled into the course.
CLICK ON THE BUTTON TO REGISTER
RECEIVE A CONFIRMATION MAIL TO COMPLETE REGISTRATION
GET ENROLLED ON THE LEARNING PORTAL AND COMPLETE THE COURSE
TAKE THE QUIZ ASSESSMENT
GET ACCESS TO YOUR CERTIFICATE AFTER THE COMPLETION OF THE COURSE PROGRAM.
DOWNLOAD AND SHARE ON YOUR SOCIAL MEDIA
Classes will Start on 1st August, 2022.
Click on the Link Below to Register
“I just took part and successfully concluded the pore pressure prediction training using rock physics software and I just have to say the experience was “wow”, am not just saying because, I want to promote them, but truly you should try and judge for yourself…. I can say, I have been PetroPlayed!!!! ……….. 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“An eye-opening training, I must say….. You get more value than what you paid for. #Beautifulinitiative#......... 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“I recommend PetroPlays for good training skills and experience that meets Oil and Gas Industry Standards….. 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️”
“Keep doing this training to help the African Geologists… It was a fantastic training experience. I got much more than I paid for…….. 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“The training is awesome. I am glad, I am part of it and I will be back soon…….. 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“It is the most comprehensive training I have taken. The trainer was excellent and exciting. What really could have been a herculean task was made easy. I remain grateful… 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“I appreciate every aspect of the training from the presentations to Lunch and Friendly Interactions. The cost I will say, is affordable. Thank you PetroPlays… 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“This program is enriched for the growth of the young professionals, so I encouraged that it should be continuous in all Niger Delta Region… 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
“As a geologist with experience in the Oil and Gas Industry, if you cannot use any of these softwares for seismic interpretations or others. You may need to upgrade yourself even as a manager to be able to supervise your subordinate … 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️”
“I was not always confident of myself when it comes to working in the Oil and Gas Industries, because I had no skill, but after the training, I know, I can work or get that dream job in the Oil and Gas Industries. I didn’t waste my Money and Time…. 👍 ⭐️ ⭐️ ⭐️ ⭐️ ⭐️ ”
You must have a working Laptop or Mobile Phone, and a Good Internet Connection. You must also be willing to commit about 3 hours of your time daily to any of the courses?
Yes, you will get a certificate, which will be issued during the course. But, you must complete the course to qualify and be eligible for a certificate.
The Training is a Self-Paced Training. That means you can learn at your own pace without any rush. The courses are all pre-recorded videos and powerpoints, pdfs, and Text. All you need to do is dedicate at least one - three hours of your time per day to the course. The Instructor will always be online to attend to and answer your question. Also, the Community will act as your motivation support to help you complete the courses...
When you make purchases on our site, you are bound by (and must accept) this refund policy. Every of our Digital products has enough information that shows you what the product entails. This gives you the ability to make a decision before you make a purchase. All Sales Are Final. We do not offer refunds under any circumstances. No Returns or Exchanges As we provide a digital service, returns and exchanges do not apply. We do not offer any kind of returns or exchanges. Have any complaints as regards our products, books, courses, etc.. Kindly send us a mail on [email protected] or Click on the WhatsApp Button to Chat with us...
Send a Mail to [email protected] or [email protected] or [email protected] or send a WhatsApp Message to 08169202093 or +44 7360 530383
Click on the Link Below to Register
