Broad, helpful guidance and information for controlling costs for foodservice managers and students In order for foodservice managers to control costs effectively, they must have a confident command of accounting, marketing, and legal issues, as well as food and beverage sanitation, production, and service methods. Useful Microsoft Excel Functions & Formulas Theresa A Scott, MS Department of Biostatistics Vanderbilt University [email protected] This document contains a series of examples that illustrate some useful functions and formulas you can use in Microsoft Excel. It is meant to be an extension of my “Formulas & Functions in Microsoft Jun 22, 2017 · Workbook — The workbook refers to an Excel spreadsheet file. The workbook houses all of the data that you have entered and allows you to sort or calculate the results. A workbook that is available to be viewed and edited by multiple users on a network is known as a Shared Workbook. If you use Excel on a daily basis, then you’ve probably run into situations where you needed to hide something in your Excel worksheet. Maybe you have some extra data worksheets that are referenced, but don’t need to be viewed. Or maybe you have a few rows of data at the bottom of the worksheet that need to be hidden. Creating A Grade Sheet With Microsoft Excel Microsoft Excel serves as an excellent tool for tracking grades in your course. But its power is not limited to its ability to organize information in rows and columns. Using formulas and functions in Excel, you can simplify the grading process. With Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas: Simple (or "Gray Cell") Tables, which I've used since Excel 2.0. Excel Tables, introduced in Excel 2007. PivotTables with a Tabular Report Layout, introduced in Excel 2010. Mar 11, 2014 · The Excel 2013: Introducing Excel course from Udemy offers a complete introduction to Excel 2013 with video tutorials and step-by-step instructions to help you harness the power of Excel. This cheat sheet contains instructions for some of the most popular formulas available in Excel as well as a guide to cell references and names.