Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Princess Profile picture
Princess
@_Datagirlie__
I speak English and Data📊|| Book-tro-vert📚|| Geologist🗻👷‍♀️|| planning @gis_fest|| John 9:5❤|| #LFC #20dayswithMsExcel
Jul 4, 2023 • 15 tweets • 2 min read
DAY 2: INTRODUCTION TO EXCEL FUNCTIONS📉
Excel functions is one part in studying excel that cannot be avoided. Getting the basic understanding of excel function is key to understanding more complex functions in excel.

A Thread🧵 On the FORMULAS tab in the Ms Excel, worksheet contains the Function Library, Defined Names, Formula Auditing, Calculation. The Function Library contains all the excel functions based on the type and uses.
Jul 2, 2023 • 12 tweets • 3 min read
DAY 1: DATA TYPES IN MICROSOFT EXCEL 📊
Starting out with Microsoft Excel, it is important to know and understand the different data types present in the tool, because this affects how we make use of the tool.
#20dayswithMsExcel

A Thread🧵 -There are 4 types of data in the Microsoft Excel tool.

• Text
• Numeric
• Boolean
• Error

-You may perform different functions with each type as a Data Analyst, so it's important to know which ones to use and when to use them.
May 26, 2023 • 6 tweets • 2 min read
FUNCTION ARGUMENT WINDOW IN EXCEL📊.
To get a basic understanding of excel formulas and funtion( SUM,COUNT,MIN, MAX etc) as a beginner in data analysis learning excel, the use of the Fucntion argument window is relevant and will also be a guide to gain understanding.

A Thread🧵 Image -The Function Argument Window or Dialog box is helpful when building a formula. It helps to list the argument required for the function, identify which arguments are required or optional, show the result of a calculation or initial result of the function.
#data #excel
May 24, 2023 • 8 tweets • 2 min read
BUILDING BLOCKS OF EXCEL FUNCTIONS

As a newbie in Data Analysis📊 that is starting out with Excel, it's is important to not just know Excel Functions but understand the building blocks of an Excel Function.

A Thread🧵 Image What is a Function?

A function is a predefined formula that performs calculations using specific values in a particular order.
May 22, 2023 • 6 tweets • 1 min read
As a Data Analyst it is very easy to forget some easy and simple EXCEL Shortcut keys📊
Yes! It's Monday and a reminder of these shortcut keys will make your work easy and less stressful😊
SIMPLE EXCEL SHORTCUT KEYS📊

A Thread🧵 •Ctrl + W: Close a Spreadsheet

•Ctrl + O: Open a Spreadsheet

•Alt +H: Go to HOME tab

•Alt + N: Go to INSERT tab

•Alt + P: Go to PAGE LAYOUT tab

•Alt + A: Go to DATA tab

•Alt + W: Go to VIEW tab

•Alt + M: Go to Formula tab