# data[].attributes.body
During this 14 weeks classes, I have learn a lot of things about professional etiquette that can be implement in my life when I graduate later on and this knowledge so useful in working life that I will enter in the future. This course do not have any final examination but it based on continuous assessment which made me enjoyed with the class. The lecturer also kind and always concern about the students. Besides that, through the program being held I can strengthen the relationship within my classmates and learn new things in organizing a program. I hope this course will be introduce to the junior of my faculty as well in the future.

# data[].attributes.body
Name: Mohamad Suria Dharmawan
Faculty: School of Chemical Engineering
Course: Bachelor (Hons) In Oil & Gas Engineering
Years of Study: 4 years (2018-2022)
Current Semester: 6
University: UiTM Shah Alam

# data[].attributes.headline
Southeast Asian Producers Want To Tie Their Future To Region's Growing Energy Demand

# data[].attributes.subject
Southeast Asian Producers Want To Tie Their Future To Region's Growing Energy Demand

# data[].attributes.attachment_link.readable_text
Southeast Asian operators sit in the middle of the world's fastest growing economic region where energy demand is expected to double over the next 20 years. But this picture of growth has been juxtaposed with the region's declining oil and gas production-most of which comes from offshore fields-that has left it increasingly reliant on imports from overseas suppliers.

The degree to which operators in Malaysia and Indonesia can help counter this trend was the focus of an executive panel last week at the International Petroleum Technology Conference (IPTC). While acknowledging that the region is marked by challenging geologies and mature offshore fields, the executives spoke highly of what the future holds.

Several things underpin their optimism, not least of which is the region's rising demand for natural gas. Coupled with the spread of low-carbon energy agendas in Asia, this dynamic could also make proximity-to-market an attractive differentiator for operators there.

Emeliana Rice-Oxley, the vice president of exploration at Malaysia's Petronas, said at the conference that when stacked against the global portfolio Southeast Asian reservoirs are often considered "mature or immaterial since the hydrocarbons in these basins have been produced continuously for a very long time."

"However, it is important to note that significant potential remains," she added before listing a number of recent discoveries made by Petronas and its partners in Malaysian and Indonesian waters. Among them was a well off the coast of Sarawak that was drilled into a 260 ft-tall gas column by Thailand's PTTEP which owns an 80% operator-stake while Petronas owns the remaining 20% interest.

The renewed emphasis on projects closer to home comes after Petronas spent the past 5 years spending about 60% of its exploration budget on fields outside of Southeast Asia. In the next 5 years, the company will nearly reverse this ratio by spending 55% of its exploration budget inside its home region.

A key component of Petronas' plans hinge on the rising need for electricity across Asia. Rice-Oxley noted that natural gas already represents 60% of Southeast Asia's power plant needs "and I think this will continue to drive upstream activities."

The Malaysian operator is among those ambitioning toward a net-zero carbon footprint by 2050 and sees gas as a bridge fuel.

One enabling technology that Petronas is counting on to build that bridge profitably is floating LNG (FLNG). In 2019, the company was the 5th-largest exporter of LNG, shipping about 1.2 Tcf or 7% total LNG cargos delivered that year.

This year, the company became the world's first to own and operate two FLNG facilities. Both units currently supply Southeast Asian markets and are considered by Petronas to be essential in making remote and marginal gas fields competitive.

Kanok Intharawijitr, the executive vice president of the exploration group for PTTEP, echoed his colleague in saying there remain "huge resources" offshore Malaysia, which has become a major focus area for the state-run operator. Last month, PTTEP announced the company's largest-ever gas discovery was made offshore Malaysia in a well that showed an initial flow rate of 50 MMscf/D.

Intharawijitr highlighted during his remarks that the makeup of the Southeast Asian operator landscape is considerably more local after many western international oil companies spent the past few years divesting from the region.

"This created a great opportunity for a small company like PTTEP," he said about the wave of exits, one of which resulted in Houston-based Murphy Oil selling its Sabah gas fields offshore Malaysia to PTTEP for $2.1 billion in 2019.

Different owners tend to bring different perspectives. This is important to the future of Southeast Asia since Intharawijitr said many of the region's untapped prospects are relatively small in volume, a fact that demands "new eyes, and a new philosophy" to realize the potential economics.

For PTTEP, that means the company may be more willing than others to try and squeeze profits from a marginal asset. "We're not always looking for the big return-a small return is OK for us," he said with a chuckle.
Indonesia Seeks "Fast Track" to 1 Million B/D
Malaysia is not the only place where a new way of thinking is being used to get better results.

After peaking at 1.5 million B/D in the 1990s, Indonesia's output slid below 700,000 B/D in 2020. In response, the government has introduced a number of new policies that it hopes will boost production back up to 1 million B/D by 2030-enough to meet about half of projected domestic demand.

"With a decline of about 20-30% a year, it's quite challenging," acknowledged Jaffee Suardin, the deputy of planning at SKK Migas, a government agency tasked with marketing Indonesia's state-owned resources. His remark helps frame why the group has recently adopted this three-word mantra for its effort: "massive, aggressive, efficient."

"All the proposals that we are asking from investors should include massive activity, and if it's massive and aggressive, we know the economic part of it could be challenging," said Suardin.

The aggressive approach is hoped to result in more than 260 new Indonesian wells drilled by years' end. The pace will have to pick up big time, though, to meet the 1 million B/D goal. Considering the rate of decline from its existing fields, SKK Migas estimates Indonesia might need as many as 1,000 new wells drilled annually by 2030.

Regarding efficiency, the state agency is promoting its new "fast track" model that evaluates the economic potential of a project while it is still in exploration mode. If the government likes what it sees, Suardin said it may take the extraordinary step of offering "flexible and competitive" terms early on in the process.

SKK Migas has made other recent moves to modernize. Last year, it also did away with the traditional fees associated with accessing pre-auction block data à la carte. To make it easier for potential bidders to find something worth investing in, it now uses a membership model that, much like a streaming video subscription, allows exploration companies and other investors to scan all the data at their pleasure.
Challenging Dogmas
A different perspective to the topic of exploration data was raised by Sophie Zurquiyah, the CEO of CGG. The opportunity she highlighted suggested that Southeast Asian competitiveness might be boosted by embracing more of the multiclient seismic surveys that have become a norm in other mature basins such as the North Sea and US Gulf of Mexico.

She spoke to the efficiency gains operators elsewhere have realized by sharing the costs and workload of acquisition and processing. In general, a collaborative approach to seismic surveying yields a sharper picture of the subsurface, leaving fewer questions about the continuity of long faults or specific layers of rock.

"Where it works well is where we have predictable lease rounds, where the block size is a bit smaller and there longer periods of exclusivity to market the data from a service company," she added. "And, in that sense, it's been a bit more difficult to make that model work in Asia."

While progress may be needed on this front, Petronas is among the operators who have recently funded multiclient surveys in frontier offshore areas in the region. Petronas is also in the middle of a 5-year contract with CGG which has established for the operator an advanced imaging center at its headquarters in Kuala Lumpur.

Rice-Oxley shared images of old seismic data that after being reprocessed revealed a stark difference in resolution of the geologic structure and layering. She said the newly developed seismic processing techniques have played a role in a number of recent discoveries; this includes the Kali Berau Dalam discovery drilled by Reposol and Petronas which was celebrated as Indonesia's biggest gas find in 18 years.

The discovery made 2 years ago was a manifestation of Rice-Oxley's call for explorers in the region to "challenge dogmas" that may be holding back creative development solutions.

While Southeast Asia's reservoirs are often noted as complex and shaped by harsh tectonics, making predicting their potential "much more difficult compared with other regions," she explained those same disadvantages are also "why some big discoveries continue to be made, even after almost 150 years of exploration."

# data[].attributes.attachment_link.title
Southeast Asian Producers Want To Tie Their Future to Region's Growing Energy Demand

# data[].attributes.attachment_link.description
Southeast Asian operators sit in the middle of the world's fastest growing economic region where energy demand is expected to double over the next 20 years. But this picture of growth has been juxtaposed with the region's declining oil and gas production-most of which comes from offshore fields-that has left it increasingly reliant on imports from overseas suppliers.

# data[].attributes.headline
Country Analysis Executive Summary: Malaysia

# data[].attributes.subject
Country Analysis Executive Summary: Malaysia

# data[].attributes.body
He is the founder of Weststart Aviation Services Sdn Bhd which focus on Oil & Gas sector by providing transportation services to offshore. Meanwhile, he also involve in business of importing/ distributing commercial and luxury vehicles. Now, he is list as second richest Malay individual and among 50 richest individual in Malaysia. i hope I can be like him one day.

# data[].attributes.body
This software is useful for engineer and designer in designing or drafting a product into 3D form.

# data[].attributes.attachment_link.title
7 Rules for Success for Designers and Drafters | AutoCAD

# data[].attributes.body
Excel is a great engineering tool  that capable of handling both equations and tables of data. And combination of these two functionalities can create powerful engineering models by looking up data from tables and pulling it into calculations for a data analysis.

# data[].attributes.attachment_link.readable_text
Developing Excel skills is a powerful way to start analyzing data like the professionals do.

Whether you're navigating toward a future career as a data analyst, you want a new skill to leverage at work, or you want to turn your household budget into an impressive well-oiled machine, learning how to analyze data in Excel with Excel formulas and tools will definitely ramp up the efficiency of your life.

Here to let us in on his Microsoft Excel tips is Excel professional Adam Lacey, managing director of Excel with Business. In this special guest post, he shares 11 key Excel skills and formulas in Excel that you should know- with videos so you can follow along!

Take it away, Adam!

Disclosure: I'm a proud affiliate for some of the resources mentioned in this article. If you buy a product through my links on this page, I may get a small commission for referring you. Thanks!
Table of Contents
Over 30 years after its creation, Microsoft Excel remains the go-to software for the majority of people looking to do some quick data analysis.

Sure, there is bigger, better, more complex software available for data analysis these days, not to mention the free, web-based Google Sheets, but nothing has the broad-based appeal of Microsoft Excel.

Numbers rarely lie, which is why making data-driven decisions is so important. Companies need skilled professionals who are able to turn those raw numbers into actionable insights.

Of course, it would take thousands of hours to sift through it all manually and make connections with no tools to help, which is why learning how to use Excel and other data programs is the first step for those looking to enter this highly sought-after tech career. The right data analysis skills can turn raw information into sound business strategy.

Regardless of your technical experience, understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Over the last eight years, we've taught over a million students valuable spreadsheet skills, and we've learned a thing or two ourselves. The biggest lesson is that you only need basic Excel training and a handful of Excel formulas to start getting brilliant returns from it.

So we got all the Excel experts we know, together, looked at the data we had, and came up with The Definitive 100 Most Useful Excel Tips.

The aim of this project was to illuminate a pathway through the dense jungle of formulas and functions that makes Microsoft Excel the desktop software we both love and hate.

We've picked out the top 11 Excel skills that will help you supercharge your data analysis abilities and prepare for a fantastic career in tech. We've even included a difficulty rating and how long each takes to master so you can pick the right ones for you.

Now, here are those 11 Excel skills, with videos to help even more. Enjoy!

Excel Skill #1: PivotTables

📈 Difficulty: 3 / 5

⏰ Mastery: 4 hours

At 4 hours to proficiency, PivotTables is one of the more time-intensive Excel skills to master, but it's worth it. You can use them to sort, count, total, or average data stored in one large spreadsheet and display them in a new table, cut however you want.

The versatility of PivotTables is what makes them so powerful. You simply drag and drop the relevant column data to create the table format you want.

A PivotTable will automatically group matching data, giving you quick summaries from a giant table. For example, if you had a table full of sales data and each line was a product and an amount, in a couple of clicks you could display all the data summed and group by product (something that would take much longer just using formulas or functions). (As a warning, make sure your data is clean first!)

If you are analyzing data with Excel, then PivotTables are THE most valuable thing you can learn.
The LinkedIn Learning course featured in the video is Excel 2016 Essential Training. I'd recommend taking the updated version, Excel 2020 Essential Training.
Head back to the table of contents "

Excel Skill #2: Flash Fill

📈 Difficulty: 2 / 5

⏰ Mastery: 30 minutes

Excel developed a mind of its own in 2013, which is perfectly illustrated by this feature.

Say you have two columns of names and you need to construct email addresses from them all. With Flash Fill, you can just do it for the first row, and Excel will work out what you mean and do it for the rest (see image and video below). Pre-2013, this was possible but relied on a combination of functions (FIND, LEFT, &, etc). This way is much faster and WILL impress people.

👩‍💻 Where to learn more about Flash Fill: Complete Guide - Flash Fill in MS Excel on Udemy

Head back to the table of contents "

Excel Skill #3: Filters

📈 Difficulty: 2 / 5

⏰ Mastery: 1 hour
The LinkedIn Learning course featured in the video is Excel: Filtering Data for Beginners. Click here to learn more about it.
Explore data in a table quickly. Filtering effectively hides data that is not of interest to you.

Usually there's a value, e.g. 'Blue cars,' that you're looking for, and Filters will bring up those and hide the rest. But in more modern versions of Excel, you can now also filter on number values (e.g. is greater than, top 10%, etc), and cell color.

Filtering becomes more powerful when you need to filter more than one column in combination, e.g. both colors and vehicles, to find your blue car. Alt D F F is the shortcut (easier than it sounds-give it a go, pressing the keys in order rather than all together).

Conditional Formatting and Sorting serve related purposes. Sorting involves re-arranging your spreadsheet, which is intrusive and may not be desirable. Conditional formatting brings visualization. Filtering is fast and effective. Choose well.

Head back to the table of contents "

Excel Skill #4: Conditional Formatting

📈 Difficulty: 3 / 5

⏰ Mastery: 3 hours

Conditional Formatting changes the color of a cell and its contents given a certain condition. For example, you might want to highlight any negative numbers in red, or cells that contain a certain word. Conditional formatting makes this a breeze and makes colorful sense of data in a noisy world.

Conditional Formatting can be sophisticated. But even the simplest color changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three clicks can reveal the top 10% of salespeople by performance and tee up an important business conversation.

👩‍💻 Want to learn more about conditional formatting in Excel? Check out this course on Skillshare. (You can even try it for free!)

Head back to the table of contents "
How it works: The syntax for COUNTIF is =COUNTIF(range [range of numbers you are looking at], criteria [criteria you are searching against]
Excel Skill #5: COUNTIF

📈 Difficulty: 2 / 5

⏰ Mastery: 15 minutes

Counts cells with certain properties. For example, you want to find out how often a certain entry appears in a list. COUNTIF will look at the list and count it if it matches your chosen criteria. It's an excellent function, very simple to learn, and one you'll use over and over again when analyzing data.

👩‍💻 Want to learn to use COUNTIF? Check out Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS on Udemy.

Head back to the table of contents "

Excel Skill #6: Charts

📈 Difficulty: 3 / 5

⏰ Mastery: 3 hours

There are more than 20 chart types. Most people get by with Bar, Column, Pie, Line, and Scatter charts.

With Bar, Column, Pie, and Line charts, you just need a single series of numbers to generate a chart. With a Scatter, you need two sets of corresponding data to compare (e.g. height vs. weight).

Charts are one of the most effective ways to display the data analysis you've conducted. Words and tables tell a story, but an image tells a thousand words; that's what charts are doing for your data analysis.

👩‍💻 Want to learn more about Excel charts? Check out this course on Mammoth Interactive.

Head back to the table of contents "
How it works: The syntax for SUMIF is: =SUMIF(range, [the range of cells to look at], criteria [the criteria determining which cells to add], sum range [the cells to add together]
Excel Skill #7: SUMIF

📈 Difficulty: 3 / 5

⏰ Mastery: 15 minutes

Adds cells with certain properties. Like COUNTIF, these properties include: being a certain number or word (most useful), being above/below certain values, not equaling a value (<>), etc.

Just like COUNTIF, SUMIF is incredibly useful when you want to pull out summary information from large datasets. In the example image below, we are adding together the sales that match the category Cola.

👩‍💻 Want to learn to use SUMIF? Check out Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS on Udemy.
=IFERROR(VLOOKUP(B14,C6:D15,2,FALSE),"")
Head back to the table of contents "

Excel Skill #8: IFERROR

📈 Difficulty: 2 / 5

⏰ Mastery: 30 minutes

Errors (#VALUE!, #####, #DIV/0!, #REF!, etc) look ugly and can stop calculations from working (e.g. summing over a range of values with a single #DIV/0!). You can avoid it by using =IFERROR().

You can wrap any formula in IFERROR to remove those ugly error codes. For example:

If this above VLOOKUP was returning an error, it would now return a blank cell. In Excel functions, quotation marks will return the information inside them, so if you put nothing between them ("") then it returns an empty cell-genius.

👩‍💻 Learn about IFERROR in this Udemy course: Excel's VLOOKUP, XLOOKUP, MATCH & INDEX | Over 20 Functions
The LinkedIn Learning course featured in the video is Excel 2013 Essential Training. I'd recommend taking the updated version, Excel 2020 Essential Training.
Head back to the table of contents "

Excel Skill #9: Slicers

📈 Difficulty: 2 / 5

⏰ Mastery: 45 minutes

PivotTable slicers do the same thing as Filters-they enable you to show certain data and hide other data as required. But rather than dull drop-down menus, slicers offer nice big friendly buttons to make the whole user experience nicer and easier.

As well as fast filtering, slicers also tell you what the current filtering state is so you know what's currently in and out of the PivotTable report.

Head back to the table of contents "

Excel Skill #10: Power Pivots
👩‍💻 Where to learn more about Power Pivot: Complete Introduction to Excel Power Pivot on Udemy
📈 Difficulty: 4 / 5

⏰ Mastery: 3 hours

This is a powerful feature which brings a lot more firepower to PivotTables (e.g. COUNTROWS) and more processing power to deal with much larger data sets. Power Pivot connects your PivotTables with external databases and can be refreshed on cue.

For example, say you had millions of rows of data-too much for Excel to handle-you could have these saved in an Access or SQL database. Using Power Pivot, you can pull this data into Excel and then run PivotTables and Charts straight off that data.

You can also create relationships between multiple tables, so if you have some data in one database and other data in another, no problem. Bring them together in Power Pivot and display your analysis using PivotTables and Charts.

Mostly for Excel experts and BI professionals. If you want to get serious about data analysis, then you need to spend some time getting to grips with Power Pivot.

Head back to the table of contents "

Excel Skill #11: Sparkline

📈 Difficulty: 2 / 5

⏰ Mastery: 15 minutes

A Sparkline is a tiny chart in a worksheet cell that provides a visual representation of the data selected.

Sparklines are useful for showing trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Sparklines can be displayed as lines or columns and can also represent any negative values. Position a Sparkline near its data for greatest impact.

👩‍💻 Where to learn more about Sparkline: Run a Sparkline Trend Analysis in Google Sheets on Coursera

Head back to the table of contents "

5 Advanced Excel Skills to Consider Learning

The 11 Excel basic skills above are extremely useful, but they're only scratching the surface of what this powerful program can do. If you're interested in seeing the 89 that didn't make this list, see the full 100 here!

Looking to progress to more advanced Excel functions and formulas? Start with these 5.
Get the course mentioned in the video below here: Learning Excel What-If Analysis via LinkedIn Learning
INDEX MATCH

This formula is essentially the combination of two functions in Excel. You can use it to look up a value in a big table of data and return a corresponding value in that table.

This is an advanced alternative to the VLOOKUP or HLOOKUP formulas (which have several drawbacks and limitations). It's more flexible and therefore more powerful than VLOOKUPs.
Course mentioned in the video: Recording and Managing Excel Macros via Pluralsight
👩‍💻 Where to learn it: Index Match video on Coursera

Goal Seek

Goal Seek answers "what if" scenarios. It involves changing values in cells to see how those changes will affect the outcome of formulas on the worksheet.

If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, that's where the Goal Seek feature comes in.

Macros in Excel VBA

If you have tasks in Excel that you need to do repeatedly, you can record a macro to automate those tasks. This helps you cut down on annoying or time-consuming busywork so you can focus on more important things!

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. The macro can then be saved and run whenever it is needed.
Click here to learn more about the course featured in this video.
INDIRECT

INDIRECT is an advanced Excel function used to convert a text string into a valid reference.

For instance, you can use it to convert a reference assembled as text (e.g. 'Sheet1!A1') into a value reference. So Excel knows to find the value from the cell in A1 rather than treat it as text.

👩‍💻 Where to learn it: Excel Training (Indirect, count & sum family) - Series 3 on Udemy

Get External Data (from Web)

Data that you want to use in Excel might not always be stored in another Excel workbook. Sometimes that data may exist externally, e.g. in an access file, in a database, or maybe on the web.

This data can be imported into Excel easily using the 'Get External Data' utility. The main benefit of connecting to external data is that you can periodically analyze it in Excel without having to repeatedly copy it, which can be time-consuming and error-prone.

Head back to the table of contents "
About the Author
Where to Learn More About Excel

Online Excel Courses

Excel Skills for Business Specialization on Coursera: A 4-course specialization that teaches advanced Excel features and techniques.

Excel/VBA for Creative Problem Solving Specialization on Coursera: Teaches you how to automate Excel spreadsheets with Visual Basic for Applications.

Excel Tips Weekly on LinkedIn Learning: Tune in every Tuesday for a new Excel tip (e.g., productivity-boosting tricks, cool hidden features, need-to-know functions).

Excel: Advanced Formulas and Functions on LinkedIn Learning: In this course, Excel expert Dennis Taylor demystifies hundreds of formulas and functions available in Excel.

Microsoft Excel - Excel from Beginner to Advanced on Udemy: Taught by a Microsoft Certified Trainer (MCT) and certified Microsoft Office Master Instructor, this course is great for newcomers to Excel.

The Ultimate Excel Programmer Course on Udemy: Learn Excel VBA from scratch through 12.5 hours of on-demand video.

Excel Essentials for the Real World (Complete Excel Course) on Udemy: By the end of the course, you'll be able to do things like organize, clean, and manage large data, turn messy data into helpful charts, and more.

Microsoft Excel Programming on Pluralsight: In this learning path, you'll learn Visual Basic for Applications, built-in Excel functions, Excel macros, and troubleshooting formulas.

Excel for the Real World: Gain the Basic Skills of Microsoft Excel on Skillshare: A 3-part series that teaches you all the basics of Excel and its practical applications. Taught by a former financial analyst at Google.

Complete Excel, Python and Machine Learning eDegree on Mammoth Interactive: Start as a beginner and progress throughout 6 courses, gaining skills in Python machine learning with Excel files, building internal apps with Amazon Honeycode and spreadsheets, and much more.

Excel Books

101 Most Popular Excel Formulas by John Michaloudis: Nearly 500 pages with step-by-step instructions to take your Excel skills to the next level. Best for intermediate or advanced Excel users.

Excel 2019 All-in-One For Dummies by Greg Harvey: Covers basic Excel functions all the way to editing macros with Visual Basic and everything in between. Great for beginners and intermediate Excel users.

Excel 2019 Bible by Michael Alexander: Over 1,000 pages of Excel tips, tricks, and techniques. Great for all levels, from beginner to intermediate to power user.

Excel 2019 Basics: A Quick and Easy Guide to Boosting Your Productivity with Excel by Nathan George: Offers a step-by-step process to becoming skilled with Excel, starting with introductory topics and ending with advanced ones like analyzing your data with charts.

Excel Basics In 30 Minutes by Ian Lamont: Written in plain English, with lots of step-by-step instructions/screenshots to help you learn the fundamentals of Excel.

Once you start mastering the power of spreadsheets, you'll wonder how you ever got through life without them. If you want to work in a data-related career, knowing Excel skills is the perfect first step!

And if you're still keen after that? There are plenty of courses that teach the ins and outs of data, like the courses from DataCamp.

Adam Lacey is Managing Director of Excel with Business, an online training company that has helped improve Excel and Microsoft Office skills for over 1 million people.

# data[].attributes.attachment_link.title
11 Advanced Excel Skills That Will Make You Look Like a Spreadsheet Pro

# data[].attributes.attachment_link.description
Developing Excel skills is a powerful way to start analyzing data like the professionals do. Whether you're navigating toward a future career as a data analyst, you want a new skill to leverage at work, or you want to turn your household budget into an impressive well-oiled machine, learning how to analyze data in Excel with Excel formulas and tools will definitely ramp up the efficiency of your life.