<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Michael Covenant Oluwatobiloba on Medium]]></title>
        <description><![CDATA[Stories by Michael Covenant Oluwatobiloba on Medium]]></description>
        <link>https://medium.com/@michaeladeremi45?source=rss-36430309fbb7------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*BnDpKBQA-Fmu5fFKx_t0wA.jpeg</url>
            <title>Stories by Michael Covenant Oluwatobiloba on Medium</title>
            <link>https://medium.com/@michaeladeremi45?source=rss-36430309fbb7------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 05:40:16 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@michaeladeremi45/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[MY FIFTH TASK AS AS ASPIRING DATA EMPRESS]]></title>
            <link>https://medium.com/@michaeladeremi45/my-fifth-task-as-as-aspiring-data-empress-cb74b751581c?source=rss-36430309fbb7------2</link>
            <guid isPermaLink="false">https://medium.com/p/cb74b751581c</guid>
            <category><![CDATA[excel-tutorial]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis-tool]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Michael Covenant Oluwatobiloba]]></dc:creator>
            <pubDate>Tue, 14 Nov 2023 02:45:10 GMT</pubDate>
            <atom:updated>2023-11-14T02:45:10.354Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>MY FIFTH TASK AS AS ASPIRING DATA EMPRESS</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*CTqmfgZb9znbFAsR" /><figcaption>Photo by Microsoft 365 on Unsplash</figcaption></figure><p><em>The embarking on this journey of Excel I must say has been intense and a great time of learning.</em></p><p><em>Hi there newbie and profs, thank you for joining me again on this ride.</em></p><p>My fifth task was double in one that is two tasks with two different datasets combined as one and I’ll be showing you how I got through with it.</p><p><strong>One of Two</strong><br>The dataset contained names of countries and their population size.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/598/1*Oo20INXnBctmNnOamCxNMA.png" /><figcaption>Original dataset as provided</figcaption></figure><p>The objectives of this task was to:</p><ol><li>Freeze panes at row 1;</li><li>Transform the names of the countries to camel case;</li><li>Derive the aggregate, minimum, maximum, average of the population in a separate sheet;</li><li>Derive the total number of countries in the data set in the new sheet created before;</li><li>Find the percentage of each country’s population to the aggregate.</li></ol><p><strong>Freeze panes</strong><br>To freeze panes, i selected row 2 then I navigated my way to view tab after which I located the freeze pane option, I clicked the drop down button then I selected “freeze top row”.</p><p><strong>Camel case</strong><br>To achieve this, I used the proper function. In a new row cell, I input the function: <strong>=proper(select the text)</strong> then enter. Then I went on to replicate to the other cells.</p><p><strong>Third objective: Basic Calculations</strong><br>I first opened up a new sheet, renamed my sheet to be world population data summary,<em> I also did initially rename the first sheet to be world population records.</em></p><p>Then I put in a header in cell A1, then merged and center. In cell A2 gave descriptions such as variables and in cell B2 figures.</p><p>Afterwards, I went on to derive my total world population, minimum, maximum, average and the number of country records we have figures.</p><p>To derive my total population or aggregate, I used the sum function. In the cell destination, I input: <strong>=sum(select the entire population column)</strong> then enter key.</p><p><em>PS: I selected the entire population column by using the shortcut ctrl+shift+arrow down key.</em></p><p>To derive the minimum population figure, I used the min function. In the cell destination, I input: <strong>=min(select the entire population column)</strong> then enter key.</p><p>To derive the maximum population figure, I used the max function. In the cell destination, I input: <strong>=max(select the entire population column)</strong> then enter key.</p><p>To derive the average population figure, I used the average function. In the cell destination, I input: <strong>=average(select the entire population column)</strong> then enter key.</p><p>To derive the number of countries record we have, I used the count function. In the cell destination, I input: <strong>=count(select the entire population column)</strong> the enter key.<br><em>The summary looks like this:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XDWqrBgD3zrYhBPfq50Jdw.png" /><figcaption>Summary report</figcaption></figure><p><strong>PERCENTAGES</strong><br>In our maths class, deriving percentages goes through the formula of dividing the value of one by the total value then multiply whatever you get by 100.</p><p>A quick example, mr A took 15 apples out of a bag of 60 apples, what is the percentage of the apples mr A took out?<br>To get this, we’ll divide the values of 15 by 60, then multiply by 100 to arrive at our answer. Same thing goes with excel.</p><p>To get percentages, we just need to divide our figures by the total and then use excel built-in function to change the figures to be seen as percentages.</p><p>For instance to get the percentage of the first country, I divided the value of it’s population by the total by inputing this in the cell destination. Let’s say the first country is Nigeria, it’s population figure is 250million in cell B3, the total world population is say 5 billion in cell J3. the function will then the written like this: <strong>=B3/J3</strong> then enter key.</p><p>Thus I did with the first country and replicated to other country.<br>However after replicating, I got an error notice and this occurred because excel took the aggregate figure as a series.</p><p>So to correct this, I had to lock down the aggregate figure by making the <strong>cell referenceAbsolute</strong>. This I did by highlight-ing the aggregate figure cell reference like this: =B3/<strong>J3</strong> <em>(note, I didn’t bold it, this is just to show that I highlighted the cell reference of the aggregate figure only).</em></p><p><em>A</em>fter I highlighted it, I clicked on F4 key on my keypad and it added a dollar sign in front of that cell reference to look like this: =B3/$J$3 and with this, I clicked the enter key, then replicated again to the other cells and there we have our figures,</p><p>Hereon instead of multiplying by 100 to get the percentage, we would use Excel inbuilt number format.</p><p>First i selected the entire percentage column (figures without the header), then navigate to the home tab menu, then in the numbers section, I changed it from general to percentages and all figures are now in percentages.</p><p>Lastly, I put the entire dataset into a table.<br><em>And voila our final result looks like this:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1022/1*VIFsLcHqKK259Cgu5kyJhg.png" /><figcaption>Final result.</figcaption></figure><p><strong>Two of Two</strong><br>The dataset contained statistics of police officers in their ranks in different state in Nigeria. The officers ranks includes inspectors, sergeants, corporals and constables.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1023/1*RIWxbbUvXYtMKC744Ej6vA.png" /><figcaption>Original dataset.</figcaption></figure><p><em>The objective of this task is to:</em></p><ol><li>Transform the states names to block letters;</li><li>Find the total number of police officers present in each states;</li><li>Find the total of the different officers;</li><li>In a separate sheet, compute the minimum, maximum, average, count and aggregate number of officers and then also of inspectors;</li><li>Calculate the percentage of officers each state holds;</li><li>Implement conditional formatting in the constables column.</li></ol><p><strong>Objective 1</strong><br>Transforming the states name to block letters is saying change them to upper case.</p><p>For this I made use of the upper function, in the first row of a new column i input the function: <strong>=upper(select the text)</strong>, enter then I moved on to replicate which excel replicated the formula to the other cells.</p><p>Thereafter, i replaced the state column with the new texts. I also went further to sort the data set as the states were not ordered.</p><p><strong>Objective 2 &amp; 3</strong> <br>Finding the total number of officers in each state was achieved by suming up their figures.</p><p>First created a new column to the right with the header totals, then from the first row, used the sum function to add them up and moved on to replicate to the other cells.</p><p>Finding the total of the different officers is similar to the former. However, the figures are presented below the table on a new row.</p><p><strong>Objective 4: Summary record</strong><br>In a separate sheet, I computed the minimum, maximum, average, aggregate and count figures of the officers.</p><p>To derive my total officers, I used the sum function. In the cell destination, I input: <strong>=sum(select the entire total’s by state column)</strong> then enter key.</p><p><em>PS: I selected the entire officers total column by using the shortcut ctrl+shift+arrow down key.</em></p><p>To derive the minimum officers figure, I used the min function. In the cell destination, I input: <strong>=min(select the entire total’s by state column)</strong> then enter key.</p><p>To derive the maximum officers figure, I used the max function. In the cell destination, I input: <strong>=max(select the entire total’s by state column)</strong> then enter key.</p><p>To derive the average officers figure, I used the average function. In the cell destination, I input: <strong>=average(select the entire total’s by state column)</strong> then enter key.</p><p>To derive the number of state officer’s record we have, I used the count function. In the cell destination, I input: <strong>=count(select the entire total’s by state column)</strong> the enter key.</p><p>Thereafter, same process was taken to get the average, totals, minimum, maximum and count figures of the inspectors, only that the range of value changes from the totals column to the inspectors column.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Hg8Y2LemsBvDLnACeChP6A.png" /><figcaption>Summary report.</figcaption></figure><p><strong>Objective 5: Percentages</strong><br>To get percentages, we just need to divide our figures by the total and then use excel built-in number format to change the figures to be seen as percentages.<br>However, here we’ll be dividing our totals figure by our overall aggregate value. <br>Following the same process above as in the population figures, same was applied here as well.</p><p><strong>Objective 6: Conditional Formatting</strong></p><p>Excel Conditional Formatting is used to apply certain formatting to data that meets one or more conditions. Just like usual cell formatting, it lets you highlight and differentiate your data in various ways by changing cells&#39; fill color, font color, border styles, etc. The difference is that it is more flexible and dynamic - when the data changes, conditional formats get updated automatically to reflect the changes.</p><p>Conditional formatting can be applied to individual cells or entire rows based on the value of the formatted cell itself or another cell. To conditionally format your data, you can utilize preset rules such as <a href="https://www.ablebits.com/office-addins-blog/color-scales-excel/">Color Scales</a>, <a href="https://www.ablebits.com/office-addins-blog/data-bars-excel/">Data Bars</a> and <a href="https://www.ablebits.com/office-addins-blog/excel-icon-sets-conditional-formatting/">Icon Sets</a> or create custom rules where you define when and how the selected cells should be highlighted.</p><p>To get this, I first highlighted the constables column then navigate my way to the home ribbon menu and under the styles tab, I clicked on conditional formatting, selected the type I wanted, in this case I used data bars and that’s it.</p><p>Lastly, I format the entire dataset into a table, renamed my sheets as well and Done is me.</p><p><em>Viola our final result looks like this:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/889/1*-T-2gT9hl5H1E8u3L4c0tw.png" /><figcaption>Final result.</figcaption></figure><p><em>Be sure to try this as well.<br>Till next time… <br>Caio.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cb74b751581c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SOME BASIC EXCEL FUNCTIONS]]></title>
            <link>https://medium.com/@michaeladeremi45/some-basic-excel-functions-1bb657872669?source=rss-36430309fbb7------2</link>
            <guid isPermaLink="false">https://medium.com/p/1bb657872669</guid>
            <category><![CDATA[data-analysis-tool]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[excel-learning]]></category>
            <dc:creator><![CDATA[Michael Covenant Oluwatobiloba]]></dc:creator>
            <pubDate>Tue, 14 Nov 2023 02:01:49 GMT</pubDate>
            <atom:updated>2023-11-14T02:01:49.802Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*35-NtSMK3_-RTzu4" /><figcaption>Photo by Rubaitul Azad on Unsplash</figcaption></figure><p>Excel is one of the most widely used spreadsheet in the world and it is so because of it’s ability to make simple and basic calculations easily and without stressing the user.</p><p><em>Hi there newbie and profs, join me in this article as I’ll be exploring some of the most basic excel functions I used in tackling my third and fourth task as an aspiring data empress. As some of these functions have been dealt with previously, I’ll leave a link to check them out. </em><a href="https://medium.com/@michaeladeremi45/my-first-task-as-an-aspiring-data-empress-2fd8a71d1f36"><em>My first task as an aspiring data empress</em></a></p><p>Just so you guys know, my tutor gives at least 2 tasks weekly and most times about 4 task weekly. Oh boy but its been fun working on them.</p><p><strong>My third task as an aspiring data empress</strong></p><p>Original data used for this task was provided by my mentor. The aim as always is to implement as much function we’ve been taught as possible, so I am to transform this data:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OPcAAGadumBUhneJ9r1m0Q.png" /><figcaption>Original data worksheet provided</figcaption></figure><p><strong>OBJECTIVES</strong></p><ul><li>Complete the Matric number series;</li><li>Transform the names into camel case;</li><li>Make the status be “ABOVE MIN WAGE-RATE” if salary is 33,000 and above while “BELOW MIN WAGE-RATE” if below 33,000;<br>Weekly salary should be in your preferred currency;</li><li>Find the average, minimum and maximum salary as well as staff’s count;</li><li>Find the aggregate salary;</li><li>Freeze panes at row 5;</li><li>Solve the error in cell B4;</li><li>Name the sheet as appropriate.</li></ul><p><strong>Fill Series</strong><br>I made use of this excel option to achieve my first objective.<br>As a part of excel inbuilt function called Auto-fill options, <em>Fill series is an operation in excel that allows you to generate a sequence or series of values in ascending order.</em></p><p>To use this, just select the first cell then move your cursor towards the bottom right and you’ll notice your cursor change to a thin black cross, this is called the fill cross, using that cross just drag down and excel automatically fills in the rest. And if not, just below you’ll see a small options box called auto-fill options, just click it and select fill series.</p><p><strong>Proper Function</strong><br>For my second objective, I made use of this Function. <br>This function is part of Excel’s three text functions. First the upper converts text to capital or block letters or upper case, the lower function converts all text to lower case and <em>the Proper function capitalizes the first letter of each word leaving the rest in lower case.</em></p><p>In the new cell which is my destination for the corrected names, in the first cell I input the function: <strong>=proper(select cell B6)</strong> then enter key and it gives me the corrected name. Then I move on to replicate to the other cells as always.</p><p><strong>Randbetween Function</strong><br><em>The randbetween function is a function that helps us to generate random and dynamic numbers.</em><br>For objective three, I only needed to replicate to other cells as the first cell already has the function(randbetween function) inputed.</p><p>So I replicate by using my cursor to drag down from the first cell, to the last cell and it generates random numbers, then I move on to making them static and also added my currency in naira.</p><p><strong>IF Function</strong><br>This is one of the most popular function in excel and <em>it allows you to make logical comparisons between a value and what you expect.</em> In other words, it is a logical function that evaluates a certain condition and returns the values based of True or False. That is, it can have only two answers TRUE OR FALSE.</p><p>Thus for objective four, I used the IF FUNCTION to achieve that.<br>In the first cell, I input the function: <strong>=IF(D6&gt;=33000, &quot;Above min wage-rate&quot;, &quot;Below min wage-rate&quot;) </strong>then my enter key and moved on to replicate to the other cells as well.</p><p>For my preferred currency, I chose Naira. Well cause it’s only Nigeria that has a minimum wage of 33,000.</p><p><strong>Statistical Functions</strong><br>These are some of the premade functions in Excel and they include but not limited to:<br><strong>Average</strong><br>This is a statistical function and <em>it calculates the average value of a given series or range of numbers.</em> <br>Finding the average salary, In a cell I inputed the function: <strong>=average(select the entire column of salary) </strong>then enter key.</p><p><strong>Minimum</strong><br><em>It is a pre-made function in Excel which finds the lowest number in a range of values. </em>For the minimum salary, in another cell I inputed the function: <strong>=min(select the entire column of salary)</strong> then enter key.</p><p><strong>Maximum</strong> <br><em>This function finds the highest figures our of a range of values.</em> For the maximum salary, In another cell I inputed the function: <strong>=max(select the entire salary column)</strong> then enter key.</p><p><strong>Count</strong> <br><em>This function counts the number of cells that contain numbers, used to get the number of enteries in a number field that is in a range.</em></p><p>To determine the total number of staff, In a new cell, I input the function: <strong>=count(select the salary column) </strong>then enter.</p><p><strong>Sum</strong> <br><em>This function basically adds values either in a range or even if in different columns.</em></p><p>To arrive at the aggregate or total amount of salary, In a new cell, I input the function: <strong>=sum(select the entire salary column)</strong> then enter.</p><p><em>Side note</em><br><em>At first I tried the count function on the texts that is the names column, however I kept getting zero (0) as my answer. Then I decided to try again using my number column that is my salary column and I got my answer. Thus, I came to the conclusion that count function only works with numbers and not with texts.</em></p><p><strong>FREEZE PANES</strong><br><em>Freeze pane is a tool in excel that allows us to pin down or lock down a particular row or column such that they remain visible while i scroll through the rest of my dataset. </em>Very useful when working with large datasets as it makes it easier to understand the context of the data.</p><p>To achieve this, firstly select the row below the row you want to freeze then navigate your way to the view tab. Locate the freeze panes option, click the dropdown button then select “freeze top row” and it freezes. To unfreeze the panes, you go through the same process.</p><p><strong>Today Function</strong><br><em>It’s a function that records the particular date you’re working on that file, and it generates date according to the date on your system. </em>Basically, it is used to derive Today’s date. Thus, In cell b4 I input the function: <strong>=today()</strong> then enter key.</p><p><strong>Renaming my sheet</strong><br>This was easy, I had to determine which department of an organization deals with staff and then the data gives information about their payroll, thus I named the sheet HR STAFF PAYROLL.</p><p><em>And voila here is our final result:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1009/1*KN0SPitKc_FVc95utSPZQA.png" /><figcaption>HR STAFF PAYROLL RECORD</figcaption></figure><p><em>Do be sure to try this out as well.</em></p><p><strong>My Fourth Task as an Aspiring Data Empress</strong></p><p><em>I decided to add it to this article as it wasn’t much. I used basic function such as multiplication and fill series. </em><br>For this task, we were asked to make a multiplication chart of 50 by 50.<br>Oh boy, normal charts end at 20 but then I had a deadline to meet.</p><p><strong>Multiplication</strong></p><p>This in itself isn’t a formula in excel. To do this we use operators to calculate this.</p><p>Operators in Excel formulas tells us what type of calculation to perform. Common operators are:</p><ul><li>Multiplication denoted by (*)</li><li>Division denoted by (/)</li><li>Addition denoted by (+)</li><li>Subtraction denoted by (-)</li><li>Cell referencing denoted by :</li><li>Text concatenate denoted by (“)</li><li>Etc.</li></ul><p><strong>Solution</strong></p><p><em>From cell A1, I decided to give it a name and I settled with Multiplication table 50 by 50.</em><br>From cell A2, I filled series from number 1 to 50, then replicated it to the right side as well that is I filled the series to the right as well.</p><p>From cell B3 I begin my multiplication. For the multiplication, I multiplied column A by all figures in row 2 and then duplicate to other cells. In the cell B3, I input: <strong>=A3*B2</strong> which gives me 4, then I replicate by using my cursor to drag down and excel automatically replicates the formula to the other cells.</p><p>Same thing is done for cell C3, I input: =A3*C2 then enter which is gives me 6, then I replicate to the other cells. I did that till my chart was completed.</p><p>Then I moved on to putting in into a table, I selected the entire data from cell A2 by using ctrl+shift+arrow right key (to select to the end of the data on the right), then with my hands still on ctrl+shift keys, I also press the arrow down button (to select the entire data downward). after selecting the data, from my home tab, I use the <strong>FORMAT TO TABLE</strong> key, pick any table colour of choice, a small dialogue box appears, make sure the box of my table has header is ticked and then ok, the table applies to my data.</p><p><em>And voila my final result looks like this:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PsRKvYoEnKNx_aNMpwuudw.png" /><figcaption>Multiplication Table 50 by 50</figcaption></figure><p><em>Be sure to try this out.<br>Caio.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1bb657872669" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My Second Task as an Aspiring Data Empress]]></title>
            <link>https://medium.com/@michaeladeremi45/my-second-task-as-an-aspiring-data-empress-48ad34d52465?source=rss-36430309fbb7------2</link>
            <guid isPermaLink="false">https://medium.com/p/48ad34d52465</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis-tool]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel-tutorial]]></category>
            <dc:creator><![CDATA[Michael Covenant Oluwatobiloba]]></dc:creator>
            <pubDate>Sat, 28 Oct 2023 14:09:36 GMT</pubDate>
            <atom:updated>2023-10-28T14:09:36.108Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>My Second Task as an Aspiring Data Empress</strong></p><p><em>Hey there, thank you for reading this. Dear newbie and profs join me as I walk you throughss my second task, if you missed my post on my first task, here is a link to read on it:</em></p><p><em>https://medium.com/@michaeladeremi45/my-first-task-as-an-aspiring-data-empress-2fd8a71d1f36</em></p><p>This task was also given on the second week of classes by my tutor.</p><p>The objective is to:</p><ol><li>Create a mock store with 10 goods;</li><li>Generate random units sold and random unit price;</li><li>Generate the Quantity sold;</li><li>Generate the Total amount of goods sold by your store.</li></ol><p><em>Oh well this is all but the accountant in me wasn’t satisfied with just this, so I added a little extra objectives to include:</em></p><ol><li>Generate random units bought;</li><li>Generate the cost price of goods;</li><li>Generate the total amount of goods bought by my store;</li><li>Generate the total amount of purchases;</li><li>Generate the total amount of sales;</li><li>Determine if we made a Profit or we Incurred a loss.</li></ol><p><em>P.S: for this task, we’ll still be making use of most of the functions or formula used to complete the first task, so if at any point you don’t get anything here, refer back to my article on the first task through this link:</em></p><p><em>https://medium.com/@michaeladeremi45/my-first-task-as-an-aspiring-data-empress-2fd8a71d1f36</em></p><p>On a new excel workbook, we give headers to different cells<br>In cell A1, I typed in the name of the store and the month of the data we’re dealing with was generated. So I named my store <strong>Empress Store</strong>, and we’ll be dealing with purchases and sales from the month of September.</p><p>Thus rendering in the accounting format, I inputed it as <strong>Empress Store Purchases and Sales Account as at 30th September 2023</strong>. then very important I need this to cover the entire expanse of my data, so I selected cells A1, B1 down to H1, then from the home menu I used the merge icon and merged the cells, I selected <strong>merge and centre.</strong> This merged the cells together and moved the heading to the centre.</p><p>Then I named the other cells, from s/n to goods, units bought, cost price, purchases, units sold, selling price, sales. I then went on to generate the goods sold in my store.</p><p>For the serial number, I used <strong>fill series</strong> to fill in the figures. <br>Then I went on to generate the units bought using the <strong>RANDBETWEEN Function</strong>, in cell C3 I inputed the function: <strong>=randbetween(30,60),</strong> then I went on to replicate the function to the other cells and also made the figures static.</p><p>Also to generate the cost price, I used the same randbetween function, in cell D3 I inputed the function: <strong>=randbetween(3000,3500),</strong> then I replicated the function to the other cells and also made the values static.</p><p>To generate my purchases, I multiplied figures in cells C by figures in cell D. let’s take cell E3 for example, to get the purchases, I inputed the function: <strong>=C3*D3</strong> then the enter key and voila. Then replicate to the other cells as well.</p><p><em>Note: your purchases won’t have the currency sign if you haven’t added it to your cost price as well, so first add the currency sign to the cost price, or you can very well just manually add to the cost price afterwards and then also add it to the purchases.</em></p><p>For my Units Sold, I also used the <strong>randbetween function</strong> to generate the figures by inputing in cell F3 the function: <strong>=randbetween(25,45),</strong> then moved on to replicate it to the other cells and also make the figures static.</p><p>Same process also for my selling price, however in cell G3 and the function used is: <strong>=randbetween(3500,4000).</strong></p><p>For the Sales cells, we multiply figures in cells F by figures in cells G. example for cell H3, the function would be <strong>=F3*G3</strong> then press enter key.</p><p><em>Note: your sales won’t have the currency sign if you haven’t added it to your selling price as well, so first add the currency sign to the selling price, or you can very well just manually add to the selling price afterwards and then also add it to the sales.</em></p><p>To arrive at the totals for the total goods bought, total goods sold, total purchases and total sales, in the row created for it, input the <strong>SUM function</strong>.</p><p>Example for total goods bought, the function would be <strong>=sum(select the entire column by clicking on the first figure and the ctrl+shift+arrow down button)</strong> then press enter key <br>I Repeated the same for the entire column figures i need to add up to get their total.</p><p>Lastly, <em>a good stuffs requires beautification mehn</em> so we’ll put it into a <strong>Table</strong>.</p><p>Select the data from the second row I.e from row number 2, from A2, then select the entire data shortcut is ctrl+shift+arrow right side button (to select to the right) then ctrl+shift+arrow down button (to select down).</p><p>From the home menu navigate to format as table then choose any table colour setting of your choice.</p><p>For the name of our store, we’ll be formatting the cell seperately, in the home menu tab underneath the format as table, you’ll find the cell format icon, click on it and select any header design of your choice.<br><em>And voila our final results looks like this:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IZWWdG0hdcInbaN5rag8Ew.jpeg" /><figcaption>Final figures shows we ran at loss in the month of September... Oh boy we need to up our sales.</figcaption></figure><p>From the figures above, we’ll notice that the purchases is more than our sales, in accounting this means that we ran at a loss because our cost of purchases is more that our income or revenue generated from sales.</p><p><em>That’s all for the second task.<br>Don’t forget to rename your workbook and sheet.<br>Be sure to also try this out.<br>Caio.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=48ad34d52465" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[MY FIRST TASK AS AN ASPIRING DATA EMPRESS]]></title>
            <link>https://medium.com/@michaeladeremi45/my-first-task-as-an-aspiring-data-empress-2fd8a71d1f36?source=rss-36430309fbb7------2</link>
            <guid isPermaLink="false">https://medium.com/p/2fd8a71d1f36</guid>
            <category><![CDATA[excel-training]]></category>
            <category><![CDATA[data-analysis-tool]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Michael Covenant Oluwatobiloba]]></dc:creator>
            <pubDate>Sat, 28 Oct 2023 13:51:39 GMT</pubDate>
            <atom:updated>2023-10-28T13:51:39.538Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>MY FIRST TASK AS AN ASPIRING DATA EMPRESS</strong></p><p><em>Hey Newbie or prof, I am back again guys and I would like to share with you my first task on Excel during my training in the ladies talk tech program, and how I went about it plus the mistakes I made and how I went about correcting it.</em></p><p>The aim of this task and every other is to implement all that we were taught in class that week.</p><ol><li>My objective during this task is to:<br>Pick out any area of interest of choice, example business, tech, politics, agriculture, sports.</li><li>Find the first name and the last name of at least ten personalities in that area of interest of choice.</li><li>Derive their full names.</li><li>Generate random ages for them.</li><li>Generate random monthly income for them.</li><li>Generate their annual income.</li><li>Put in a Table Format.</li></ol><p><strong>Objective 1 &amp; 2</strong><br>This was quite easy for me, I chose sports and definitely not Football. I chose Tennis, a bit of basketball and a bit of athletics to make up twenty people which would be used to answer the rest of the objectives<br>To derive their names, I took to google a student’s best friend for all days and voila it gave me lots of names, so I made a few picks, typed them into my new excel sheet as seen below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kVEMGCtyq67fAHoFLQoQ-A.jpeg" /><figcaption>Noticed my error? I made tabs for first name and last name separate, but I ended up putting them on same cell</figcaption></figure><p>Firstly, I moved on to deriving the serial number for the list of names I made, and to do that I used <strong>Fill series. </strong><br>Fill series is an operation in excel that allows you to generate a sequence or series of values in ascending order. To fill this series, on the first column of that row, I input the first number 1 then dragged down till the last column having the last name. Thereafter, I clicked on the small icon by the side that said Auto-fill options, then picked Fill series and it gave me this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Yz25aw3GVOAQMiWCweIN8Q.jpeg" /><figcaption>Spot a difference from the first image? Yeah now the cells for the last name has been deleted.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3SKj2bnD_xJGO6sjqmv7DA.jpeg" /><figcaption>I intentionally typed in Lastname to the header so I can work on the data, I left a space in between firstname and lastname as it&#39;s necessary for cleaning the data</figcaption></figure><p><strong>How i solved the error made</strong></p><p>On the new excel sheet I was to separate the first names from the last names, but while typing it into the sheet, I just jumbled them all up into one cell and row. So then how do I solve this problem……hmm I used <strong>Text to column</strong> to clean the data.</p><p>Text to column is used basically to separate texts on one column to another or two different columns.<br>The first thing I did was to insert two new column then highlight the column I want to work on. Then moved over to the data tab then select the text to column key.</p><p>A dialogue box popped up of 3 steps, for step 1, I chose Delimited then clicked next, the next step asked for what was delimiting my data of which I clicked space and I un-ticked the option of tab that excel initially picked. In step 3, I left general the way it is, but I changed the destination of the corrected data from cell B1 to cell C1 then clicked finished. It reproduced the data on the two new columns I inserted, then I erased the row with the joined names. This is what I arrived at:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5lgFD9IW645N65JP0G8p6Q.jpeg" /><figcaption>That really didn’t take time smiles.</figcaption></figure><p>For my third objective, which is to derive their full names back into one single column. <em>Someone would ask why then did I delete the row with their full names? Oh well, this aspiring data empress is just wants to use excel functions</em> thus to derive this, we’ll use the <strong>CONCATENATE Function. </strong><br>Concatenate function is a function that enables us to join two words from different cells together into one cell instead of manually typing them in. To derive their full names, I go to the cell allocated for that as see below, from the first cell D2, I start by inputing the equal to sign (=) which is used to write out a function in excel. So that will be <strong>=CONCATENATE(B2,space”space”,C2) then press the enter key.</strong></p><p><em>P.S: I had to type out literally that you need to click space in those places.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kOijrq_HwCAFv3-SgJdzoA.jpeg" /><figcaption>For my second error, You’ll notice that I misspelled my concatenate and after clicking, I got an error message and so I had to check my spelling and try the function again of which I got it.</figcaption></figure><p>So to fill in the function for the rest of the list, I just need to use my cursor to drag down from that cell till the last one and the function replicates.</p><p>For the fourth objective which is to generate ages for them, we’ll be using the <strong>RANDBETWEEN Function.</strong> The randbetween function is a function that helps us to generate random and dynamic numbers. To do this, in the first cell of the row which is E2, I inputed the following function <strong>{=randbetween(30,45)},</strong> so like that it generated random ages between 30 and 45. Then drag down with your cursor to replicate the function into other cells.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*A7JB6Wd8A13eQE_bIGeipg.jpeg" /></figure><p>However, these numbers are dynamic in that they change with every operation done on excel. So to make them static, we’ll select the entire row <strong>(ctrl+shift+arrow down button)</strong> then copy the paste into that same rows, cell and position, but we’ll paste them as values instead (when you right click to paste, you’ll see different paste option then click paste as values).</p><p>On to my fifth objective <em>oh boy its not so hard,</em> its just same procedure as above, however the values are different, you can input any values of your choice. But the extra thing here is adding of currency sign, so most of the guys on the list either earn in dollars or euro, however I went with euro which I did by first highlighting the entire row, then navigate my way to the general tab on the home page, then changed it to currency. <em>My system default is in euro by the way, yours might not.</em></p><p>For my sixth objective which is to derive their annual income <em>phew</em>, I would be <strong>multiplying</strong> the figures in cells F and multiply by 12 months.<br>On cell G2, I input <strong>{=F2*12}</strong> then makes sure to replicate the same into the other cells as we’ve always done.</p><p>Lastly, <strong>table formatting</strong>. Really our data looks very presentable enough o but we want to add colour to beautify it, so we <strong>format as table.</strong> You start by selecting the entire data (ctrl+A) then on the home tab you’ll see format as table then select any colour of your choice or you could go through the shortcut of pressing (ctrl+T) after selecting the entire data then a dialogue box pops up, make sure the box of my table has headers is ticked and press ok.</p><p><em>And voila here is my final result:</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JDshhLlXMMvmDNUnB4nAqw.jpeg" /></figure><p><em>Be sure to try this out. <br>Don’t forget to rename your file and sheet name plus to save your document.<br>Ciao.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2fd8a71d1f36" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Check Out My First Medium Post
Tried searching for a better heading for this post, but none could…]]></title>
            <link>https://medium.com/@michaeladeremi45/check-out-my-first-medium-post-tried-searching-for-a-better-heading-for-this-post-but-none-could-ab7fabe9d038?source=rss-36430309fbb7------2</link>
            <guid isPermaLink="false">https://medium.com/p/ab7fabe9d038</guid>
            <category><![CDATA[writing]]></category>
            <dc:creator><![CDATA[Michael Covenant Oluwatobiloba]]></dc:creator>
            <pubDate>Thu, 26 Oct 2023 22:14:45 GMT</pubDate>
            <atom:updated>2023-10-26T22:14:45.840Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Check Out My First Medium Post</strong><br><em>Tried searching for a better heading for this post, but none could fit and couldn’t come up with another,so let’s just stick with this and slide right into what I have for you.</em></p><p>Rightly said, this is my first medium post...yayyy and am super excited at the moment.<br>Although I wasn’t all that excited the first time I realized I would be doing this, writing up bi-weekly report on medium, for me it felt like stress yeah cause I didn’t think I was cut out to be a writer, and I still don’t but am willing to give this a try and go with it.</p><p>It all started after I applied for a four month tuition free program organized by Ladies talk tech. In the program different courses are taught for four month and its free ranging from data analysis to UI/UX and the likes, you know them, of which I chose Data analysis.</p><p>In the first class of the first week of the program, our tutor announced what we’ll be doing throughout the entire program and tools we’ll be learning such as Microsoft Excel, Microsoft PowerBi and MySQL and he also announced we’d be posting an article on medium bi-weekly, at that point my heart sank that what, why!!! but I knew there was nothing to do but to just do it.</p><p>However, it wasn’t my first time hearing about medium. I remembered reading an article from one of my big brothers in the Faith @DR Chibs <em>(and yeah you got that right,a church girl)</em> right here on medium and yessss it was an insightful read.....here’s a link to the post <a href="https://medium.com/@rdchibs/my-becon-2022-experience-678761404f01">https://medium.com/@rdchibs/my-becon-2022-experience-678761404f01</a>, <em>(read and be blessed)</em></p><p>Thus, after opening my medium account, I took time to read through posts on medium, get to know how it works, followed different authors some of which are in the field of data analysis, and reading through their posts has been helpful, seeing them walkthrough different projects they’ve worked on step by step has made me want to learn this data thing well, master it and grow.</p><p>Like earlier stated, now I am super excited doing this, so join me on this exciting journey as I take you through my entire time learning to be a data analyst through the four month long training by Ladies talk tech 1.0.</p><p>And it doesn’t end there, expect also talks of my journey after the program also my personal journey and some talks on my Faith as well.</p><p>It promises to be an exciting one<br><em>Caio</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ab7fabe9d038" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>