...Excel Tutorial 1 Getting Started with Excel Introducing Excel * Microsoft Office Excel 2007 (or Excel) is a computer program used to enter, analyze, and present quantitative data * A spreadsheet is a collection of text and numbers laid out in a rectangular grid. * Often used in business for budgeting, inventory management, and decision making * What-if analysis lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values Introducing Excel Exploring Excel Navigating a Worksheet * Excel provides several ways to navigate a worksheet Planning a Workbook * Before you begin to enter data into a workbook, you should develop a plan * Planning analysis sheet Entering Text, Numbers, and Dates in Cells * The formula bar displays the content of the active cell * Text data is a combination of letters, numbers, and some symbols * Number data is any numerical value that can be used in a mathematical calculation * Date and time data are commonly recognized formats for date and time values Entering Multiple Lines of Text Within a Cell * Click the cell in which you want to enter the text * Type the first line of text * For each additional line of text, press the Alt+Enter keys (that is, hold down the Alt key as you press the Enter key), and then type the text Changing Column Width and Row Height * A pixel is a single point on a computer monitor or printout ...
Words: 6108 - Pages: 25
...You Wanted to Do With Office...But Didn't Know How You use Microsoft Word, Excel and PowerPoint on a daily basis and are still be trying to figure out where things are and how they work, using only 10% of the applications power. Below are 101 customizations and tweaks to help you harness the power of productivity, and customize MS office to work for you. The difference between an Microsoft Office beginner and advanced user is all about knowing how to use the individual applications, and knowing how to use them well. Wondering how to use your everyday Office applications effectively? The best way is to customize them. When you learn how to customize an application the way you want it--especially when it’s a productivity tool like an Microsoft Office program, you increase your productivity and effectiveness by leaps and bounds. All you need is a guide on getting the best customizations out there. Read on and make the leap from Microsoft Office beginner to expert with the following list of resources, tips, tricks and tutorials. Microsoft Word Microsoft Excel Microsoft Powerpoint Microsoft Outlook Streamline Document Formatting Keyboard shortcut/Cheat sheets Editing Importing Fonts Exporting to Different Doc Types General Word Tips and tricks Interface Customizations Formatting Text & Numbers in Spreadsheets Templates Macros and Calculations Keyboard shortcut/cheat sheets General Excel Tips and Tricks Interface customizations Printing Exporting Keyboard shortcuts...
Words: 4859 - Pages: 20
...rest period and different type of employment. Maximum and minimum working hours vary for full time and part time subordinates. Whereas, managers make sure that there are enough subordinates on duty to meet business needs. Number of needed subordinates can be decided by managers. For example, Restaurant managers need more subordinates to work during weekend. Application description This application allows manager to add, delete and modify setting for subordinates and constraints such as working hours. Data sheet stores subordinates information such as employee name, employment type and working day restriction. Besides, it stores attendants needed, maximum and minimum working hours. By using solver excel function, Roster sheet presents a report describing shift work arrangement. Solution is found when total shortfall cell value is zero and working hours of subordinates meet requirement. Otherwise, report prompts message box stated no feasible solution found. Button usage description There are four buttons in Explanation sheet. 1) Add Employee New employee information will be stored in Data Sheet. Employee name should be unique. Duplicate employee name will be rejected by application. As excel 2010 solver limits to 200 adjustable cells, maximum number of employee is 14. (14 employees*14 half days=196 adjustable cells) Please refer to below website http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx 2) Delete/Modify Employee ...
Words: 491 - Pages: 2
...Table of Contents Module One: Getting Started 4 Course Objectives 5 Module Two: Opening and Closing Excel 7 Opening Excel 8 Understanding the Interface 10 Using Backstage View 13 Understanding Worksheets 14 Understanding Workbooks 15 Module Three: Your First Worksheet 17 Entering Data 18 Editing Data 20 Using the Wrap Command 21 Adding Rows and Columns 23 Checking Your Spelling 25 Module Four: Working with Excel Files 26 Saving Files 27 Publishing Files to PDF 28 Sending Files via E-Mail 30 Closing Files 31 Opening Files 32 Module Five: Viewing Excel Data 34 An Overview of Excel’s Views 35 Switching Views 36 Creating Custom Views 38 Using Zoom 41 Switching Between Open Files 43 Module Six: Printing Excel Data 44 An Overview of the Page Layout Tab 45 Setting Up Your Page 46 Using Print Preview 48 Printing Data 49 Module Seven: Building Formulas 50 The Math Basics of Excel 51 Building a Formula 52 Editing a Formula 54 Copying a Formula 56 Relative vs. Absolute References 58 Module Eight: Using Excel Functions 59 Formulas vs. Functions 60 Using the SUM Function 61 Using Other Basic Excel Functions 63 Understanding the Formulas Tab 64 Using the Status Bar to Perform Calculations 65 Understanding the New Function Names 67 Module Nine: Using Time Saving Tools 68 ...
Words: 3351 - Pages: 14
...E&C PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their...
Words: 813 - Pages: 4
...As we all know writing and excel knowledge is needed for most or all classes we take, work at our daily jobs, or projects we want to dive into. In essence, not everyone has the skills to write a prefect paper or tackle a pivot chart on excel. Many students, such as me, who have decided to take on a new journey towards earning their MBA, have been given a tool by Capella to evaluate what they do and do not know about their writing skills and excel knowledge. The results will lead us to a better tomorrow, it will enhance our writing skills to think another a more critical level, and use the excel spreadsheets more knowingly. This tool was a reminder that I need to focus more on my prewriting skills, use my time management skills, and explore more into using an excel sheet. My overall composite score in writing was at a moderate level. The score was evaluated by five elements: focus and meaning, content and development, organization, language use and style, and lastly mechanics. With talking to the enrollment counselor and the coach for the course, I was advised that writing was a huge factor in the MBA courses. I knew before starting the course, my writing skills needed some refreshing. In taking the assessment it only proved my point invalid. I found that I needed to establish and control the main ideas to my audience so they have a better understanding of what I’m trying to say. The ideas in my writing were not fully developed and did not specify enough clarity to...
Words: 916 - Pages: 4
...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Many tools of MS Excel are available to analyze statistical data beyond the basic statistical analysis. Such tools include regression analysis, simulations, control charts, summaries, and forecasting. Other important data that can be obtained using the expanded MS Excel financial functions is performance level calculations, principle payment calculation, depreciation of an asset, interest payment on investment, present value of investment, calculation of interest rate over time, annual duration of the security, current and future rates of investment, and amortization. The logical functions help calculation based on the requirements such as if, or, and, true and false. MS Excel also has an integration that allows to import information stored in COM applications. MS Excel also has a series of arithmetic and geometric functions. Additionally, MS Excel has a number of functions for engineering applications such as Bessel functions, binary and hexadecimal. Other functions include correlation, covariance, sum of squares, exponential means, permutations, quartiles, Student’s t-distribution, z test , and others. The manager can effectively utilize these tools in interpretation of data sets and creating queries without using MS Access. The manager can effectively calculate all the needed statistics without having to go through extensive calculations. By using Data...
Words: 510 - Pages: 3
...using a program from Microsoft, Access is the best one to use in the business because of its ability to process information using a relational database system. However, the collaboration tool that a business uses is equally important. This tool whether it is an inter- or intra-net type system is critical when working with other team members or employees to process work efficiently and effectively for the business and its customers. While currently at Party Plates we utilize Microsoft Excel, there is good reason to incorporate Microsoft Access as well. On many occasions, you will want and possibly need to take advantage of the benefits that both programs have to offer. For example, you created a spreadsheet in Excel in which you can calculate and analyze the data, and it has become unmanageable due to size and complexity, and now that data needs to be accessed by many more users than you. One example would be to, import or link your worksheet into Access and use it as a database as an option to working with it in Excel. Whether you use excel or access first, the data is always interchangeable you can go from one to the other seamlessly. You can bring data into Access from Excel (and vice versa) by, importing copying, or exporting it. No data connection required to complete these tasks. Microsoft Access is an essential part of most businesses today. This database allows personal to access and manage a vast amount of...
Words: 701 - Pages: 3
...construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A numerical story.” Some incorrect: n n n “Forecasting wealth by putting money away now/investing.” “It is all about putting data into a nice format.” “It is just a mega huge spreadsheet with fancy formulas that are streamlined to make your life easier.” Some ridiculous: n “Something to do with money and fashion?” 1 2 Some honest: n USING EXCEL FOR BUSINESS ANALYSIS “I really...
Words: 17366 - Pages: 70
...Microsoft Sharepoint 2013 Step by Step Olga M. Londer Penelope Coventry Copyright © 2013 by Olga Londer and PPP Consulting Ltd. All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. ISBN: 978-0-7356-6703-7 1 2 3 4 5 6 7 8 9 LSI 8 7 6 5 4 3 Printed and bound in the United States of America. Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email Microsoft Press Book Support at mspinput@microsoft.com. Please tell us what you think of this book at http://www.microsoft.com/learning/booksurvey. Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/ Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective owners. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused...
Words: 26180 - Pages: 105
...like Excel, make the job easier to perform. In scenario 2, a company with employees and various forms of needed equipment; an owner or manager has the needed to view options and cost effectiveness to make the right decisions and progress the company in a positive manner. Scenario 1 Excel may be used to track the in the following manner: |Booth Tracking 2015 | | | | | | | | | | | | |Equipment |Arrival-In |Shipper |Cost |Departure-out |Cost | |Booth Tent |Yes |Fed-ex |$50.00 |yes |$50.00 | |Screen |yes |Fed-ex |$20.00 |yes |$20.00 | |Modems |Yes |Fed-ex |$15.00 |yes |$15.00 | |Monitors |Yes |Fed-ex |$30.00 |yes |$30.00 | |Cables |Yes |Fed-ex |$30.00 |yes |$30.00 | |Software |Yes |Fed-ex |$30.00 |yes |$30.00 | |Total |6 of 6 | |$175.00 |6 of 6 |$175.00 | The table was created in excel and...
Words: 906 - Pages: 4
...UNIT BRIEF Edexcel HND (Computing) Level 5 COMPUTER PLATFORMS 2011 EThames Graduate School. India 8-2-228 to 231 Punjagutta Cross Road Hyderabad 500082 Tel: +91 40 44432223 This handbook belongs to the following student; if found please hand in to Reception: NAME: ___________________________________________ Student ID: ________________________________________ |Unit Name: |Introduction to Computers | |Unit Number: | | |Course Duration: |09 Sessions | |Batch: |March, 2011 | |Tutor: |B Jagadish Chandra Reddy | A warm welcome to all the students enrolled for this unit. The unit handbook will give you a clear understanding of the aim and learning objectives of the unit. It will also portray the unit planning in terms of coverage, prerequisites for each session, tools and techniques used by the tutor and the level of efforts expected to be put by a student. It will make you aware of the assessment policy, assignment...
Words: 474 - Pages: 2
...taken to alleviate or mitigate any issues that may play a role in hindering the success of the goals put in place. Use of a Database or Excel Spreadsheet An Access database or Excel spreadsheet will have to be created featuring fields that can easily be accessed in order to verify information at all times and in detail. The more fields listed, the easier it will be to find a particular part or location and will enable this information to be easily obtained. The list of relevant fields needed to track important data is contained below. . Equipment Company: Name, telephone number, address, and a point of contact Equipment: Name, model, serial number, location, and weight Shipper: Name, telephone number, address, and a point of contact Booth Components: Booth number, name, model, location, height, size, and weight Advantages and Disadvantages of Access As with any product, there are advantages and disadvantages. Here are some of the advantages and disadvantages of using Access according to (Microsoft.com, 2014). Access can work with millions of rows. Access is ideal for text, numbers, dates, and other common data. Access has useful features for storing large objects like images and documents. Disadvantages of using Access are that it cannot perform what-if analysis or use SmartArt graphics. Advantages and Disadvantages of Excel Here are some of the advantages and...
Words: 1109 - Pages: 5
...DATA ENTRY CLERK June 2008 - Present Working as part of a team in a busy office environment processing, cleaning and then imputing data. Accurately entering the business names , addresses and financial details of on businesses and individuals. Duties: Ensuring report tables and listings accurately reflect data within a database. Entering data accurately onto computerised databases & Excel spreadsheets. Locate and correct data entry errors. Lifting of files and boxes containing paper records. Maintain logs of activities and completed work. Ensuring documents meet required quality standards. Compiling, coding, categorizing, calculating, tabulating and auditing data. Handling inbound telephone queries from colleagues / clients regarding data . Data manipulation in Excel spreadsheets. Occasionally carrying out various administration tasks like, photocopying, filing. Reviewing validation output and performing specified manual checks on the data to ensure consistency and completeness. KEY SKILLS AND COMPETENCIES Excellent knowledge of Excel & other specialist database tools & software. Computer literate with extensive IT knowledge. Experience of using a scanner and working with TIFF image files. Experience working with Sage systems. Enthusiastic, flexible and capable of working on own initiative. Comprehensive understanding of the Data Protection Act. An ability to work to deadlines whilst ensuring accuracy and efficiency. Capable of working in a manner conducive with the production...
Words: 267 - Pages: 2
...really liked the whole idea of working out. I thought it was very interesting how a person could transform into a new version of themselves that barely resembled their old looks. (At least that’s what the magazines said.) Unfortunately, I had the least amount of knowledge about what exactly I was supposed to do in a weight room. After doing some research reading books, online articles, and watching online videos, I started to teach myself a basic beginner routine. This routine mainly consisted of a bench press, squat, and deadlift, or otherwise known as the big three. The only other exercises I did were accessory work, which would help to increase the big three. I had a good friend named Cesar that had been working out for years since he played on the football team. Cesar continued helping me by giving me more tips, as well. Furthermore, after research and talking to Cesar, I decided that I was ready to officially start working out. Cesar persuaded me to join the workout class at my high school called excel. This class was very simple. It consisted of a teacher supervising the students, and the students would get graded on whether they were working out or not. I really enjoyed lifting with Cesar, because he really pushed me to work hard. He was also my spotter for when I lifted heavy weights, just in case I missed a rep. Because I lifted with him so much, I unnoticeably developed a reliance on him. It also seemed like everybody else in the excel class had a partner or even a...
Words: 742 - Pages: 3
