Topic outline

  • COURSE INTRODUCTION

    Collapse all Expand all

    • Time: 11 hours
    • Free Certificate
    In this course, we explore how to format spreadsheet data to make the information easy to read and apply conditional formatting to draw attention to critical data. We will use formulas and functions with absolute and relative references to perform mathematical, statistical, financial, lookup, and logical computations. Then, we will learn how to build multi-page spreadsheets, add three-dimensional formulas to summarize data across several worksheets, and implement formulas and functions to present the consolidated information that exists in multiple workbooks.

    This course builds on the concepts and skills covered in Saylor Academy's introductory PRDV004: Spreadsheets course, which introduces the definition of a spreadsheet, how to navigate and enter data, open and save files, format spreadsheets, and enter basic formulas and functions for real-life applications. Each unit in this course builds on the previous unit, so make sure you have mastered each unit before moving on.