The most comprehensive formulary training course in Excel from beginner to professional in the form of 24 Excel formulation training interactive topics step by step makes you an Excel formulation expert and one quiz at the end. Excel Formula Writing Course | Basic to advanced Excel provides you with practical and professional examples of how to write more professional and accurate formulas in Excel. At the end of this Excel formula writing course, you can easily design and write complex Excel formulas for things like accounting. This course is a supplement to the applied Excel training course that you had been learned in ICDL Course: Microsoft Excel training course in our academia.
This course is held under the supervision of professional technical organizations and with the assistance of experienced professors with experience. After passing and completing the Excel advance course, jobseekers will learn how to create invoices, financial calculations, write formulas, get acquainted with common functions, draw various diagrams, and protect worksheets and printing principles.
Note: The prerequisite for this course ICDL Course: Microsoft Excel training course.
Introduction
-
1-About This Tutorial
Learn more about using formulas and functions in Excel or another spreadsheet application.
Formula and Function Basics
-
2-Simple Formulas
Learn all about creating simple formulas. -
3-Complex Formulas
Learn all about creating complex formulas. -
4-Relative and Absolute Cell References
Learn how relative and absolute cell references work. -
5-Functions
Learn all about using functions.
Formula Tips
-
6-Solving Real-Life Problems in Excel
Learn about solving real-life problems using Excel and other spreadsheet applications. -
7-Double-Check Your Formulas
Learn the importance of always double-checking your formulas. -
8-Understanding Number Formats
Better understand number formats, so you can use them properly in your spreadsheet. -
9-Practice Reading Formulas
Get practice reading formulas. -
10-Interactive: Formula Flashcards
Use this interactive to practice an Excel formula.
Scenarios
-
11-Over-Budget Items
Use a formula to determine which expenses are over budget in this interactive. -
12-Percent-Off Sale
Use a formula to determine how much everything will cost after a discount in this interactive. -
13-Basketball Team: Player Statistics
Use a formula to determine who scored the most points overall in this interactive. -
14-Movie Tickets
Use a formula to determine how much is left over after buying movie tickets for 4 in this interactive. -
15-Interactive: Pizza Party Panic
Use a formula to determine how much pizza is needed for a party in this interactive. -
16-Interactive: Birthday Budget Blues
Use a formula to determine how much a birthday party will cost in this interactive. -
17-Using the IF Function
Use the IF function to help solve this real-world problem. -
18-Using CONCATENATE to Combine Names
Use the CONCATENATE function to practice combining names in your spreadsheet. -
19-Buying a Printer: Cost Comparison
Use a formula to determine which printer is best in this interactive.
Advanced Scenario: Create an Invoice
-
20-Invoice, Part 1: Free Shipping
Use a formula to determine free shipping if the subtotal is less than $100 for a particular order. -
21-Invoice, Part 2: Using VLOOKUP
Use the VLOOKUP function to help process invoices. -
22-Invoice, Part 3: Fix Broken VLOOKUP
Fix a broken VLOOKUP function someone else created to help pull in new data correctly. -
23-Invoice, Part 4: More Shipping Options
Use the VLOOKUP function to determine new shipping options. -
24-Invoice, Part 5: Data Validation
Use data validation to help solve a real-world shipping problem.Quiz
-
25-Excel Formulas Quiz
Test your knowledge of Excel formulas by taking our quiz.
-