Excel Tips and Tricks CRI CPE Week May 2011 Presented by: Francois Houde‚ CA‚ CISA Schedule of the Session Transitioning from Excel 2003 to Excel 2010: What happened to my Excel? Managing versions Searches with wildcard characters Multiple windows of the same workbook Creating three dimensional formulas Feel like discovering new functions? Using the scenario manager What happened to my Excel? Q: My Pfx Engagement menus are gone and/or I’ve lost my tickmarks
Premium Spreadsheet
insights into human behavior that can be used to strengthen the company’s bottom line. The data set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: Excel 2007 DataSet with DataSet Key which contains the following nine sections of data that will be used throughout our course: Gender Age Department Position Tenure Overall Job Satisfaction
Premium Data Microsoft Microsoft Office
1 More 0 Q1 Descriptive Statistics Excel Worksheet b Q2 d Q3 e Q4 b 5. For the following sample of scores: 2‚ 6‚ 1‚ 4‚ 2‚ 2‚ 4‚ 3‚ 2 Mean variance standard deviation 2.889 2.099 1.537 Find the mean‚ variance and standard deviation 6. A sample of size 7 (n = 7) has a mean of M = 9. One of the sample scores is changed from x = 19 to x = 5. What is the value for the new sample mean? New Sample Mean 7 7. Using Excel create a histogram and a line graph using
Premium Standard deviation Variance Arithmetic mean
Post College Personal Finance Assignment Due: October 3 The assignment must be submitted via the Angel drop box for the given assignment by 11:55p.m. on the due date. This assignment will have two parts to be submitted Part 1 A-C and the Post College Budget Spreadsheet. Please submit these assignments in the following manner (Your last name and then the assignment description) Example: Zink Post College Personal Finance Assignment Fall 2012 1. From the Job Offer Package Sample choices
Premium Finance Renting Property
with little or no computing experience. The major focus is upon fluency with current information technology. Lectures will cover computer fundamentals for computer hardware‚ software‚ and networks. The applied component will concentrate on Microsoft Excel and web page creation. Course Materials: Textbook: Computer Concepts 2012 Introductory‚ Parsons‚ Oja‚ Thomson Course Technology HTML and CSS Introductory (6th Edition)‚ Carey‚ Thomson Course Technology Evaluation: Labs (4): Midterm: Final Exam:
Premium Computer Microsoft Computing
The company Kudler Fine Foods supplies the freshest ingredients and the tools enabling their customers to become a gourmet cook. They are a specialized food store with a worldwide selection of vegetables‚ meats‚ wines‚ and cheeses. The stores are owned by Kathy Kudler‚ and today continue to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opened her first store in La Jolla‚ and after a five-year plan‚ opened her third store in Encinitas
Premium Microsoft Office Microsoft Excel Spreadsheet
Complete a job requirements job analysis on a position with which you are familiar. See Exhibit 4.3‚ page 158 for an example of the job requirements matrix. Focus on the specifics tasks of the job and the associated KSAOs that lead to success in meeting the tasks. Complete answers showing detail both in the tasks and the KSAOs (type‚ proficiency‚ etc). This assignment is worth 10 points. May 4‚ 2015 Job Analysis Matrix: Commercial Lines Underwriter Job Summary The commercial lines underwriter
Premium Microsoft Office Microsoft Excel
your figures stack up. 2.) Create a table in EXCEL which displays all the information found in step one. It should contain the data for your chosen field (examples of Bachelors and Associate educational requirements). 3.) From the table create a chart which visually displays the information. You can use bar charts‚ pie charts; anything as long as it visually describes the information determined in step one and shown in step 2. 4.) Submit the EXCEL spreadsheet as an assignment in Blackboard Assignments
Premium Bar chart Bachelor's degree Pie chart
Support Sustainability Report - Environment Department (Planning) The procedures in my department for recycling paper are different depending on whether there are any sensitive details. We a bin two bins‚ green bins for paper and other materials and the other for confidential paper. The bins are collected once every week depending on how full they are. Whilst printing I have come across printers where it says toner low replacement needed. Because I don’t know how to dispose of a toner or
Premium Microsoft E-mail Management
Company" Read the ’Stateline Shipping and Transport Company" Case Problem on pages 273-274 of the text. Analyze this case‚ as follows: In Excel‚ or other suitable program‚ develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. Solve the model you developed in #1 (above) and clearly describe the results. In Excel‚ or other suitable program‚ Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points.
Premium Mathematics Interpretation Microsoft Excel