Introduction to Microsoft 365 Excel and Conventions for Class

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn the fundamentals of Microsoft 365 Excel in this comprehensive video tutorial. Begin by setting up your workspace, understanding file management, and learning essential color-coding conventions. Explore the Excel interface, including rows, columns, cells, worksheets, and workbooks. Master naming conventions, navigate the ribbon, and customize the Quick Access Toolbar. Discover efficient navigation techniques, keyboard shortcuts, and the importance of proper data alignment. Practice creating formulas, including the SUM function, and learn to identify and troubleshoot errors. Gain insights into Excel's primary functions for data management, calculations, and analysis. Download accompanying files to follow along and reinforce your learning experience.

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.