Global searching is not enabled.
Skip to main content

Topic outline

  • Introduction to the course

    In this Excel for WFM course we will show practical use of different functions and formulas, show you how to cut, paste and copy information and how to select cells.

    No previous knowledge is required to start with this course, except that you know how to start the excel program on your computer. Sometimes, a reference is given to the WFM glossary. Please make sure that you fully understand what the different terms and concepts mean when you start using them. When you have any questions, please use the forum, or participate in one of our feedback events to interact with one of our teachers.

    If you feel that you have already mastered the basics of Excel, we offer an opportunity to test out with the "Complete the course at once" quiz at the bottom of the course. More info on this are in its description.

    Please enjoy your course.

    • Cells, more cells, and what to do with them..

      In this section of the course we will go over the most important excel basics. And though some of them will feel pretty basic indeed, please bear with me, as thorough excel knowledge is essential for nearly all WFM-related activities

    • Basic Formulas and functions

      Restricted Not available unless: The activity (Conf-) Using the right format..... is marked complete

      Excel can help you with a lot of WFM calculations.

      One of the first things you should know, being interested in WFM, is that there is usually more than one way to do the math. In excel there is usually more than a dozen ways to do the math. It is all about keeping it simple and comprehensible. Sometimes using a formula is the answer, and sometimes it's better to use a function.

      In this apprentice course we will try to make you familiar with the syntax of some of the functions that are used a lot by WFM specialists like: Sum, Average, Min, Max and Count.



    • Good to keep in mind when designing a worksheet

      Restricted Not available unless: The activity What to do when you don't know what function to use? is marked complete

      When using Excel as one of your primary WFM tools, you will make your life, and that of your co-workers much easier when you use certain 'design' principles when building your spreadsheets. In this section we will discuss using cell references instead of fixed values, and how to design a proper table. In the Practitioner and Expert courses more is taught on designing WFM tools in excel.

    • Excel for WFM Apprentice QUIZ

      • The WFM Excel Apprentice quiz
        Restricted Not available unless: The activity Using reference cells in functions is marked complete
    • Feedback and Certificate

      Before you move on to the next topic we would like to hear your feedback!