YoVDO

Microsoft Excel Beginner's Class - Mastering the Basics

Offered By: Teacher's Tech via YouTube

Tags

Microsoft Excel Courses Data Management Courses Spreadsheets Courses Data Entry Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Master the fundamentals of Microsoft Excel in this comprehensive 47-minute video tutorial. Learn essential skills including creating workbooks, navigating the interface, formatting cells, using formulas and functions, data management, and chart creation. Gain practical knowledge on saving work, printing, and customizing the Excel ribbon. Perfect for beginners or those seeking a refresher, this tutorial equips you with the necessary tools to boost productivity and enhance analytical capabilities in personal, academic, or professional settings.

Syllabus

Introduction: A brief overview of what this class will cover.
Opening Microsoft Excel: Getting started with Excel.
Creating a Blank Workbook: Learn how to start your Excel journey.
Basic Excel Terminology and Layout
Tabs, Ribbons, and Groups: Navigating the Excel interface.
Saving Your Workbook: Essential tips on saving your work.
Entering Column Headers
Formatting Columns and Rows: Adjusting widths and heights for better readability.
Formatting Text and Cells: Enhance the look of your data.
Using Cell Styles: Quick styling for efficient data presentation.
Text Wrapping and Merging Cells: Organize your data better.
Adding Dollar Symbols and Number Formatting: Essential for financial data.
Printing in Excel: Tips for perfect printouts.
Creating and Naming New Sheets: Organize your work effectively.
Creating Formulas with Cell References: Learn the basics of Excel formulas.
Absolute Cell Referencing: A key concept for formula accuracy.
Adding Functions 3 Ways: Enhance your data analysis skills.
Sorting and Filtering: Manage large sets of data easily.
Adding Charts: Visualize your data with charts.
Customizing Your Excel Ribbon: Personalize your Excel experience.


Taught by

Teacher's Tech

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard