Kudehinbu Oluwaponle Profile picture
Dec 4, 2021 6 tweets 3 min read Read on X
Inspired by Dr Abah's #NaijaKnowledgeX.
This thread is a primer on Excel, audience should at least have basic computer literacy.
Would love to get your feedback

1. Open the Excel App on your system. If you don't see a blank workbook, click File->New->Blank Workbook
2. An Excel workbook contains sheets made up of rows , column and cells. Each cell is named after the row and column it belongs to.
I have highlighted row 5 and column B. The intersecting cell is B5.
You insert data by clicking directly on a cell
We'll work with sample IGR data of top 5 states (alphabet) for q1 and q2 provided by NBS - Figures in billions of naira.

3. The first rows and columns are often used by convention as headers/title.
We'll play with the data below
4. To add (and subtract and practically every other arithmetic). click the cell where you want the result to appear and then click the formula bar (shown below), type "=" and then type the operation you want to perform e.g =B3+B4 or =c3 - c4
#NaijaKnowledgeX
5. To use formulas, let's find the average across the states for Q1.
Click the cell you want the results and type in the formula bar =AVERAGE(B3,C3,D3,E3,F3), since the cells are in a contiguous range, you can shorten to =AVERAGE(B3:F3), then press Enter.
6. To create a chart, Click the row (or column) with the data, (you can ctrl click the corresponding header to give the graph more info).
Then click Insert tab->Pie (or any other chart)

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Kudehinbu Oluwaponle

Kudehinbu Oluwaponle Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @koluwaponle

Jun 5, 2021
If you want to access a restricted site e.g. Twitter.
You don't want to pay for VPN and you're rightly concerned about the security risk of free VPN. They can breach sensitive data, steal your identity and wipe out your bank account
Follow these steps...1/
#VPN #TwitterBan
Download Opera Brower from the android Playstore (Not Opera Mini please)
Opera itself...2/
After downloading and installing click on the Opera icon on the bottom right... 3/
#VPN #TwitterBan
Read 6 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(