3.2 Microsoft Excel
Now, we move on to Excel! This is a data processing tool. With Excel, you can clearly display your data in spreadsheets and charts. It is easy to use and saves you from having to buy business management software. This tool is a real time-saver and essential for monitoring cash flow, calculating costs, and more generally, for any custom calculation document (management, organisation, schedules, budget follow-up, etc…).
As an entrepreneur, this software will be perfect to do your accounting for example!
To learn the basics of Excel, we suggest you watch this video. It will give you the keys to better understand how this tool works.
Now that you know more about Excel, it’s time to put into practice all the knowledge you learned in the video!
Activity: Discovering Microsoft Excel (20min)
The goal of this activity is to get you to manipulate this tool by creating a table, its data, and simple formulas! If you have any problems, don’t hesitate to review parts of the video.
- Locate Microsoft Excel on your computer and create a new document.
- Activate the cell whose address is A2.
- Write “Month” and press “Enter”.
- In the following cells, enter the corresponding contents :
- Sales price
- Quantity sold
- Complete the entry with the following values in the table (from B3:B14 to C3:C14):
- Lay out the text in the cells and adjust the size of the columns.
- Add the borders.
- Save the file as “Accounting”.
- Enter the “January” Text in cell A3 and automatically complete the series until December.
- Sort the table from the highest to the lowest selling price.
- Rename the Sheet1 to “Turnover 2021”.
- Write “Monthly turnover” in D2.
- Write “=B3*C3” in D3. This will give you the monthly turnover. Do the same for the other months.
- In B16, write “Annual turnover”.
- In C16, calculate the annual turnover with a formula.
- In B17, write “Average annual turnover”.
- In C17, calculate the average annual turnover with a formula.
Additional exercise: Mail Merge (15min)
Too easy? Want to go further? No problem! We have an additional tutorial on the function Mail Merge! This exercise combines both Word and Excel. It will allow you to automate the creation of letters, labels, envelopes… For a considerable saving of time!