This course teaches learners the conventions and skills needed to effectively use Microsoft 365 Excel. The learning outcomes include understanding color coding conventions, naming conventions, Excel Ribbon tabs, Quick Access Toolbar customization, keyboard shortcuts, formula usage, data alignment, error tracking, and the overall purpose of Excel for data management and analysis. The teaching method involves a video tutorial with practical demonstrations. The intended audience for this course is beginners who want to learn the basics of Excel and conventions for organizing and working with data effectively.
Overview
Syllabus
) Introduction.
) Intro Song.
) Download Files and Create Class Folder.
) Change File Extensions in Windows Explorer.
) Color Coding Conventions for Class.
) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks.
) Naming Convention for all objects in class.
) Tabs in the Excel Ribbon.
) Quick Access Toolbar = QAT. Build Custom QAT.
) Navigating through Workbook.
) Keyboards: Desktop or Laptop?.
) Keyboard Shortcuts.
) First Formula: SUM function using a keyboard.
) Cursors.
) Data & Alignment and how Default Alignment Helps.
) Second and Third Formulas yield an error.
) Why Default Alignment is important: Fourth & Fifth Formulas.
) Default Alignment to track down errors.
) Don’t Use Center Alignment!!!.
) What Excel Does: Hold Data, Calculations and Data Analysis.
) Summary.
) Closing and Video Links.
Taught by
ExcelIsFun
Related Courses
-
Excel for the Real World: Gain the Basic Skills of Microsoft Excel
-
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
-
Excel & Business Math - Excel Built-in Functions, Data Types and Keyboards are Fast
-
Microsoft Word for Beginners - Training Course in Word 2021/365
-
The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners
5.0 -
Microsoft Excel Tutorial - Getting Started in Microsoft Excel 2021
