BSPO3   ADVANCED EXCEL FOR PETROLEUM OIL & GAS

Who Should Attend: Petroleum engineers, reservoir engineers, geologists, geoscientists, engineers, data analysts, cost engineers, project engineers, economists, managers, supervisors, technical support and those personnel who need to apply more advanced features and functionality of  Excel spreadsheet in the petroleum oil and gas industry.

Learning Expectations: This advanced Excel course is designed to help participants (*) tackle the most difficult concepts in Excel. The course covers all the advanced features and functionality of Excel including: creating macros, importing and exporting data, data formatting, linking workbooks and advanced data analysis. This is an ideal course for Excel power users who want to fully leverage all features Excel has to offer. This course is an intensive hands-on course introduces you to the built-in programming capabilities of Microsoft Excel™ and Visual Basic (VBA). It covers macro recording and the Visual Basic Editor; how to apply VBA programming to many different engineering and technical applications; creating user-defined functions and Excel add-ins; programming fundamentals and concepts in VBA; managing spreadsheet-to-VBA communications; user interfaces, including message boxes, input boxes, and user forms; interfacing Excel to other applications with VBA; and specific debugging techniques using the Visual Basic Editor. Other aspects of VBA discussed here include VBA algorithm structure, 
decisions, loops, and modular programming. At the course’s conclusion you’ll still be an engineer; but you’ll also be one big step closer to being an effective programmer, as well.

(*) This Advanced Excel course can be customized and tailored to specific individual or professional needs such as for petroleum engineers, project engineers, etc. Please contact Smartkoncept Technology for more details.

Duration: 3-5 days    Course Ref#: BSP03     Contact Us

       Contact Us