Learn more about education with this collection
The differences between Web 2.0 and Web 3.0
The future of the internet
Understanding the potential of Web 3.0
Excel is a great calculator for basic and complex math formulas:
/ for division
+ for addition
- for subtraction
* for multiplication
= to start a formula
( ) to separate functions
97
1.04K reads
MORE IDEAS ON THIS
When working with Excel you will want to insert rows and columns at times.
Shortcuts:
Ctrl + Space Bar = Select Column
Shift + Space Bar = Select Row
Insert Row = Ctrl + Shift + "+"
Delete Row = Ctrl + "-"
You can also right-click your mouse.
102
759 reads
Pivot tables are your best friend if you do a lot of data entry.
They let you organize data and slice and dice it.
Fortunately, they're easy to use at a basic level:
1. Highlight the data
2. Go to Insert > Pivot Table
Then, it's time to manipulate your data.
89
424 reads
With a lot of data, you may decide you want items in rows to be in columns or vice versa.
To transpose a column to a row:
1. Select the data in the column
2. Select the cell you want the row to start
3. Right click, choose paste special, select transpose
88
402 reads
XLookup is an upgraded VLookup.
We use it to find data in a table or range.
We are going to combine our X-Lookup with our Min and Max function.
The formula: =XLOOKUP(lookup value, lookup array, return array)
Ours will pull the min / max person by month.
91
444 reads
The world works on averages.
When your boss asks you a question, often you should answer with "On average..."
Positively, Excel makes it easy for us to know the average:
Enter a formula =Average( A+B+C+D)
Use your mouse =Average(drag mouse)
93
422 reads
With a large data table, you will use a formula for multiple rows.
Instead of typing it each time, use auto-fill. Here are 3 ways:
β’ Double click mouse on the lower right of 1st cell
β’ Highlight the Section and type Ctrl + D
β’ Drag the cell down the rows
92
512 reads
There can be a lot of data in a table.
You may not want to see all of that data and the sort and filter features will help with this.
To Sort or Filter:
1. Highlight data (include labels for filter)
2. Go to the Data Ribbon
3. Select Sort or Filter
88
388 reads
We use the IF formula to tell us to do something if a condition is met.
From logic class: If this, then that; else, this.
Your formula is =if(logical test, value if true, value if false)
You can also use nested IF formulas, which we will explore later (my favorite).
90
387 reads
Basic addition is the feature we use the most in Excel.
There are three ways we will show you to do it:
Enter a formula =Sum( A+B+C+D)
Use your mouse =Sum(drag mouse)
Auto Sum: Type Alt + "=" at the base of the data
94
574 reads
CURATED FROM
Excel is used by almost all the world's companies. Here is a brief look at 10 basic functions everyone should know.
β
Related collections
More like this
Nouns in math are the Arabic numerals, fractions, variables, expressions, figures, infinity, Pi and imaginary numbers like i.
The verbs of math are equalities and inequalities, addition, subtraction, division, multiplication and many other operati...
Bitcoin is a database that does only 1 thing: track ownership of coins.Β Ethereum adds the computational capabilities that makes Excel more than a database:Β
The mind is the most sophisticated computer on the planet, and yet most people have no idea how to use it effectively. The mind has no subtractions and divisions; it only has addition and multiplication. This means that trying to remove negative thoughts forcefully is futile. Instead, one must un...
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Access to 200,000+ ideas
β
Access to the mobile app
β
Unlimited idea saving & library
β
β
Unlimited history
β
β
Unlimited listening to ideas
β
β
Downloading & offline access
β
β
Personalized recommendations
β
β
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates