Microsoft Excel Tutorial. Page 2. 1. Microsoft Excel is one of the most popular spreadsheet applications that helps you manage data, create visually persuasive . Microsoft Excel Basics. Microsoft Excel is a spreadsheet is the computer equiva- lent of a paper ledger sheet. It consists of a grid made from columns and rows. Apr 2, The basic spreadsheet tips here will help you start learning Excel on your own. This guide is available to download as a free PDF. are struggling with it as a beginner, or just want the basics to then learn it on their own.
|Language:||English, Spanish, German|
|Genre:||Fiction & Literature|
|ePub File Size:||23.83 MB|
|PDF File Size:||13.82 MB|
|Distribution:||Free* [*Register to download]|
Excel for Beginners. TechCenter - The Public Library of Cincinnati & Hamilton County echecs16.info INTRODUCTION. Excel is a spreadsheet. Create formulas by using some of Excel's built-in functions. •. Filter and . Cell Basics. to use another file type, such as a PDF or Excel workbook. Updated: 1/16/ Microsoft Excel for Beginners. hours. This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to.
Save settings Customization of ribbon The above image shows the default ribbon in Excel Let's start with customization the ribbon, suppose you do not wish to see some of the tabs on the ribbon, or you would like to add some tabs that are missing such as the developer tab. You can use the options window to achieve this. Click on the ribbon start button Select options from the drop down menu. You should be able to see an Excel Options dialog window Select the customize ribbon option from the left-hand side panel as shown below On your right-hand side, remove the check marks from the tabs that you do not wish to see on the ribbon.
The financial formulas section is particularly intriguing for those who would like to work in accounting or banking. This one has had over 9, students enrolled, with courses for mastering the top 25 most advanced math formulas in Excel. It teaches real world examples for the formulas so you can see how to utilize them in the future. Dozens of PDF quizzes, practice files, and slides are available for download, and a beautifully structured course outline is there to walk you through some of the more complicated techniques.
Excel as a Financial Calculator : this article is particularly useful since not everyone is at work with a real financial calculator. So it makes sense to learn these functions in many fields. We like the key that compares some of the more advanced functions in Excel to buttons on a financial calculator.
This allows you to seamlessly transition from a calculator to the Excel spreadsheet. Excel Exposure keeps its articles on the shorter side, which is good if you want to absorb the information in small helpings. Advanced time and math calculations : Helpful guides primarily delivered in video format.
All of the calculations are done through Excel, allowing you to see the visuals and practice them on your own time. You can use it for databases too. Getting to grips with databases will help you to understand how to use some of the more complex functionality in Excel: Microsoft Office Tutorial on Importing Data into Excel and Creating a Data Model : One of the main reasons people use Excel is for data mining and creating databases in general.
This expands on the essentials of data insertion and organizing that data afterward. For example, you could start with learning how to import data using copy and paste, then go straight to creating a relationship between imported data. Building a database in Excel with a table or list : Wonder How To provides a few simple video tutorials for those interested in this topic.
Using Excel as your database : A nice tutorial from Chandoo. It includes animated GIFs to complement the text. This speeds up the process of learning, since the images are zoomed in, yet still moving, for a more engaging guide. It explains the code module too, which is an interesting take on the entire databasing process.
Be warned that some of the images are from older Excel versions. Some of the topics include working with formulas, using sliders to facilitate table filtering, and using data validation to restrict data entries.
All of these topics come with some downloadable information and practice forms. Best Excel Tutorial : Explores database functions with the most common function you would ever use when constructing or mining a database. For example, some of the headers include functions like Dmin, Dproduct, Dvarp, and Dvar.
How to Create a Database in Excel : Begins with a database overview and moves onto other more advanced topics like filtering data and completing database formatting. The formatting section is one of the most important parts, since the whole point of a database is for use in the real world.
Microsoft Excel Functions To really understand how to use Excel, you need to be able to write functions. The tutorial is all shown on the video. This is a great resource to bookmark, since the majority of functions used in the real world are outlined here. These are the true basics, so it might seem a little rudimentary to some.
It starts with Count and Sum, where you can click on that link and see the formulas that relate. The website has plenty of other categories for statistics, financials, and more. It serves as a quick reference for anyone who needs it. Excel Graphing Tutorials Once you have your figures and formulas in Excel, you can automatically create graphs and charts with your data: NCSU : Handles the majority of graphic requirements with links to topics on bar graphs and histograms.
Importing text files is covered, along with the most basic of graphing for those just getting started. A collection of free Excel templates is provided in the tutorial. This improves your usage of the graphs since it displays graphs in their full form and asks you to make them in return.
Create a Chart with Excel Easy : Guidance that helps you make a graph about the wildlife population to see how a student or someone in the wildlife industry would do it.
Microsoft Office tutorial : This is one of the best tutorials because it shows you how to create a chart from start to finish. Some of the tutorial is done through a video, but the majority of the learning comes from a large article with pictures and hints on moving your chart, resizing, and showing a legend.
Creating Advanced Charts : Guru99 is known for its advanced tutorials, and this one is no different. The guide talks about the importance of advanced charts, while also touching on topics like making combinations and changing axis titles. This guide to Excel is for those who have never used it before, are struggling with it as a beginner, or just want the basics to then learn it on their own. In the simplest of terms, Excel is a spreadsheet application. It uses grids of cells within columns and rows to manipulate, organize, and perform calculations with data.
You can use pivot tables, charts, formulas, and functions in a variety of ways. The list goes on with the many uses for Excel.
Throughout this guide, you will see the same terms used again and again. Getting familiar with them will help you to understand the guide and the steps you see.
Workbook and Spreadsheet: A workbook is what you actually use when you open Excel. The workbook contains the spreadsheets.
We'll show you how to best work with Excel worksheet tabs.
Read More on the bottom of the Excel workbook. Spreadsheets are made up of rectangular blocks called cells. A cell contains the data you enter; from numbers to words to images to formulas, cells hold that information. You can enter data either directly in the cell or in the formula bar text box for the cell right below your ribbon. You will also notice the name box cell indicator to the left of the formula bar.
By default, this displays the corresponding column and row for the cell. For instance, the cell in the top left corner of the spreadsheet is A1 for column A, row 1. Formulas and Functions: You can think of a formula as a calculation or equation. With Excel, you can create formulas or use built-in ones. These formulas can automatically calculate numbers Doing Your Taxes? This is the time to leverage the power of Excel to get everything in order.
Read More for you like addition or multiplication. In addition to calculations, you can use functions for things like counting the number of items in a column or displaying a minimum or maximum number for a group of cells. You should take a little time to familiarize yourself with the ribbon in Excel. Just like with other Microsoft Office applications, the ribbon holds the buttons that you will use inside tabs.
You can customize the ribbon to remove or add both tabs and buttons. But you will likely see the tabs below by default. Also, note the Tell me what you want to do box. If you need help or want more information on a feature, just enter the keyword into the box and view your results. As with the tabs and ribbon, if you use other Microsoft Office applications you should be familiar with the Quick Access Toolbar.
But if not, this is the toolbar at the very top left of the Excel window. And it is important because it allows you to quickly undo or redo an action, plus save your file.
If you make a mistake and want to undo it, just click the Undo button. If you click it once, it will undo the last action you took.
If you keep clicking it, it will undo actions you took one-by-one moving backward. Alternatively, you can click the arrow next to the Undo button and highlight all actions you want to undo. If you undo an action with the button, the Redo button will then be clickable.
This lets you redo what you have just undone. Like the Undo button, you can redo your last action with one click or use the arrow next to the Redo button to redo multiple actions. The Save button lets you quickly save the file you are working on with the current file name. Managing a large number of spreadsheets is no problem for Excel. So, you can use more than one if your project calls for it. For example, you can use different spreadsheets for months or years, product warehouse locations, loan or credit card companies, and healthcare facilities.
There are some basics such as selecting, inserting, deleting the columns, rows, and cells in Excel. These are handy actions to keep in mind as you work with your spreadsheets. You will notice as you move your mouse over the letters for the columns or numbers for the rows that a small arrow will appear.
If you click at that time, the entire column or row will be selected. You might use this action for applying a function, formatting, or sorting.
There may be times when you want to select more than one column, row, or cell. You can do this in a couple of different ways depending on if they are adjacent or scattered. When you want to select columns, rows, or cells that are next to each other, begin by selecting the first one. Then, hold down your mouse button and drag through the rest.
You will see them highlight as they are selected. Release the mouse button when you finish. Another way to do this is to select the first one, hold down your Shift key, and then select the last one.
If you do this with cells, you can select an entire group across and down. If you would like to select columns, rows, or cells that are not adjacent, start by clicking the first one.
Then, hold down the Ctrl key and continue clicking the ones you want. Release the Ctrl key when you finish. You can easily add or get rid of a column or row that you no longer need. Again, put your mouse over the letter or number, but instead of left-clicking your mouse, right-click.
In the context menu that appears, select either Insert or Delete. You can also simply hide and unhide columns or rows How to Hide or Unhide Columns and Rows in Excel How to Hide or Unhide Columns and Rows in Excel If you're dealing with a data-heavy spreadsheet, sometimes it's helpful to hide or unhide rows and columns to better see the information you need to analyze. Read More by selecting Hide or Unhide from the context menu.
You can insert or delete a cell the same way as a column or row. However, with either option, you will receive a pop-up alert asking how you would like to shift the cells, row, or column.
Just choose an option and click OK. If you decide to move a column, row, or cell to a different spot in your spreadsheet, you can do it but must be careful. First, select the column, row, or cell as described above.
Put your mouse over one of the edges of it so that the four-sided arrow appears. Then, drag it by holding down your mouse button to its new location and release. What you must be cautious of is if you release the column, row, or cell over the top of one that already contains data. If this happens, a pop-up box will appear asking if you are sure you want to replace the data. So, if you do this in error, click Cancel and it will go back to its original spot.
You may want all or some of the columns or rows on your spreadsheet to be a specific size regardless of the data they hold.
Adjusting the width or height is simple and can be done in two different ways. First, you select and right-click the column or row. In the context menu choose either Column Width or Row Height , depending on which one you want to change. In the pop-up window that appears, you will see the current width or height. Replace it with the number you want and click OK. Another way to adjust the size of a column How to Manage Columns in Excel How to Manage Columns in Excel Do you need to add, move, hide, or change columns in a complex spreadsheet?
Don't panic. We'll show you basic Excel column operations to organize your data. Read More or row is to first select it. Move your mouse to the border until you see a two-sided arrow appear.
Then, hold down your mouse button and drag until you reach the size you want. If you would rather have each column and row sized to accommodate your data, you can do this in a just a few clicks. First, select the entire spreadsheet by clicking the triangle in the upper left corner between the A and the 1. Then, move your mouse between two columns until you see the two-sided arrow and double-click.