Word search puzzles are a great idea for team building events, work parties, family gatherings and more. Plus, they’re pretty easy to make! Here are step by step instructions of how you can make a word search in Excel. Make a Word Search in Excel (easy to do!) Click to Watch the Tutorial 1. Prepare […]
Excel tutorial on how to use the LEFT, RIGHT, MID and Text to Columns Functions to Pull Data from within cells in Excel. We also extract data using Text to Columns.
Excel tutorial on how to use the VLOOKUP formula in your spreadsheets. VLOOKUP can help save time when you need to find something within a dataset. How does VLOOKUP work in Excel? VLOOKUP, or vertical lookup, helps to find, or “look up,” data within a range of columns in an Excel spreadsheet. Once you identify […]
Excel tutorial on how to add pivot table calculations. Calculated fields in Excel are formulas created inside a pivot table. These pivot table formulas add more functionality to your data analysis.
Excel tutorial on how to make Excel pivot tables. Excel pivot tables are a very powerful tool for organizing and manipulating large data sets. Pivot tables allow you to create dashboards, summarize data and, with the use of calculated fields, easily add calculations.
Learn how to track spend using Excel! In this short Excel tutorial, we create a spend tracker file that can be used to track spend and track when bills are due. You can use this to help you budget!