In this introductory course to Excel, participants will explore Excel activities that Microsoft Excel , Microsoft Excel (Windows) .. PDF/XPS or Excel. Microsoft Excel is one of the most popular spreadsheet applications that helps you Microsoft Excel uses a ribbon toolbar to allow you to modify your document . . Here you can add gradients, fill, drop shadows, and reflections to your chart. that'll get you well on your way to 'Excel Guru Status' giving you not only the more Microsoft Office training (including Excel, Word and Outlook video tutorials) and . Fill blank cells in a row or column - Highlight the column or row containing .
|Language:||English, German, Dutch|
|Genre:||Children & Youth|
|ePub File Size:||24.89 MB|
|PDF File Size:||9.40 MB|
|Distribution:||Free* [*Register to download]|
Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDN, OneNote, . Welcome to the Microsoft Official Academic Course (MOAC) In the Publish as PDF or XPS dialog box, ensure that the Save as type list shows PDF. 8. CFI's Excel Book is free and available for anyone to download as a pdf. Learn about the most important Excel shortcuts and functions to succeed in your career!. About the Tutorial. Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel.
Also tutorials, corrected exercises and practical work will make it easy for you to have a clear understanding of every topic.
No matter you are a beginner or want advanced information on any of these Excel topics, you can visit this Excel topic for complete knowledge. Moreover, all the material is free to download from this website.
Home Office Excel. Excel tutorials in PDF. Microsoft Excel Part 3: Advanced Advanced Description: Using the toolbar it is possible to change the type of graph drawn and select the various sections of the graph.
It is also possible to alter the graph by double clicking on the section of the graph to change. Various dialog boxes will appear depending upon the object selected.
Each dialog box has a number of tabs than can be used to alter sections of the graph. Selecting Multiple Rows for Graphing Purposes Often several columns of data need to be selected in order to produce the correct format on a graph. For example often the first column or two may contain the labels for the X-axis and the figures to be graphed may be several columns to the right of the labels.
If all columns are selected the graph will be incorrect. Task 24 Open a new worksheet in Excel and type in the sheet shown below.
Using the data in the worksheet create the embedded 3D pie chart shown. Place your name on the sheet and save it as TASK Move the graph into the correct position and move the labels so they look similar to that shown.
Resave the sheet and print a copy of the sheet. Task 25 Open a new worksheet in Excel and type in the figures shown on the sheet below.
Using these two sets of data produce the XY scatter graph shown embedded on the sheet. Place your name on the bottom of the sheet and save it as TASK Print a copy of the sheet as shown.
Selecting a Non-Continuous Range for Graphing Often the data to be used for a graph is not in a continuous range of cells. This is a particularly useful selection technique when Total information needs to be graphed. Task 26 To compare students for the year in a certain subject the Average mark for each student needs to be graphed. Place the graph on a new Chart sheet: Absolute and Relative Cell Addressing There are basically two forms of addressing that can be used in Excel — relative and absolute.
Relative addressing is, as the name implies, an address relative to the current position.
These directions would not work from any other position. To give an absolute address it makes no difference where the person is currently located. 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.
The Excel Tabs and Ribbon 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.
Here is a brief explanation of what each one is for and which button sections you can see. File: Create a new workbook, open an existing one, save, print, and share books and sheets. Home: Ctrl the clipboard, font, alignment, numbers, style, cells, and editing.
Insert: Insert tables, charts, illustrations, filters, and links. Draw: Use drawing tools such as a lasso selection, eraser, pen, and highlighter. Page Layout: Adjust the spreadsheet theme, page setup, scale-to-fit, and sheet options. Formulas: Pick a formula, function from the library, and perform formula auditing. Data: Get and transform data, view queries and connections, sort, filter, and use data tools.
What Is Microsoft Excel?
Review: Use tools for proofreading, accessibility, language, and comments. View: Change the workbook view, items to show, zoom in or out, and work with windows.
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. 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. Spreadsheet Options 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. Along with multiple sheets, you can take advantage of these basic spreadsheet features. Add a spreadsheet: Click the plus button at the bottom next to your last sheet.
Rearrange spreadsheets: Hold the sheet tab and drag to its new spot in the workbook. Name a spreadsheet: Double-click the sheet tab and type the new name. By default, you will see them named Sheet 1, Sheet 2, and so on. Color a spreadsheet tab: Right-click the sheet tab and under Tab Color, just click to apply a new one.
Protect a spreadsheet: Right-click the sheet tab and under Protect Sheet, add a password and select your options. Move or copy a spreadsheet: Right-click the sheet tab and select Move or Copy. You can then move the sheet to another spot in the workbook, move it to a different workbook, and make a copy of it for either case. Delete a spreadsheet: Right-click the sheet tab and click Delete. You will need to confirm this action in the subsequent pop-up window.
Working With Columns, Rows, and Cells in Excel 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. Select an Entire Column or Row 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.
Select a Group of Columns, Rows, or Cells 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. Select Adjacent Columns, Rows, or Cells 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.
Select Scattered Columns, Rows, or Cells 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. Insert or Delete a Column, Row, or Cell 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.These options include times, fractions, percentages, and others. The guide talks about the importance of advanced charts, while also touching on topics like making combinations and changing axis titles.
Excel Basics Microsoft Excel 3. Intermediate Intermediate. If you want to use it, click the Create button.