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 Tutorials
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!
Make Bingo Cards with Words in Excel (+ video tutorial)
You can’t go wrong with a themed bingo game for your party or event! Read on for step-by-step instructions on how you can make bingo cards with words in Excel. FYI: in this example, we’ll walk through creating a 5×5 bingo card with words. How to Make a Bingo Game using Words in Excel WATCH: How […]