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

YouTube

Microsoft Excel Tutorial for Beginners

Simon Sez IT via YouTube

Start learning Write review
Coursera Ad

Get Coursera Plus for 40% off

Learn More → Datacamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Embark on a comprehensive 3-hour journey to master Microsoft Excel 2019 for beginners. Learn essential skills including creating formulas and functions, working with dates and time, printing specific pages, managing ranges, handling large files, and utilizing freeze panes. Explore the intricacies of Excel formulas, discover numerous tips and tricks, and gain confidence in spreadsheet manipulation. Follow along with downloadable exercises to reinforce your learning. Suitable for Excel 365, 2016, and 2013 users, this tutorial covers everything from basic navigation to advanced topics like 3-dimensional formulas, ensuring a solid foundation for Excel proficiency.

Syllabus

- Intro to Excel
- What's New In Excel 2019
- Course Overview
- Overview of the Excel window
- Mouse-Features
- Backstage View
- Entering Text and Numbers in Excel
- Creating Basic Formulas in Excel
- Relative References in Excel
- Order of Operations in Excel
- Working with Ranges in Excel
- Module 2 - Practice Exercise
- Working with the Save and Save As Commands
- File Extensions, Share, Export and Publish Files
- Module 3 - Practice Exercise
- Opening a File in Excel
- Working with Larger Files in Excel
- Freeze Panes in Excel
- Split Screen in Excel
- Module 4 Exercise
- Headers and Footers in Excel
- Print Titles
- Comments in Excel
- Page Setup Options in Excel
- Fit to Print on One Page in Excel
- Printing Workbooks in Excel
- Module 5 Exercise
- Adding and Deleting Columns and Cells
- Changing Column and Rows Widths
- Module 6 Exercise
- Copt, Cut and Paste
- Copying Formulas
- Module 7 Exercise
- Overview of Formulas
- Create Formulas Using Functions part1
- Create Formulas Using Functions part2
- Absolute Values
- Module 8 Exercise
- Adding Deleting and Renaming Sheets
- Additional Sheet Tab Options
- 3 Dimensional Formulas
- Module 9 Exercise

Taught by

Simon Sez IT

Reviews

4.4 rating, based on 12 Class Central reviews

Start your review of Microsoft Excel Tutorial for Beginners

  • Veronica Warioba
    Im very gratefully for this short online course. I was unable to know various things but i get to understand now all thanks to you
  • Profile image for Haseeb Ullah
    Haseeb Ullah
    This course is an excellent introduction to Microsoft Excel for beginners. The instructor explains each concept clearly and at a comfortable pace, making it easy to follow even if you have no prior experience with Excel. I appreciated the practical examples and demonstrations, which helped me understand how to use formulas, create charts, and manage data effectively. The lessons are well-structured and short enough to keep you engaged. By the end of the course, I felt confident using Excel for basic tasks at work. I would highly recommend this tutorial to anyone starting their Excel learning journeys

  • Profile image for Vandhana Krishnan
    Vandhana Krishnan
    clas was awesome and understandable i have complete in one structe bcz of the good presentation class was not boringg
  • Samuel Fonja Neri
    1
    It is really amazing. I now understand a lot more when I use Excel.Absolute value, adding, removing, and remaining sheet are the best brief tutorials within the function overview lesson that follows.
  • Profile image for DurgaMalleswari
    DurgaMalleswari
    Nice and easy to understand the each and every single top in this session or class.
    The model exercise are very nice
  • Shiekh Abduhu
    Amazing course I ever see because i am very big user of Ms excel and i learn a lot of things aboutd excel and i improve my self in Ms excel with the help of this video i love it and I also enjoy it. I am very satisfied and thankful of this website snd this channel and i will recommend it to my all friends
    Thank you
  • Profile image for Kanchan
    Kanchan
    This microsoft excel course very useful for beginners and most important thing it's a free course. It helps to students grow up.
  • Parakala Madhan Gpud
    Absoultey good one for every beginner explanation from scrath and a detailed explanation I recently completed an Excel course designed for beginners, and it was exactly what I needed! The course provided a solid foundation, covering the essentials of Excel in a structured and easy-to-follow format
  • Kamran Afridi
    Dear Simon ,
    I m kamran Afridi i love the way of your teching it was so simple but i capture all course secondly before start a course i thought that its very difficul for me but i was totally wrong its too easy with the hlep you
    Thanks
  • Profile image for Bhatia Harmeet
    Bhatia Harmeet
    The course is just excellent. The way of explanation is so so good . This course really help me a lot
  • Profile image for Pixule Mog
    Pixule Mog
    Good course for beginners, it explains the basics of how to use the program, how to format the date, ahat formulas are and how to print the data.
  • Profile image for Yanisa Chavengprasert
    Yanisa Chavengprasert
    It's helpful for me and I will find other courses to learn more
    I am beginner I am hopefully you will create new courses as soon as possible
Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.