(PDF) Microsoft Excel Tutorial | Wida Wida - .Microsoft Excel Step By Step PDF Book | Free PDF Books
Looking for:
Microsoft excel 2013 tutorial for beginners pdf free.Excel 2013 trainingMicrosoft Excel Tutorial download free tutorial in pdf
Excel Books - PDF Drive.
Download free tutorials and courses on microsoft excel tutorial - Documents PDF - People also downloaded these free PDFs
Work with macros. Create your first OneNote notebook. Using Tables in OneNote. Webinar: Back to school with OneNote. Webinar: OneNote for free plus cool new tools. Webinar: Onetastic for OneNote.
Add and use contacts. Calendar basics. Email basics. Fonts, hyperlinks, and spell check. Recall and replace sent messages. Setting up automatic replies and inbox rules in Outlook. Send and open attachments.
The ins and outs of BCC. Use Instant Search to find Calendar items. Use Instant Search to find contacts.
Use Instant Search to find messages and text. Webinar: Using Outlook Web App. Add holidays to your calendar. Control spam. Create or delete a search folder. Group and view email in your inbox. Import and export vCards to Outlook contacts. Make the switch to Outlook Make your job easier with Outlook. Reach out with contact groups distribution lists. Send or delete an email stuck in your outbox.
Take calendars to the next level. Templates and stationery. Track email with read receipts. Use voting buttons to create or respond to polls. Webinar: Tips for searching Outlook. Webinar: 5 simple ways to clean up Outlook.
Webinar: 8 great timesavers in Outlook. Archive or back up your mailbox. Password protect your mailbox. Share or publish your Office calendar. Use rules to manage your email. Webinar: Archiving items in Outlook. Apply and change a theme. Apply transitions between slides. Create speaker notes. Create your first PowerPoint presentation. Highlight text and change fonts. Print slides, notes, or handouts. Use Presenter view. Backgrounds in PowerPoint. Crop a picture to fit a shape. Group shapes or pictures.
Make the switch to PowerPoint Changing an Entry Within a Cell You may change an entry within a cell two different ways: 1. Click the cell one time and begin typing. The new information will replace any information that was previously entered. Double click the cell and a cursor will appear inside. This allows you to edit certain pieces of information within the cells instead of replacing all of the data.
Cut, Copy, and Paste You can use the Cut, Copy and Paste features of Excel to change the data within your spreadsheet, to move data from other spreadsheets into new spreadsheets, and to save yourself the time of re-entering information in a spreadsheet. Cut will actually remove the selection from the original location and allow it to be placed somewhere else. Copy allows you to leave the original selection where it is and insert a copy elsewhere. Paste is used to insert data that has been cut or copied.
Highlight the data or text by selecting the cells that they are held within. Click the location where the information should be placed. Formatting Cells There are various options that can be changed to format the spreadsheets cells. When changing the format within cells you must select the cells that you wish to format.
Drag and select the cells you wish to change. A box will appear on the screen with six different tab options. Figure 8 Explanations of the basic options in the format dialog box are explained in the following page. Figure 8.
Formatting Cells Number: Allows you to change the measurement in which your data is used. If your data is concerned with money the number that you would use is currency Alignment: This allows you to change the horizontal and vertical alignment of your text within each cell.
You can also change the orientation of the text within the cells and the control of the text within the cells as well. Font: Gives the option to change the size, style, color, and effects.
Border: Gives the option to change the design of the border around or through the cells. Formatting Rows and Columns When formatting rows and columns you can change the height, choose for your information to autoit to the cells, hide information within a row or column, un-hide the information.
To format a row or column, proceed with the following steps: 1. Select the cells which will be altered. Choose which height you are going to use.
Figure 9 Figure 9. Adding Rows and Columns Rows are cells that run horizontally across the document. You can insert an extra row of cells like this: 1. Drag select along the row of cells where you want your new row to appear. Figure The row will automatically be placed on the spreadsheet and any data that was selected in the original row will be moved down below the new row.
Inserting Rows Columns are cells that run vertically down the document. You can insert an extra column of cells like this: 1. Drag select along the column of cells where you want your new column to appear. The column will automatically be place on the spreadsheet and any data to the right of the new column will be moved more to the right. Figure 11 Figure Inserting Columns Working With Charts Charts are an important part to being able to create a visual for spreadsheet data.
In order to create a chart within Excel the data that is going to be used for it needs to be entered already into the spreadsheet document. Once the data is entered, the cells that are going to be used for the chart need to be highlighted so that the software knows what to include.
Next, click on the Insert Tab that is located at the top of the screen. Figure 12 Figure You may choose the chart that is desired by clicking the category of the chart you will use. Once the category is chosen the charts will appear as small graphics within a drop down menu.
To choose a particular chart just click on its icon and it will be placed within the spreadsheet you are working on. To move the chart to a page of its own, select the border of the chart and Right Click.
This will bring up a drop down menu, navigate to the option that says Move Chart. This will bring up a dialog box that says Chart Location. From here you will need to select the circle next to As A New Sheet and name the sheet that will hold your chart. The chart will pop up larger in a separate sheet but in the same workbook as your entered data. Take conditional formatting to the next level. Use conditional formatting. Advanced IF functions. Array formulas. Create and manage drop-down lists.
Create a PivotTable and analyze your data. Password protect workbooks and worksheets. Print worksheets and workbooks. Work with macros. Check out Microsoft Training Center. Excel More Need more help? Expand your skills. Get new features first. Was this information helpful?
Comments
Post a Comment