Microsoft Excel - Tips and info

BBC

BBC

Senior Member
Joined
Jan 30, 2015
Messages
869
Reaction score
730
Location
Deep in you
What are the most common things that are need to know for the workplace?

I know the basics of Excel (autosum, certain formulas and formatting etc)

Any resources that are recommended?

What would it take to become an advanced user?

Thanks
 
BBC said:
What are the most common things that are need to know for the workplace?

I know the basics of Excel (autosum, certain formulas and formatting etc)

Any resources that are recommended?

What would it take to become an advanced user?

Thanks
Click to expand...

This is from a udemy course info page. I broke it onto different quote for what I think are the different levels. Im on the fence with charts tables whether it should go to intermediate or advanced. I think more intermediate but I left it as the course page had it

Beginner
  • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.
  • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID
  • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF
Click to expand...

Intermediate
  • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS
  • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH
  • Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)
  • Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.
Click to expand...

Advanced
  • Pivot Tables - This Excel lecture covers Pivot tables end-to-end.
  • Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines
  • Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.
  • Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)
  • Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.
Click to expand...
 
  • Like
Reactions: BBC
MidnightZA said:
This is from a udemy course info page. I broke it onto different quote for what I think are the different levels. Im on the fence with charts tables whether it should go to intermediate or advanced. I think more intermediate but I left it as the course page had it

Beginner


Intermediate


Advanced
Click to expand...
Thank you!
 
VBA so you can write macros and functions yourself.
Some database knowledge and SQL so you can get data into excel.
 
  • Like
Reactions: BBC
In addition to all the above, PowerQuery.

It makes extracting and cleaning up data easier and repeatable.

It also makes joining/mapping/merging (i.e. VLOOKUP) two or more tables trivial, even if you need to match on multiple columns.
 
How does one learn this stuff if it is not in use by me daily?
swift412 said:
In addition to all the above, PowerQuery.

It makes extracting and cleaning up data easier and repeatable.

It also makes joining/mapping/merging (i.e. VLOOKUP) two or more tables trivial, even if you need to match on multiple columns.
Click to expand...
 
BBC said:
How does one learn this stuff if it is not in use by me daily?
Click to expand...

www.udemy.com

Online Courses - Learn Anything, On Your Schedule | Udemy

Udemy is an online learning and teaching marketplace with over 213,000 courses and 57 million students. Learn programming, marketing, data science and more.
www.udemy.com www.udemy.com

EDIT:
You can learn almost anything on Udemy for free. Just type what you looking for and filter free.
You will most likely have to go through a few bad quality ones before you find one that is actually barrable to watch
 
  • Like
Reactions: BBC
MidnightZA said:
This is from a udemy course info page. I broke it onto different quote for what I think are the different levels. Im on the fence with charts tables whether it should go to intermediate or advanced. I think more intermediate but I left it as the course page had it

Beginner


Intermediate


Advanced
Click to expand...
Shew, I would rate things differently. I know everything classified as Beginner and Intermediate, as well as pivot tables, but I'd rate myself about a 3/10 as Excel's properly advanced functionality comes from VBA/macros - which I don't know.

I dare say that 9/10 people who rate themselves more than a 5/10 don't know what they don't know.
 
  • Like
Reactions: BBC
BBC said:
What are the most common things that are need to know for the workplace?

I know the basics of Excel (autosum, certain formulas and formatting etc)

Any resources that are recommended?

What would it take to become an advanced user?

Thanks
Click to expand...
www.goskills.com

GoSkills: Business Courses Online | LMS | Online Course Builder

GoSkills offers award-winning business courses online, combined with a powerful learning management system (LMS) and an intuitive online course builder. Empower your team with expert-led training, easily manage courses, and create custom content. Start for free!
www.goskills.com www.goskills.com
 
  • Like
Reactions: BBC
[XC] Oj101 said:
Shew, I would rate things differently. I know everything classified as Beginner and Intermediate, as well as pivot tables, but I'd rate myself about a 3/10 as Excel's properly advanced functionality comes from VBA/macros - which I don't know.

I dare say that 9/10 people who rate themselves more than a 5/10 don't know what they don't know.
Click to expand...

Thats true though. I've met some people who think excel is just for making tables. They think using autosum is advanced functions.

Those 3 categories are purely speculative depending on peoples existing knowledge of the full potential of the Excel.

Like a comrades runner will think running 5kms is childs play. If I try run 5kms without slowing down, I'll probably cough up my lungs at the end. (Yes, Im that unfit:ROFL: )
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X