Even though you did not study computer science, or you don’t like working with computers, you need the knowledge of spreadsheets, you should at least know the basics of Microsoft Excel, so try your best to participate in any Microsoft Excel Training.
Every profession needs computer, especially now!
Microsoft Excel Training Topics
In this article, I’ll show you quickly how to:
- Create and open workbooks,
- Save and share workbooks,
- Cell basics,
- Format and modify cells,
- Formulas and functions,
- Data and charts,
- Printing workbooks
and many more.
Creating and Opening Workbooks as part of the Microsoft Excel Training
Microsoft Excel files are called workbooks, Whenever one starts a new project in Excel, he/she will need to create a new workbook. There are many ways to start working with a workbook in Microsoft Excel. You can choose to create a new workbook (by selecting a blank workbook or a predesigned template). You can also open an existing workbook.
Steps to Create and Open Workbooks in Excel Backstage
- Select the File menu. The backstage view appears.
- Navigate to the Backstage view and click on Open.
- Select Computer, the Open dialog box appears.
- Browse for the workbook you want in folders, select your workbook, and then click Open.
Saving and Sharing Workbooks as part of the Microsoft Excel Training
When one creates a new workbook in Excel, he/she will need to know how to save it in order to access and update it later. In previous versions of Excel, files are saved locally to your computer. But unlike older versions, Excel 2013 lets you save a workbook to your Microsoft cloud storage using OneDrive. You can always export and share workbooks with other users directly from Excel.
Steps to Save Workbooks in Excel Backstage
- Click on the Save icon on the Quick Access Toolbar.
- If it’s the first time of saving the file, the Save As pane will appear in your Backstage view.
- You will then need to choose a location to save the file and give it a name.
- On the save as dialog box, select your computer, and then click Browse. Alternatively, you can select OneDrive to save the file to your OneDrive Microsoft account.
- Or when the Save As dialog box appears, select the location where you want to save the workbook.
- Enter the file name for your workbook, then click on Save.
- Your workbook is now saved. You can always click on the Save command to save your changes as you modify the workbook.
Understanding Cells in Microsoft Excel
Every worksheet in Excel is made up of thousands of rectangles called cells. A cell is simply the intersection of a row and column. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2,3).
Each cell has its unique name or address, based on its column and row. Cell address always appears in the name box.
Note that a cell’s column and row headings are highlighted when that particular cell is selected.
You can even select multiple cells at the same time. A group of cells is known as Cell Range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon.
A cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.
Formatting and Modifying Cells as part of Microsoft Excel Training
Any information you enter into the spreadsheet will be stored in a cell. Cells can contain several different types of content, including text, formulas, formatting and functions.
Formatting Attributes – Cells can contain formatting attributes that change the way numbers, dates and letters are displayed. For instance, percentages can appear as 0.15 or 15%. You can also change a cell’s background color.
Formulas and Functions in Microsoft Excel
Just like a calculator, Excel can add, multiply, subtract and divide. Keep reading and I’ll show you how to use the cell references to create simple formulas.
Microsoft Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.
All these formulas in Excel must begin with an equals sign (=). This is to show that the cell contains, or is equal to, the formula and the value it calculates. Example:
Types of Functions in Microsoft Excel
Well, there are hundreds of functions in Microsoft Excel, but the ones you use most frequently will depend on the type of data your workbooks contains. There is no need to know or learn every single function in Excel, but exploring some of the different types of functions is advisable, to help you as you create new projects. One can search for functions by categories, such as Financial, Text, Logical, Date & Time, and more from the Function Library on the Formulas menu tab.
Data and Charts as part of Microsoft Excel Training
To create a chart in Microsoft Excel is really simple. Excel provides you a variety of chart types that you can choose from when you want to create a chart. Excel offers Line, Bar, Pie, and Column charts to name but a few. Showing data in a chart can make your work clearer, interesting and easier to read. Charts also help you evaluate your data and make comparisons between different values.
Types of Charts in Microsoft Excel
- Column charts – These can be used as vertical bars to represent data. They work with many different types of data, but they are most frequently used for comparing information.
- Line charts – These are ideal for representing trends. The data points are connected with lines, thereby making it easy to see whether values are increasing or decreasing over time.
- Pie charts – This makes it easy to compare proportions. Each value is shown as a slice of the pie, so it’s easy to see which values make up the percentage of a whole.
- Bar charts – This works just like Column charts, but they make use of horizontal bars instead of vertical bars.
- Area charts – These are similar to line charts, except the areas under the lines are filled in.
- Surface charts – Surface charts allow one to display data across a 3D landscape. They work best with large data sets, allowing you to see a variety of information at the same time.
Steps to Print Workbook as part of the Microsoft Excel Training
Printing your workbook helps you show or share your data offline. It’s really easy to prepare and print your workbook in Excel.
Once you have chosen your page layout settings, you can go ahead to preview and print your workbook using the Print pane.
Here are the steps to print your workbook in Microsoft Excel:
- Select the File menu tab. Then the backstage view appears.
- Select Print. The Print pane will appear.
- Choose options, adjust settings, once you’re satisfied, then click the Print button below to begin printing.
Hope you enjoyed learning Microsoft Excel,
Please comment below, ask questions and share with the world.