What are the advanced excel skills required these days

Asked By Maria Trienity 30 points N/A Posted on - 11/30/2012

I am good at excel but I want to know advanced excel skills that everybody wants to learn in order to compete with other Microsoft excel professionals in the job market

• Status: Open
• Question Views: 994
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Software Others

Best Answer by Lawren chavez

Go To Solution

Best Answer

Best Answer

Answered By Lawren chavez 0 points N/A #145529

What are the advanced excel skills required these days

Hi Maria Trienity,

In order to be an expert in Excel, you need to fulfill as many skills in Excel as possible.

Here I list some:

You must be good in formula.  Advanced excel user know which case use which formula and how to use it, debug error and fix it

Some formulas are sumif, sumproduct, index, match

You must be good in table, formatting and conditional formatting. Not only format table, advanced excel user has to combine conditional formatting with formulas to fulfill any condition.

You must be good in pivot table and pivot reporting. Advanced excel user should know all features in pivot such as grouping, calculation and summary by many kind of units.

You must be good in VBA and macro. Advanced excel user should know how to create and use macro, how to code by VBA.

Those are some fields in excel you have to know if you want to be an expert in excel

Hope this helps

About Lawren chavez

Questions
3

Answers
100

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 12/05/2012
• Question Category: Software Others

Answered By fiaz.fizzy 0 points N/A #145530

What are the advanced excel skills required these days

Experts in every field work quickly and easily.

Where we talk about advanced excel skills, you must know all key functions used in excel as, key functions save time of work.

The most important excel skills are;

1. Auto Filters

2. Pivot Tables

You must also know about important short keys;

a) Navigation Keys – Moving faster through your Workbook.

b) Ctrl + End – Moves to the last cell in the used area of the workbook.

c) Ctrl + Right Arrow – Moves to the right-most region of data.

d) Ctrl + Left Arrow – Moves to the left-most region of data.

e) Ctrl + Up Arrow – Moves to the top region of data.

About fiaz.fizzy

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/08/2012
• Question Category: Software Others