What are functions everyone should know how to use on excel? I’m looking to dive into excel soon and want to start with the basics. Forgot most of it since college.

Pivot tables, freeze panes, eliminate duplicates, etc.

5 ...

Report Post

Posted by drexyl

Mingovia

Member since Sep 2005

23055 posts

Posted on 10/22/17 at 1:25 pm to Lazy But Talented

SumIf is a personal favorite

0 ...

Report Post

Posted by LSUtigerME

Walker, LA

Member since Oct 2012

3789 posts

Posted on 10/22/17 at 2:11 pm to Lazy But Talented

Just functions? Or features?

Functions: VLookUp/HLookup, Average/Sum/SumProduct/etc, If, SumIf/s, Interest/Payment/etc, Match/Index, Date/Weekday/etc., Left/Right/Mid, Concatenate

Features: Conditonal formatting, Tables/Charts, Pivot Tables, Solver, Form tools (check boxes, radio buttons, etc), Basic VBA

1 ...

Report Post

Posted by Lazy But Talented

Member since Aug 2011

14438 posts

Posted on 10/22/17 at 2:14 pm to LSUtigerME

quote:
Just functions? Or features?

Both.

0 ...

Report Post

Posted by pjab

Member since Mar 2016

5643 posts

Posted on 10/22/17 at 6:11 pm to Lazy But Talented

Index(match,match)

0 ...

Report Post

Posted by adavis

North of I-10

Member since Aug 2007

5749 posts

Posted on 10/22/17 at 6:13 pm to Lazy But Talented

Excel blows my damn mind. I envy those who are able to use it

1 ...

Report Post

Posted by lynxcat

Member since Jan 2008

24121 posts

Posted on 10/22/17 at 8:45 pm to adavis

Calculated fields within pivot tables are the best kept secret around. I live by them.

Sum
Sumif
Sumifs
Countifs
Sumproduct
Product
Count
Counta
Countif
If
Nested if statements
Average
Median
Mode
Stdev
Normdist
Running regressions using data analysis tool pak
Turning a set of data into a table
Pivot tables - clearly one of the most important topics
Creating lookup tables
Index match
Vlookup
Hlookup
Left
Right
Len
Trim
And
Or
Proper
Upper
Lower
Remove duplicates
Sorting
Conditional formatting
You need to learn the keyboard shortcuts to do most of everything
Alt A L
Alt A T
Alt ESV
ALT ESF
ALT EST
Control and shift should be your best friends along with the arrow keys and page up and down.

That gets you started. The magic is how to use all of the formulas in tandem. True experts will blow your mind with their skills. I’m better than 99% of the world and I don’t know shite compared to the experts on Mr Excel.

This post was edited on 10/23/17 at 8:03 am

0 ...

Report Post

Posted by ODP

Conroe

Member since Oct 2015

1938 posts

Posted on 10/23/17 at 9:29 am to Lazy But Talented

Depends what you're doing.

For Financial Analysis

Tables
Pivot Tables
Power Pivot
concatenate
vlookup
hlookup
index
index match match
if and
sumif
averageif
countif
find
left
right
offset
abs
fmv
pv

pie charts
waterfall charts
conditional formatting
What-if analysis
gouping

diff between:
ctrl+v
ctrl+alt+v

ctrl+t

creating macros for repeated functions

This post was edited on 10/23/17 at 9:30 am

Page 1