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

Документы и презентации в LaTeX (Introduction to LaTeX)
Higher School of Economics via Coursera
Excel Avanzado
Miríadax
Excel aplicado a los negocios (Nivel Avanzado)
Universidad Austral via Coursera
Excel Skills for Business: Intermediate II
Macquarie University via Coursera
Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX