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. Discover how to navigate the user interface, perform basic calculations using formulas and functions, and efficiently organize data. Explore essential features such as AutoSum, cell formatting, and worksheet themes. Master time-saving techniques like AutoFill, custom views, and keyboard shortcuts. Gain practical skills in data entry, number formatting, and cell referencing. The tutorial covers crucial topics including inserting rows and columns, grouping worksheets, and preparing documents for printing. Perfect for beginners and experienced users looking to enhance their Excel proficiency, this course provides a solid foundation for working with spreadsheets and data analysis.
Syllabus
Start
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