# Explore Data, Different Kinds and more!

### Explore related topics

*Excel 3D References* Use 3D references to work with several similar Excel worksheets at the same time. Peter Kalmstrom shows how to quickly add formulas to budget data for difference departments and then get sums of all data into a separate sheet for the whole company. Also refer to http://www.kalmstrom.com/Tips/Excel3Dformulas.htm

*Excel Formulas Between Sheets* Peter Kalmstrom shows how to create a formula that refers to a cell in another Excel sheet. See also http://www.kalmstrom.com/Tips/ExcelFormulasBetweenSheets.htm

*Excel Formulas, Basics 1* Peter Kalmstrom explains how to use Excel as it was intended - with formulas. This demo demonstrates how to make Excel calculate plus and minus. Also refer to http://www.kalmstrom.com/Tips/ExcelFormulas1.htm

Free excel templates! Tons of great stuff for us nerds out there. :-)

*Excel Holiday Calculator* How to use Excel for analyzing Costs. For more info and many other tips, please refer to http://www.kalmstrom.com/Tips/ExcelCalculator.htm

*Resource Booking in SharePoint* Book corporate resources with supplies in SharePoint. Peter Kalmstrom shows how you can make a simple resource booking system by using SharePoint resource calendars. For more info, please refer to http://www.kalmstrom.com/Tips/SharePoint2013UploadingFiles.htm

*Excel Cell Styles* Peter Kalmstrom shows how to apply Excel cell styles to protect some cells of a spreadsheet and allow editing of others. Also refer to http://www.kalmstrom.com/Tips/ExcelCellStyles.htm

*Excel Auto Sums and Custom Number Format* Peter Kalmstrom shows four ways to make Excel summarize cell values and one way to add a custom number format. Also refer to http://www.kalmstrom.com/Tips/ExcelAutoSum.htm

*Excel Sales Calculation* Peter Kalmstrom shows step by step how to create Excel formulas that calculate sales profits. VAT and discounts are included in the calculations. Also refer to http://www.kalmstrom.com/Tips/ExcelCalculateSales.htm

*Excel Formulas For Stocks Calculations* Peter Kalmstrom shows some basic Excel formulas that are useful when you want to calculate how the values of your stocks have changed. Also refer to http://www.kalmstrom.com/Tips/ExcelStocksFormulas.htm

Pinterest