How to Make and Use Excel Formulas (Beginner Bootcamp)

Spreadsheets are for everyone. They're used for everything from investment decisions to organizing a project. In this multipart beginner bootcamp series, we help you build your Microsoft Excel skills so that you can organize your life.

How to Make Excel Formulas - Bootcamp — Excel Formulas - Beginner Bootcamp (graphic source)

In this comprehensive guide, we have a range of tutorials to take you from a beginner Excel user to an advanced spreadsheet user. If you've never worked in a spreadsheet before, no problem; we'll help you make your first formula in Excel. Then, we'll give you ideas on how to use Excel formulas in your business.

Posts in this series

Quick Start: How to Make a Basic Formula in Excel
Formulas drive the usefulness of spreadsheets. Learn how to make and work with your first formula in Microsoft Excel, as well as how to use basic functions.
Andrew Childress
7 Mar 2017
Business
How to Use the Excel VLOOKUP Function - With Useful Examples
Need to match elements from two spreadsheet lists? Discover what VLOOKUP is, how to use VLOOKUP in Excel (with proper written formulas), and fix common issues.
Andrew Childress
15 Nov 2016
Business
How to Work With Excel Math Formulas (Guide to the Basics)
Never use a calculator again! In this tutorial, learn the essential Excel Math formulas for working with numbers and making calculations in Microsoft Excel.
Andrew Childress
6 Dec 2016
Business
How to Concatenate in Excel to Combine Text Strings
In this quick lesson, learn how to use Excel's concatenation feature to join text into strings. Skip the work of manually retyping data into your spreadsheets.
Andrew Childress
20 Dec 2016
Business
How to Use Simple IF Statements in Excel
Do you want to build smart options into your spreadsheets? Then, learn how to use IF statements in Microsoft Excel to make your spreadsheets much smarter.
Andrew Childress
4 Jan 2017
Business
How to Work With Date and Time Formulas in Excel
Master key formulas for working with dates and times in Microsoft Excel. Learn how to properly format dates/times and put Excel date formulas to good use.
Andrew Childress
19 Jan 2017
Business
How to Start Using COUNTIF, SUMIF, and AVERAGEIF in Excel
In this tutorial, learn how to use three conditional Excel math functions to add logic to your spreadsheets. Get started with COUNTIF, SUMIF, and AVERAGEIF.
Andrew Childress
31 Jan 2017
Business
How to Manage Your Excel Formulas: Copy, Paste and Autofill
Get started with managing Excel formulas. Learn quick workflows to write formulas, copy them, use autofill, and more. It's time to take control of your...
Andrew Childress
21 Feb 2017
Business