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
took Fe(NO3)3 and NaOH and mixed 7 different mole ratios in graduated cylinders to determine what the mole ratio is. We also did the same thing with solutions of CuCl2 and Na3PO4. We determine the mole ratios by graphing the volume of reactant #1 vs. volume of precipitate for each reaction. Data Part 1.) Cylinder 1 2 3 4 5 6 7 Fe(NO3)3‚ 0.1 M‚ ml 5 10 12 15 17 20 24 NaOH‚ 0.1 M‚ ml 55 50 48 45 43 40 36 Fe:OH mole ratio 1:11 1:5 1:4 1:3 2:5 1:2 2:3 Volume Precipitate
Premium Reagent Chemical reaction Stoichiometry
Interpretation of the Ratios 1) Current Ratio-It is a test of solvency or of short-term financial strength of a concern. It is an index of working capital and shows the ability of the concern to meet its obligations and also the capacity to carry on effective operations. Generally‚ if current assets are twice that of current liabilities‚ the concern’s working capital position is considered to be satisfactory. 2) Quick Ratio-It shows the amount of cash available to meet immediate payments. Stock-in
Premium Generally Accepted Accounting Principles Inventory Balance sheet
High Performance SQL Server Workloads on Hyper-V Windows Server 2008 R2 Technical White Paper Published: May‚ 2010 Applies to: Microsoft Windows Server 2008 R2‚ Microsoft SQL Server 2008 R2‚ Microsoft System Center Introduction: This white paper describes the advantages of deploying Microsoft® SQL Server® database application workloads to a virtualization environment using Microsoft Windows® Server® 2008 R2 Hyper-V™. It demonstrates that Hyper-V provides the performance and scalability
Premium Microsoft Operating system Windows Server 2008
Chemistry Experiment 6 Mole Ratio in a Chemical Reaction Background: Mole ratios of reactants are often times figured out by the use of the other products in a chemical equation. However‚ in the instance that the products’ mole ratios are unknown‚ it can be determined through the experiment. This method is called continuous variations. In this lab‚ I determined the mole ratio between Sodium Hypochlorite and Sodium Thiosulfate by using continuous variations of ratios in a given volume. This reaction
Premium Chemistry Chemical reaction Oxygen
Doing Statistical Analysis Excel provides a large number of statistical functions. These and the tools in the Analysis ToolPak cover most types of statistical analysis that you would need to do in finance and include in your models. Many people look at functions as "black boxes." You input the arguments‚ and the functions provide the answers. In a way this view is true‚ but it is also dangerous - you may use a function or tool incorrectly or misinterpret the results. So take the time to know
Premium Normal distribution Standard deviation Variance
Accounting Amy Doherty P5‚ M2‚ D2 1.0 Introduction In this report I am going to be analysing the profitability‚ efficiency and liquidity of SIGNature Ltd. As shown by their accounts for the year ended 31 January 2010. Ratio Analysis is a form of Financial Statement Analysis that is used to obtain a quick indication of a firm’s financial performance in several key areas. Ratio analysis is good because it helps to compare current performance with previous records and it also helps monitor
Premium Debt Generally Accepted Accounting Principles Ratio
analysis investigates the management policies of the two primary competitors of the Air Delivery & Freight Services industry. I use ratio analysis to peek under the covers of profitability to understand how management‚ investment and financial management activities impact the overall performance of FedEx and UPS and study how the ratios change over time for FedEx. Ratio Analysis Two competitors‚ FedEx and UPS‚ dominate the Air Delivery & Freight Services industry in the United States. FedEx is the
Premium Generally Accepted Accounting Principles Balance sheet Financial ratios
“Your black is showing.” I’ve been made fun of‚ excluded‚ and‚ of course‚ called a nigger‚ the timeless classic‚ but this comment stung the most. It came from my best friend at the time‚ in computers class. I misunderstood a concept or maybe a joke- I can’t remember now. Since then‚ I’ve thought of thousands of witty retorts‚ many of them bitter and malicious‚ but at the time‚ I sat in stunned silence. Then I slowly laughed along with him‚ because that’s what I’d always done. I used to be under the
Premium Human skin color Race Black people
build a paper plane out of the sheet of graph paper provided to you. The next day‚ you will bring in your plane and we will have a paper airplane contest!! There will be awards for longest flight‚ longest time in air‚ and fastest plane. The Rules of the Contest: 1. You will be given a sheet of graph paper from which to construct your plane. You can make test planes from sheets of regular paper‚ but your final product needs to be constructed out of the graph paper. 2. You will also be given
Premium Wing