Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn the fundamentals of Microsoft Excel 2019 in this comprehensive beginner tutorial. Start with the basics of navigating the user interface and quickly progress to calculating data using formulas and functions. Explore advanced features such as sorting and filtering data, creating pivot tables, and using IF functions. Discover time-saving techniques like automating common tasks with macros. Cover essential topics including entering and formatting data, using AutoSum and AutoFill, working with cell styles and worksheet themes, and customizing views. Master practical skills for efficient spreadsheet management, from freezing panes and grouping worksheets to optimizing page layout and printing. Suitable for beginners and experienced users looking to enhance their Excel proficiency and streamline data organization.
Syllabus
Start
Introduction
Start Screen & Templates
Ribbon & Quick Access Toolbar
Backstage View
Smart Lookup & Tell Me
Interface
Navigation
Keyboard Shortcuts
Entering Text
Number Formats
Deleting & Formatting
AutoSum
Simple Formulas
Simple Functions Part 1
Simple Functions Part 2
Absolute Referencing
Moving & Copying Data
Inserting Rows & Columns
AutoFill
Cell Styles
Worksheet Themes
Excel Templates
Freeze Panes
Grouping Worksheets
Page Layout View
Custom Views
Spell Check
Printing
Taught by
Learnit Training