YoVDO

Excel 2019 Beginner Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Sorting Courses Data Filtering Courses Pivot Tables Courses Macros Courses

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 2010
Mirí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