Course curriculum

  • 1

    Welcome to Becoming Excel Superstar Course

    • Introduction

    • What You Will Learn in This Excel 365 Course?
  • 2

    What Is Spreadsheet ?

    • Why Do We Use Spreadsheet?

    • What Can Be Done by Spreadsheets?
  • 3

    Downloading Office 365

    • How to download Office 365?

    • Download Options for Office 365
  • 4

    Here We Go! Are You Ready To Become Excel Superstar?

    • Excel 365 - Landing Page Buttons and Blank Workbook

    • Ribbon and Tabs

    • Quick Access Toolbar and Status Bar

    • Workbook, Worksheet
  • 5

    Fundamentals of Excel 365

    • Rows, Columns and Grid Lines, Headings

    • Cell, Name of Cell

    • Data Entry

    • Basic Calculations and Cell References
  • 6

    Formatting Cells

    • Number

    • Alignment

    • Font

    • Border

    • Color of the Cells (Fill)
  • 7

    Supermarket Example

    • Insert Function and Use Formulas ( Sum, Average, Count Functions )

    • Percentage Calculation

    • Usage of Cursor Types and Auto Fill

    • Insert, Delete, Hide and Unhide Rows and Columns
  • 8

    Fast Formatting - Cells From Ribbon

    • Number

    • Alignment (Merge and Center)

    • Font, Border and Color
  • 9

    Fast Formatting - Styles

    • Conditional Formatting

    • Format as Table

    • Cell Style and Format Painter

    • Move or Copy Sheets and Create Your Template
  • 10

    Quick Analysis Feature of Excel 365

    • Formatting

    • Charts

    • Total, Tables, Sparklines
  • 11

    Quick Analysis Feature of Excel 365

    • Online/Offline Picture and Format

    • Shapes, Icons

    • Smart Art

    • Three Dimensional Models and Screenshots
  • 12

    Print an Excel Sheet (Page Setup)

    • Page Tab and Margins Tab

    • Header/Footer

    • Print Area
  • 13

    Online Spreadsheets

    • Excel Online

    • Google Spreadsheets

    • Main Differences Between Google Spreadsheets and Excel Online

    • Which One Should I Use?
  • 14

    What We Have Learned?

    • Here Is What We Covered in Excel 365 Course?