506 Courses

Develop your expertise in data analytics and visualization with EnergyEdge's Introduction to Data Analytics Visualization course. Join our classroom training to acquire essential skills in this field.

Dive into the world of electric vehicles and their impact on the grid with EnergyEdge's virtual instructor-led training course. Gain valuable knowledge and insights.

Discover the secrets of successful carbon capture and storage (CCS) project risk management through EnergyEdge's virtual instructor-led training (VILT). Join us and become an expert today!

Enhance your knowledge in cost engineering, financing, and risk management for upstream and downstream oil gas projects with Energyedge. Enroll now!

Enhance your knowledge in oil and gas drilling essentials with EnergyEdge's classroom training for new engineers and non-technical professionals.

Dive deep into trap, fault, and seal analysis modeling for oil, gas, and CO2 with EnergyEdge course. Enroll in our classroom training today!

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

Facilitated by Registered Clinicians with extensive experience

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.