Data & Productivity

Excel Essentials

MyLoginn Learning Team · Free beginner course

4 weeks7 modules · 92 subtopicsFREEEssentialsExcelBeginner

Learn Excel from the interface to formulas, functions, charts, PivotTables, and data analysis for everyday work.

Level

Essentials

Modules

7

Topics

92

Duration

4 weeks

Course roadmap

A clear path through the material

Build your understanding one focused lesson at a time, from core ideas to practical programming.

Enroll free to unlock the lessons.

  1. 01
    Excel Foundations0/15 topics · 0%
    • 1Excel Intro
    • 2Excel Get Started
    • 3Excel Interface
    • 4Excel Workbooks and Worksheets
    • 5Excel Enter Data
    • 6Excel Save and Open
    • 7Excel Select Cells
    • 8Excel Fill Handle
    • 9Excel Move and Copy
    • 10Excel Insert and Delete
    • 11Excel Rows and Columns
    • 12Excel Number Formats
  2. 02
    Excel Formulas0/9 topics · 0%
    • 16Excel Formulas
    • 17Excel Operators
    • 18Excel Cell References
    • 19Excel Absolute References
    • 20Excel Named Ranges
    • 21Excel Order of Operations
    • 22Excel Formula Errors
    • 23Excel Copy Formulas
    • 24Excel Auditing Formulas
  3. 03
    Excel Functions0/27 topics · 0%
    • 25Excel Functions
    • 26Excel SUM
    • 27Excel AVERAGE
    • 28Excel MIN and MAX
    • 29Excel COUNT
    • 30Excel COUNTA and COUNTBLANK
    • 31Excel ROUND
    • 32Excel IF
    • 33Excel Nested IF
    • 34Excel AND/OR/NOT
    • 35Excel IFERROR
    • 36Excel COUNTIF
  4. 04
    Excel Data Tools0/13 topics · 0%
    • 52Excel Sort
    • 53Excel Filter
    • 54Excel Tables
    • 55Excel Remove Duplicates
    • 56Excel Text to Columns
    • 57Excel Flash Fill
    • 58Excel Data Validation
    • 59Excel Conditional Formatting
    • 60Excel Freeze Panes
    • 61Excel Group and Outline
    • 62Excel Subtotals
    • 63Excel Protect Sheets
  5. 05
    Excel Charts and Analysis0/13 topics · 0%
    • 65Excel Charts
    • 66Excel Column and Bar Charts
    • 67Excel Line Charts
    • 68Excel Pie Charts
    • 69Excel Combo Charts
    • 70Excel Sparklines
    • 71Excel PivotTables
    • 72Excel PivotCharts
    • 73Excel Slicers
    • 74Excel What-If Analysis
    • 75Excel Goal Seek
    • 76Excel Solver
  6. 06
    Excel Projects and Practice0/10 topics · 0%
    • 78Excel Examples
    • 79Excel Quiz
    • 80Excel Exercises
    • 81Excel Challenges
    • 82Excel Budget Project
    • 83Excel Sales Report Project
    • 84Excel Attendance Tracker Project
    • 85Excel Study Plan
    • 86Excel Interview Prep
    • 87Excel Shortcuts
  7. 07
    Excel References0/5 topics · 0%
    • 88Excel Reference
    • 89Excel Function List
    • 90Excel Keyboard Shortcuts
    • 91Excel Error Values
    • 92Excel Number Format Codes