Excel tutorial on how to use the MID function in Excel when you don’t know the position of the character where that data begins. The MID function in Excel lets you extract data from inside a cell in Excel, but normally you need to know in which character to start applying the function in. Take […]
Functions / Formulas
How to Use the FIND + SEARCH Functions in Excel – Tutorial
Excel tutorial on how to use the FIND function and SEARCH function in Excel to find the numerical position of a character within a cell. These formulas are often used inside other formulas where cell position is important – for example in the LEFT, RIGHT or MID functions.
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.