YoVDO

Excel Beginner Tutorial - From Basics to Advanced Features

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Manipulation Courses Spreadsheets Courses Data Formatting 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 beginner tutorial. Dive into the essential features of this powerful spreadsheet application, starting with an overview of the interface and navigation techniques. Learn to efficiently enter, manipulate, and format data, while exploring basic formulas and functions for calculations. Progress through intermediate skills such as sorting, filtering, and creating charts to effectively analyze and present information. Discover time-saving tools like AutoFill, custom views, and worksheet management. Gain insights into advanced topics including XLOOKUP, database functions, and an introduction to macros for automating tasks. Whether you're new to Excel or looking to enhance your existing skills, this tutorial provides a solid foundation for organizing, analyzing, and presenting data effectively in various professional and personal contexts.

Syllabus

Start
Introduction
What is Excel?
Excel Interface Overview
Search and Help
Navigating and Selecting Cells
Entering, Replacing, and Deleting Data
Adjusting Cells
Calculations, Formulas, and Functions
Basic Functions
AutoFill
Relative and Absolute Cell Reference
Saving and Sharing Workbooks
Comments
Inserting Rows and Columns
Cut, Copy, and Paste
Formatting Data with Cell Styles
Managing Worksheets
Hiding Row and Columns
Creating Custom Views
Reviewing Worksheets
Printing Worksheets
Conclusion


Taught by

Learnit Training

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