Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel tutorial - Fundamental Tools to Work Smarter in 2026
3 students

Excel tutorial - Fundamental Tools to Work Smarter in 2026

Learn to use essencial tools of Microsoft Excel to format data, and manipulate your dataset using formulas & functions
Created byLuis Carlos
Last updated 5/2026
English

What you'll learn

  • Microsoft Excel fundamental tools to work a dataset
  • Understand Excel interface
  • Work faster with quick access toolbar
  • Work with ribbon and customize it
  • Format data
  • Add and remove columns and rows
  • Use format painter
  • Change number format
  • Understand different type of cell references
  • Understand and create formulas
  • Use functions to work your dataset

Course content

3 sections • 28 lectures • 2h 14m total length

  • Introduction1:56

    Learn the fundamentals of Excel to create, edit, and manage data in spreadsheets; explore the interface, customize sections, and use formulas and functions to perform tasks efficiently.

  • Excel interface overview4:25

    Explore the Excel interface, including the top menus, ribbon, quick access toolbar, and workbook tabs, and understand how worksheets, cells, name box, status bar, and formula bar support data entry.

  • Excel Ribbon - How to work and how to customize3:50
  • Quick Access Toolbar - How to use and edit1:38

Requirements

  • Work with computer

Description

Hello, my name is Luis Carlos and I will be the instructor in this class of Microsoft Excel.

This class is made for beginners, being divided into different sections.

In the first part you will learn the interface excel and how it is divided. The ribbon customization and quick access toolbar will be another important point that allows to adapt the working environment to the needs of the user.

In a second part we will learn how to create and open excel files, add, delete and change the name of worksheets and in a third part of the course we learn to insert data manually and automatically and work with cell and text formatting tools.

The last part will be dedicated to formulas and functions that will be an important step to work the data automatically in the worksheet.

To follow all the lessons, is available a file exercises.xlsx in the introduction video(first course video) that can be used by the students to make all exercises made in the videos.

This class is compatible with the latest versions of Microsoft Excel (2007 / 2010 / 2013 / 2016 / 2019)

List of main topics:

  • Excel interface

  • Customizing the Excel Quick Access Toolbar

  • Understanding the Structure of an Excel Workbook(anatomy)

  • Customize ribbon and quick access toolbar

  • Create, Save and open an Excel Document

  • Add, rename, delete worksheet

  • Enter text manually and automatically with autofill tool

  • Format data

  • Wrap, shrink and merge text

  • Format painter tool

  • Format numbers - Change format to date and time

  • Cell references - relative, absolute and mixed

  • Create formulas using logical operators

  • Functions syntax - Learn and apply the main used functions

Who this course is for:

  • Beginners with Excel that need to work their data using smart methods
  • People curious about computer science

Report abuse