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 Tutorials
How to Use the LEFT, RIGHT, MID and Text to Columns function in Excel – Tutorial
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.
How to Use VLOOKUP in Excel – Tutorial
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 […]
How to Add a Calculated Field to an Excel Pivot Table
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.
How to Create a Pivot Table in Excel – Tutorial
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.
How to Track your Spend Using Excel – Tutorial
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!