Excel 2019 Beginner Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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
Related Courses
Excel 2010Miríadax Excel Avanzado
Miríadax Problem Solving with Excel
PwC via Coursera Excel: gestión de datos
Universitat Politècnica de València via edX Excel によるデータの分析と可視化
Microsoft via edX