Microsoft Excel Level 1 | PDF | Microsoft Excel | Spreadsheet.
Looking for:
Microsoft excel 2013 level 1 pdf free.Course Help Online |
- Microsoft excel 2013 level 1 pdf free
Microsoft Windows 8 - Wikipedia.Microsoft Excel Spreadsheet Software | Microsoft
The data source may be written manually by the user or selected from the same sheet. Steps are as follows. Tips: If the source is from a different sheet, create a named range for all the values and use the name in the Source field for Data Validation. For example, to set upper and lower limits, select Between.
For example, to allow dates after a certain day, select greater than. For example, to allow up to a certain number of characters, click less than or equal to. For example, to allow entries for an account only if the result won't go over the budget, click Decimal for Allow, select less than or equal to for Data, and in the Maximum box, click the cell that contains the budget amount. To display an optional input message when the cell is clicked, click the Input Message tab, and make sure that, the-Show Input Message When Cell is Selected - check-box is selected and fill in the title and text for the message.
Fill in the title and text for the message up to characters. If you do not enter a title or text, the title defaults to "Microsoft Excel" and the message to "The value you entered is not valid.
A user has restricted values that can be entered into this cell. Exercise 1 Open Advance Excel Assignment workbook. In the sheet named Validation, so the following data validations.
It is called a Pivot Table because you can rotate its row and column headings around the core data area to give you different views of the source data. As source data changes, you can update a pivot table.
It resides on a worksheet thus; you can integrate a Pivot Table into a larger worksheet model using standard formulas. The data on which a PivotTable is based is called the Source Data.
Each column represents a field or category of information, which you can assign to different parts of the PivotTable to determine how the data is arranged. You can add four types of fields, as shown in figure 9. The fieldsareexplained in the following table:. Field Description Filters the summarized data in the PivotTable. If you select an item in the report filter, the view of the PivotTable changes to display only the Report summarized data associated with that item.
For example, if Region is a Filter report filter, you can display the summarized data for North, West, or all regions. Displays the items in a field as row labels. For example given below, the Row Labels row labels are values in the Quarter field, which means that the table shows one row for each quarter. Displays the items in a field as column labels. For example, given below, Column the column labels are values in the Product field, which means that the Labels table shows one column for each product.
Contains the summarized data. The area where the data itself appears is called the data area. R eportFilte r Colum n list L abelslis t. Figure 9. You can place the PivotTable in a new or existing worksheet. Click OK to create the PivotTable. Add fields You can add fields to a PivotTable to specify the data you want to display. The fields of the source data appears in the "PivotTable Field List" task pane. To add fields, drag the relevant field from the top of the PivotTable Field List to one of the four areas at the bottom.
You can add more than one field to an area, and you donot need to add all fields to the table. After the fields are in place, you can filter the information that appears in the table by selecting from the Filter columns, Filter rows, or report filter lists. For example, you can show all data values, or restrict the PivotTable to summarizing only a couple of them. Or simply select the data to create pivot table, click on button at bottom right corner and select table option to create pivot report as below,.
You can use styles to format an entire PivotTable in one step. You can use the Field Settings dialog box to change number formats, specify how data is summarized, and show or hide data. To change field settings: 8 Activate option Tab. Sparklines Sparklines are tiny charts that fit in a cell - to visually summarize trends alongside data. Sparklines show trends in a small amount of space, they are especially useful for dashboards or other places where you need to show a snapshot of your business in an easy-to-understand visual format.
For example, the following picture shows how a Sparkline is used to analyze the trend of the product Month wise. Create a Sparkline: 1 Select an empty cell or group of empty cells in which you want to insert one or more sparklines. When one or more sparklines are selected, the Sparkline Tools appear, displaying the Design tab.
Use these commands to create a new Sparkline, change its type, format it, show or hide data points on a line Sparkline, or format the vertical axis in a Sparkline group. Change the Style of Sparklines Use the Style gallery on Design tab, which becomes available when you select a cell that contains a sparklines.
Select a single sparkline or a sparkline group. To apply a predefined style, on the Design tab, in the Style group, click a style or click the arrow at the lower right corner of the box to see additional styles. To apply specific formatting to a sparkline, use the Sparkline Color or the Marker Color commands.
Freezing Rows and Column In order to view a large data more effectively, we may wish to keep some part of the data visible all the time while scrolling. Freezing panes can be used to achieve this result. To freeze row and column both Freeze panes option will always freeze the rows which are above the active cell and left columns of active cell.
Split Window In excel we can split the window into separate panes and scroll the worksheet in each pane so that we can easily compare data from two separate worksheet locations. To split a worksheet or data into two upper and lower horizontal panes, we can drag the split bar.
Inserting Page Break To print parts of a large worksheet is a bit tricky. It is possible that we make mistake while printing. Page break helps us easily set how much data we will require in each page.
To insert the page break Page break will always get inserted to the rows which are above the active cell and columns to the left of active cell. To insert a page break for A1 to G Previewing Worksheet In excel, we just have worksheet not the pages so cannot make out how the print will come and how much data will get printed on a page.
So, before giving print in excel we must see the preview of the sheet so that before giving it to print we can do last min changes. Here, excel has gave us Print Preview options so that we can see how much data will print on a page. Page setup. Margins In excel, we can also set the margins for printing the page.
To customize the margin setting click on small arrow icon, this is right corner of page setup group in Page Layout ribbon. Orientation Next command in Page setup group is Orientation which allows us to change the page orientation which can be portrait or landscape. Size Third command in Page Setup group is Size which allows us to change the size of the page. There is various size of page for e.
Printing of Worksheet in Multiple Pages Breaks This option allows us to break our long worksheet in multiple sheets. This is inserting page break. Many a times we need to find total, average, total number of records, highest value etc in a selected range so inserting subtotal in our data will make our work easy.
Pivot Table A pivot table is a great reporting tool that sorts and summarizes independent of the original data layout in the spreadsheet. Pivot table is used to summarize data in a tabular report form. Pivot-table tools can automatically sort, count, total or give the average of the data stored in spreadsheet. It displays the results in report form in the same sheet or new sheet as we specify. We can create report as per our expectation. It organizes our data according to the fields we specify.
This gives the Create pivot Table dialog Box, where we may specify the range for data source the base data and also the position to place the pivot table.
We can either place the pivot table in the same worksheet or on a new worksheet. Once we insert a pivot table, we will get a blank report and then we need to select the field that we want in Row Label, Column Label, report filter and values field When we click on any text field, it will automatically go to Row Label and Numeric field will go to Values. By default the sum function applied to a numerical field that is added to the Values Field. To do any changes in the positioning, you may just drag the field names to one of the four boxes according to the report you wish to create.
Create a worksheet containing Empcode, name of the employee, gender, department, designation, date of joining and salary and solve the following commands 1 Arrange the data in alphabetical order of name 2 Arrange the salary in descending order and then within name must be arrange in ascending order 3 To display only the data of MANAGER 4 To display only those records, whose salary is between to 5 To display total number of employee in each dept along with total salary 6 To create a report, display average salary in department gender wise.
Chapter 9: More functions. Database Functions Database Function Description Adds the number in the column of records in Dsum database that match the condition Count the number of cell in the column of Dcount records in database that match the condition Average the number in the column of records in Daverage database that match the condition Returns the largest number in the column of the DMax records in database that match the condition Returns the smallest number in the column of DMin the records in database that match the condition.
Shortcuts In Excel Shortcut Command. In a PivotTable, it selects the entire PivotTable report. Selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. Copies the selected cells. Displays the Find and Replace dialog box, with the Find tab selected.
F5 also displays this dialog box. Displays the Open dialog box to open or find a file. Displays the Print dialog box. Applies or removes underlining. Available only after you have cut or copied an object, text, or cell contents.
Uses the Undo command to reverse the last command or to delete the last entry that you typed. Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in F2 a cell is turned off. Displays the Paste Name dialog box. Repeats the last command or action, if possible.
Displays the Go To dialog box. Switches between the worksheet, Ribbon, task pane, and Zoom controls. Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. Calculates all worksheets in all open workbooks. CTRL F9 minimizes a workbook window to an icon. Turns key tips on or off. F10 If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
CTRL F10 maximizes or restores the selected workbook window. Creates a chart of the data in the current range. F12 Displays the Save As dialog box. In cell editing mode, it deletes the character to the left of the insertion point. In cell editing mode, it deletes the character to the right of the insertion point. Also selects the last command on the menu when a menu or submenu is visible.
In a data form, it moves to the first field in the next record. Opens a selected menu press F10 to activate the menu bar or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box the button with the bold outline, often the OK button.
Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode ESC when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. Moves to the beginning of a row in a worksheet. Page Setup - Sheet Tab - On the printed page it can to useful to have the first few column and rows visible on all pages Under the heading Print Titles select the Rows you want repeated at the top of each page by clicking into the box and then highlighting the required Rows using your mouse on the worksheet.
You can use Excel to create and format workbooks a collection of spreadsheets in order to analyze data and. Ribbon menu The Ribbon menu system with tabs for various Excel commands. This Ribbon system replaces the traditional menus used with Excel Above the Ribbon in the upper-left corner is the Microsoft.
Excel A Beginners Guide Beginner Introduction The aim of this document is to introduce some basic techniques for using Excel to enter data, perform calculations and produce simple charts based on.
Basic Microsoft Excel The biggest difference between Excel and its predecessors is the new layout. All of the old functions are still there with some new additions , but they are now located. Migrating to Excel - Excel - Microsoft Office 1 of 1 In This Guide Microsoft Excel looks very different, so we created this guide to help you minimize the learning curve. Read on to learn key. Introduction To Microsoft Office Excel The following are the outlines: 1. Start Microsoft Word Describe the Word Screen.
Excel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features. Excel Basics Learning Guide Exploring Excel At first glance, the new Excel interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars. A worksheet is a grid, made up of columns, which are. Intro to Excel spreadsheets What are the objectives of this document?
The objectives of document are: 1. Familiarize you with what a spreadsheet is, how it works, and what its capabilities are; 2. Learn how to use the File menu Microsoft Office Backstage view.
Excel Microsoft Office s spreadsheet application can be used to track and analyze numerical data for display on screen or in printed format. Excel is designed to help you record and calculate data, and. This program helps you to enhance your oral presentation and keep the audience.
In This Guide Microsoft Word looks very different, so we created this guide to help you minimize the learning curve. Read on to learn key parts of the new interface, discover free Word training,. Working with Tables in Microsoft Word The purpose of this document is to lead you through the steps of creating, editing and deleting tables and parts of tables. This document follows a tutorial format. Microsoft Excel Headers and Footers You can add headers or footers at the top or bottom of a printed worksheet.
For example, you might create a footer that has page numbers, along with the date and. Introduction to Word You will notice some obvious changes immediately after starting Word For starters, the top bar has a completely new look, consisting of new features, buttons and naming. The syllabus describes, through learning outcomes, the knowledge and skills that a.
Microsoft Access handout Access is a relational database program you can use to create and manage large quantities of data. You can use Access to manage anything from a home inventory to a giant. A macro is a series of steps that is grouped together as a single step. Get Familiar with Excel The document may be.
The function of these features will be more. Getting Started Pg. Creating A New Document Pg. Saving Your Document Pg. Toolbars Pg. Formatting Pg. What is a stock? A stock is a share in the ownership of a corporation, a large business organization. A stock, also, represents. An Excel file is referred to. Microsoft Office PowerPoint Navigating the PowerPoint Environment The Ribbon: The ribbon is where you will access a majority of the commands you will use to create and develop your presentation.
Excel -- Creating Charts The saying goes, A picture is worth a thousand words, and so true. Professional looking charts give visual enhancement to your statistics, fiscal reports or presentation. Set tabs and work with tables. Learn about styles Use the spelling and grammar. With the finest documentformatting tools, Word helps you organize. There are vertical columns and horizontal rows. A cell is where the. Unit 5 Using Microsoft Excel Unit Objectives This unit includes the knowledge and skills required to analyze information in an electronic worksheet and to format information using functions specific.
Using Microsoft Word Many Word documents will require elements that were created in programs other than Word, such as the picture to the right. Nontext elements in a document are referred to as Objects. Do you need to always add gridlines, bold the heading. For this lab you will modify a sample spreadsheet file named Starter- Spreadsheet. Using Excel Files Microsoft Word can be used to create documents,.
With PowerPoint, you can create engaging presentations that can be presented in person, online,. It uses a tabbed Ribbon across the top and employs dialog boxes and a Quick Access Toolbar. Create a mail or e-mail merge Use mail or e-mail merge when you want to create a large number of documents that are mostly identical but include some unique information.
For example, you can use mail merge. Contents 1. Introduction 1. Starting Publisher 2. Create a Poster Template 5. Aligning your images and text 7. Apply a background Add text to your poster Add pictures to your poster Add graphs.
Word Basics Learning Guide Exploring Word At first glance, the new Word interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars.
Read through each individual direction before performing it, like you are following recipe instructions. In This Guide Microsoft PowerPoint looks very different, so we created this guide to help you minimize the learning curve. Read on to learn key parts of the new interface, discover free PowerPoint. Word basics Word is a powerful word processing and layout application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that.
Introduction to Microsoft Excel 1 Part I Objectives When you complete this workshop you will be able to: Recognize Excel s basic operations and tools; Develop simple worksheets; Use formulas; Format worksheets;.
Overview A PivotTable report is an interactive table that allows you to quickly group and summarise information from a data source. You can rearrange or pivot the table to display different perspectives. Microsoft Publisher What s New! A new. That way, if someone else is reviewing your document they can tell you exactly which lines they have.
How to make a line graph using Excel Format your data sheet Make sure you have a title and each column of data has a title. If you are entering data by hand, use time or the independent variable in. The top portion of the window has a new structure. Running Descriptive and Correlational Analysis in Excel Tips for coding a survey Use short phrases for your data table headers to keep your worksheet neat, you can always edit the labels in tables. Microsoft Excel. Try for home.
Try for business. Buy for home. Buy for business. Get the Excel mobile app. Send now. Your message is being sent. Your message has been sent, please check your device shortly. Your message has been sent, please check your email shortly. We're sorry, an error occurred while sending your message. Please try again shortly. Please enter a valid digit phone number. It includes many powerful tools that can be used to organize and manipulate large amounts of data, perform complex calculations, create professional-looking charts, enhance the appearance of worksheets, and more.
This handout provides an overview of the Excel user interface and covers how to perform basic tasks such as starting and exiting the program; creating, saving, opening, and closing workbooks; selecting cells; entering and editing data; formatting text and numbers; positioning cell contents; applying cell styles; and getting help.
Preview the PDF. It is never too late to start learning and it would be a shame to miss an opportunity to learn a tutorial or course that can be so useful as Microsoft Excel Part 1: Introduction especially when it is free! You do not have to register for expensive classes and travel from one part of town to another to take classes. All you need to do is download the course and open the PDF file.
Comments
Post a Comment