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.