Excel - A Beginner’s Guide to Formulas and Functions
Webinar Details $219
- Webinar Date: June 13, 2024
- Webinar Time: 12:00pm - 1:40pm EDT live
- Webinar Length: 100 Minutes
- Guest Speaker: Mike Thomas
- Topic: Business Skills, Software, Finance, Human Resources, Taxation and Accounting
- Credit: CPE 2.0, ATATX 1.5, ATAOP 1.5
-
-
- Creating basic formulas: addition, subtraction, division, multiplication
- Using parentheses in formulas - the what and why
- Copying a formula - the gotchas you need to know about
- Make formulas logical and understandable by assigning names to your important cells
- An introduction to functions: SUM, AVERAGE, COUNT and SUBTOTAL
- The SUMIF and COUNTIF function: Add up and count based on criteria
- Use TODAY, DATEDIF and NETWORKDAYS to calculate and manipulate dates
- Use CONCATENATE and TEXTJOIN to combine text from multiple cells
- Introduction
- What Is A Formula? 00:02:26
- Basic Formulas 00:03:56
- Dates 00:13:53
- Percentages 00:19:07
- More Basic Formulas 00:23:57
- Brackets/Parenthesis 00:29:50
- Seeing An Error When Formula Is Entered In Correctly 00:39:00
- Copying Formulas Down A Column 00:40:55
- Dragging Dates Down A Column Without Increasing Numbers 00:47:02
- Absolute 00:47:43
- Exclamation Mark 00:56:01
- Add Up Multiple Numbers In A Column 00:57:16
- Presenter Closing 00:59:21
- Presentation Closing 01:00:22
- Cell 00:25:36, 00:31:45, 00:35:27, 00:44:45, 00:51:50, 00:57:09
- Cell Reference 00:40:36, 00:52:24, 00:56:56
- Column 00:27:29, 00:57:16
- Formula 00:02:11, 00:05:58, 00:14:37, 00:18:04, 00:26:25, 00:28:34, 00:35:20, 00:40:28, 00:44:48
- PEMDAS 00:30:01
- Spreadsheet 00:05:08, 00:42:51
Cell: In spreadsheet applications, a cell is a box in which you can enter a single piece of data. The data is usually text, a numeric value, or a formula. The entire spreadsheet is composed of rows and columns of cells.
Cell Reference: A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. There are three types: Relative, Absolute, and Mixed
Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.
Formula: A formula is an expression which calculates the value of a cell.
PEMDAS: PEMDAS is an acronym for the words parenthesis, exponents, multiplication, division, addition, and subtraction. Given two or more operations in a single expression, the order of the letters in PEMDAS tells you what to calculate first, second, third, and so on, until the calculation is complete.
Spreadsheet: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.