Introduction to Formulas and Functions in Excel by CreateMyExcel ...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Building Basic Formulas
• 1 -Building Basic Formulas.mp4 (23.4 MB)
• 1 -Creating Basic Formulas - Complete.xlsx (395.4 KB)
• 1 -Creating Basic Formulas Teaching File.xlsx (394.1 KB)
• 1 -Creating Basic Formulas.pptx (377.9 MB)
• 10 -Controlling Worksheet Calculation.mp4 (26.8 MB)
• 11 -Reference Types in Formulas.mp4 (31.6 MB)
• 12 -Copying and Moving Formulas.mp4 (12.1 MB)
• 13 -Displaying Worksheet Formulas.mp4 (19.6 MB)
• 14 -Converting Formula to a Value.mp4 (20.6 MB)
• 15 -Working with Range Names in Formulas.mp4 (13.8 MB)
• 16 -Using a Range Name Into a Formula.mp4 (18.8 MB)
• 17 -Applying Range Names to Existing Formulas.mp4 (68.3 MB)
• 18 -Working with Links in Formulas.mp4 (38.8 MB)
• 2 -Understanding Formula Basics.mp4 (16.2 MB)
• 3 -Input Modes.mp4 (22.1 MB)
• 4 -Arithmetic Functions.mp4 (20.6 MB)
• 5 -Using Comparison Formulas.mp4 (23.0 MB)
• 6 -Text Formulas Introduction.mp4 (11.4 MB)
• 7 -Array References in Formulas.mp4 (24.1 MB)
• 8 -Understanding Operator Precedence.mp4 (24.4 MB)
• 9 -All Important ().mp4 (21.8 MB)
2 - Creating Advanced Formulas
• 1 -Creating Advance Formulas - Complete.xlsx (460.6 KB)
• 1 -Creating Advance Formulas - Teaching file.xlsx (437.0 KB)
• 1 -Creating Advanced Formulas.mp4 (16.2 MB)
• 1 -Creating Advanced Formulas.pptx (508.7 MB)
• 10 -Using Dialog Box Controls on a Worksheet.mp4 (17.9 MB)
• 11 -Using the Form Controls.mp4 (18.3 MB)
• 12 -Group Boxes & Option Buttons.mp4 (25.4 MB)
• 13 -Check Boxes.mp4 (16.6 MB)
• 14 -List Boxes & Combo Boxes.mp4 (13.9 MB)
• 15 -Scroll Bars & Spin Boxes.mp4 (16.7 MB)
• 2 -Working with Arrays.mp4 (42.8 MB)
• 3 -Array Formulas that Operate on Multiple Ranges.mp4 (20.9 MB)
• 4 -Using Array Constants.mp4 (35.2 MB)
• 5 -Functions that Use Arrays.mp4 (34.8 MB)
• 6 -Using Iteration and Circular References.mp4 (23.6 MB)
• 7 -Consolidating Data by Position.mp4 (53.4 MB)
• 8 -Consolidating Multi-Sheet Data by Category.mp4 (23.9 MB)
• 9 -Applying Data Validation Rules to Cells.mp4 (24.1 MB)
3 - Troubleshooting Formulas
• 1 -Troubleshooting Formulas - Complete.xlsx (447.8 KB)
• 1 -Troubleshooting Formulas - Teaching file.xlsx (447.3 KB)
• 1 -Troubleshooting Formulas.mp4 (18.1 MB)
• 1 -Troubleshooting Formulas.pptx (224.1 MB)
• 10 -Watching Cell Values.mp4 (9.0 MB)
• 2 -Understanding Excel's Error Values.mp4 (80.6 MB)
• 3 -Fixing Other Formula Errors.mp4 (35.9 MB)
• 4 -Handling Formula Errors with IFERROR.mp4 (13.3 MB)
• 5 -Using The Formula Error Checker.mp4 (22.1 MB)
• 6 -Auditing Worksheet.mp4 (20.8 MB)
• 7 -Tracing Cell Errors.mp4 (8.1 MB)
• 8 -Removing Tracer Errors.mp4 (8.2 MB)
• 9 -Evaluating Formulas.mp4 (10.7 MB)
4 - Understanding Formulas
• 1 -Understanding Formulas.mp4 (12.2 MB)
• 1 -Understanding Functions - Complete.xlsx (369.0 KB)
• 1 -Understanding Functions - teaching file.xlsx (368.8 KB)
• 1 -Understanding functions.pptx (55.4 MB)
• 2 -About Excel's Functions.mp4 (64.3 MB)
• 3 -The Structure of A Function.mp4 (26.8 MB)
• 4 -Typing a Function into a Formula.mp4 (38.5 MB)
• 5 -Using the Insert Function Feature.mp4 (14.1 MB)
• Bonus Resources.txt (0.1 KB)