6rpmgebrm224luy5s7pl excel

5 Powerful Excel Skills for Oil and Gas Professionals

Do more with Excel 2010 : Filters, VLookup, Pivot Tables, Pivot Charts and Macros | Est. length: 2:30 hrs

   Watch Promo

Let's face it, no matter what your role in Oil and Gas is, even if Excel is not part of your day-to-day routine, you've had to use Excel at some point in your career.

Learning how to boost your skills in Excel to streamline reporting, turn raw data into presentation-ready graphs or chart is A MUST!

If you already have some basic knowledge of Excel but you are envious of colleagues who can produce fancy charts, use "Pivot Tables" and present data seemingly with ease using Excel, this course is for YOU! Now, you can be one of them and the secret is - IT'S NOT HARD!

This short and sweet course was designed to show you exactly what you need to do to take your skills to the next level.

In just a couple of hours, you could be showing off and impressing others just like the Excel "experts" in your organization. Most importantly, this course is guaranteed to make you more efficient at work using Excel, while also making you look really good to your boss! Enroll today, take the course all in one sitting for about 2:30 hours, or take it at your own pace.

In no time you will be SHOCKED at the difference this course makes. Plus, with lifetime access, you can always come back to reinforce something you learned.

I’ll teach you these 5 powerful excel skills:

  • FILTERS - To navigate and view your information more effectively.
  • VLOOKUP - To quickly pull info from one list to another.
  • PIVOT TABLES - To instantly summarize a set of information.
  • PIVOT CHARTS - To instant chart out the summary from a Pivot Table!
  • MACROS - To automate recurring tasks in Excel.

Each of these skills can make you more efficient and allow you to quickly produce high quality reporting/charts.

In this course we'll use real data related to the Oil & Gas industry in each of the practical examples in the lectures such as:

  • Rig counts
  • Production Performance
  • Oil and Gas reserves
  • Tracking licenses to drill or safety records
  • Tracking team costs and more!

Of course, you will be able to apply these same skills in many other datasets of your day-to-day needs.

You can download & work on the ACTUAL files we use, while watching each lecture!

Estimated Time:

1:30 video material

1:00 practical work

* This course is not an introduction to Excel! You should know the basics such as navigating the interface, creating basic spreadsheets and using basic formulas.

** This course uses Excel 2010



Your Instructor


Dustin Schimek - M.B.A.
Dustin Schimek - M.B.A.

Dustin is a Microsoft Excel ninja and the founder of Spreadsheet Clinic, which provides professionals and organizations with Excel training, support & consulting. Dustin has used Excel professionally in a range of capacities, both as a user himself and in training others! He holds Microsoft Office Specialist-Expert certification in Excel 2010, and is an M.B.A. graduate with an undergrad degree in Economics.

As a former analyst and "go-to" Excel person in the corporate world - Dustin has provided training to professionals of varying skill levels. It's always been rewarding for him to witness the impact that just a few new Excel skills can bring to one's efficiency and effectiveness!

From Dustin's time in the professional world, he has seen first hand the additional value that those who invest in their Excel skills bring to the table. His goal is to create courses that will allow other professionals build on their Excel skills, which he knows can help set them apart in today's competitive work environments!

Founder, Spreadsheet Clinic - Excel Training, Support & Consulting


Class Curriculum


  Feedback
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does a 12-month access window sound? After purchase, you have unlimited access to this course for 12 months - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are dissatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.* * See Terms and Conditions for more details

Petrolessons.com is your portal for oil and gas online training. Join the community

Get started now!