Insert Rows & Columns - Deepstash
Introduction to Web 3.0

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

Introduction to Web 3.0

Discover 36 similar ideas in

It takes just

6 mins to read

Insert Rows & Columns

Insert Rows & Columns

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

MORE IDEAS ON THIS

Pivot Tables

Pivot Tables

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

Transpose Function

Transpose Function

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 Function

Xlookup Function

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

Average

Average

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

Basic Math

Basic Math

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

Auto-Fill

Auto-Fill

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

Sort And Filter

Sort And Filter

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

IF Function

IF Function

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

Sum

Sum

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

CURATED BY

nat_nn

"At the touch of love, everyone becomes a poet." - Plato

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

Python data processing with pandas

Pandas is a Python language package, which is used for data processing. This is a very common basic programming library when we use Python language for machine learning programming. This article is an introductory tutorial to it. Pandas provide fast, flexible and expressive data structures with t...

The easy way to create filters

If you have recurring emails that annoy you or you simply want an organized inbox without doing it manually you can filter them automatically:

  1. Open an email that fits in that particular category you want it sorted
  2. From the

Enjoying The Single Life

Enjoying The Single Life

When you're single, you can talk to whoever you want at the bar, swipe left and right all day long, and do whatever your heart desires. A relationship is likely to constrain one's freedom of choice and giving up that freedom is difficult for some.

stash-superman-illustration

Explore the World’s

Best Ideas

200,000+ ideas on pretty much any topic. Created by the smartest people around & well-organized so you can explore at will.

An Idea for Everything

Explore the biggest library of insights. And we've infused it with powerful filtering tools so you can easily find what you need.

Knowledge Library

Powerful Saving & Organizational Tools

Save ideas for later reading, for personalized stashes, or for remembering it later.

# Personal Growth

Take Your Ideas

Anywhere

Organize your ideas & listen on the go. And with Pro, there are no limits.

Listen on the go

Just press play and we take care of the words.

Never worry about spotty connections

No Internet access? No problem. Within the mobile app, all your ideas are available, even when offline.

Get Organized with Stashes

Ideas for your next work project? Quotes that inspire you? Put them in the right place so you never lose them.

Join

2 Million Stashers

4.8

5,740 Reviews

App Store

4.7

72,690 Reviews

Google Play

samz905

Don’t look further if you love learning new things. A refreshing concept that provides quick ideas for busy thought leaders.

β€œ

Shankul Varada

Best app ever! You heard it right. This app has helped me get back on my quest to get things done while equipping myself with knowledge everyday.

β€œ

Ashley Anthony

This app is LOADED with RELEVANT, HELPFUL, AND EDUCATIONAL material. It is creatively intellectual, yet minimal enough to not overstimulate and create a learning block. I am exceptionally impressed with this app!

β€œ

Sean Green

Great interesting short snippets of informative articles. Highly recommended to anyone who loves information and lacks patience.

β€œ

Jamyson Haug

Great for quick bits of information and interesting ideas around whatever topics you are interested in. Visually, it looks great as well.

β€œ

Laetitia Berton

I have only been using it for a few days now, but I have found answers to questions I had never consciously formulated, or to problems I face everyday at work or at home. I wish I had found this earlier, highly recommended!

β€œ

Ghazala Begum

Even five minutes a day will improve your thinking. I've come across new ideas and learnt to improve existing ways to become more motivated, confident and happier.

β€œ

Giovanna Scalzone

Brilliant. It feels fresh and encouraging. So many interesting pieces of information that are just enough to absorb and apply. So happy I found this.

β€œ

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.

Email

I agree to receive email updates