Excel Fundamentals Everyone Should Know

Basic Math

  • Excel is a great calculator for basic and complex math formula
  • / for division
  • + for addition
  • - for subtraction
  • * for multiplication
  • = to start a formula
  • () to separate functions
Insert Rows and Columns
  • Ctrl + Spacebar = Select Column
  • Shift + Spacebar = Select Row
  • Insert Row = Ctrl + Shift + "+"
  • Insert Column = Ctrl + "-"
Sum
  • Basic addition is the most common feature we use in Excel
  • Enter a formula =Sum(A+B+C+D)
  • Use your mouse = Sum (Drag Mouse)
  • Auto Sum = Type Alt + "=" at the base of the data
Auto Fill
  • Double click mouse on the lower right of 1st cell
  • Highlight section and type Ctrl + D
  • Drag cell down the rows
Average
  • The world works on average
  • Enter a formula = Average(A+B+C+D)
  • Use your mouse = Average(Drag Mouse)
Sort and Filter
  • Highlight data
  • Go to data ribbon
  • Select Sort or Filter
Pivot Tables
  • Highlight the data
  • Go to insert > Pivot Tables

Comments

Post a Comment

Popular posts from this blog

What is Web3? Here’s a detailed explanation

Image
  What is Web3? Here’s a detailed explanation Web3 is being touted as the future of the internet. Infact, it is the new iteration of the World Wide Web, incorporating concepts like blockchain technologies, decentralization, blockchain technologies, and token-based economics. By Jasmine Anand : The World Wide Web has created a strong and robust infrastructure on which it thrives. However, a handful of centralized entities have a stronghold on the vast ocean of the World Wide Web, and unilaterally decide what should and should not be allowed. The answer to this problem is Web3, which embraces decentralization and is being built, operated, and owned by its users. In order to understand Web3, let us first understand what Web1 and Web2 are all about. Web1: Read Only Initially, there was Web1, the internet we all know and love, i.e., the physical infrastructure of wires and servers that lets computers, and the people in front of them, talk to each other. In short, it was the read-only we...
Read more

7 Best YouTube Channels To Learn

  Alex Hormozi - YouTube How to build an irrestible offer How to start and scale your business and make a tonne of money Hamza - YouTube Hamza creates videos around masculinity, success, fitness and mental health to help young men find where they fit in the grand scheme of things What you’ll learn: • How to improve your mental health • The path to being a high-value man Ali Abdaal - YouTube Ali is a former doctor, turned entrepreneur, and productivity expert. What you’ll learn: • Evidence based strategies to be more productive • Evidence based strategies to build a life you love More Plates More Dates - YouTube More Plates More Dates Derek creates videos around self-improvement - primarily training and nutrition What you’ll learn: • The pro’s and cons of supplements, training methods and PEDs • Who’s a fake natty 5. Graham Stephan Graham Stephan - YouTube Graham is a real estate agent and investor with over $120M in real estate sales since 2008. What you’ll learn: •...
Read more