Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Beginner Tutorial - From Basics to Advanced Features

Learnit Training via YouTube

Overview

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Excel Beginner Tutorial - From Basics to Advanced Features

  • Profile image for Dhriti
    Dhriti
    Thank you so much it really helped me a lot with the , as a newbie to these things , the videos made the functions and all easy to understand .

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.