Microsoft excel course for beginner to advanced learners
MODULE 1 OF 6
There are over 26 lessons and 12+ hours of free Excel training available in video format.
Start learning for free without any sign-up requirements by simply scrolling down.
Get started with learning Excel today for free with our comprehensive Excel course with a certificate. Whether you're a beginner or intermediate learner, this is the perfect place to start. Access our free online Excel training, which includes 26 video lessons with over 12 hours of learning, without having to sign up for anything. All you have to do is scroll down and start watching the videos.
To maximize your learning experience, we recommend that you go through the Excel training videos in the sequence listed, which we've divided into 7 modules. If you're an intermediate or advanced user, feel free to choose which lessons you want to watch.
If you encounter any blurry videos, you can easily adjust the video quality to 720p by clicking on the settings gear icon located on the bottom right of the video screen. If you have any questions or feedback, kindly leave them in the comments area at the bottom of the page. Get your free Excel course with certificate now and start learning!
Modules Covered in this Free Excel Training
MODULE 1 / 6
Lession 1 - EXCEL BASICS (for Beginners)
This video covers essential topics, including the Excel working area's structure, navigation, ribbons, tabs, Quick Access Toolbar (QAT), Dialog Box & Task Panes, customizing ribbons and QAT, active cells, and using ALT shortcuts.
Lesson 2 - Data Entry, Data Editing, and Number Formatting
There are three types of data you can input in Excel: numeric, text, and formulas.
To enter data in a cell, select the cell and start typing. Afterward, press enter to move to the cell below. If you're entering dates, use a format that Excel recognizes as a date (e.g., 01-01-2020 or 01 Jan 2020 or 01/01/2020).
This video will demonstrate how to enter data in Excel and edit existing data (e.g., deleting data, modifying existing data, and replacing data).
Additionally, the video covers auto-fill in Excel and number formatting.
Lesson 3 - Data Formatting
Formatting data in Excel can enhance its appearance and emphasize key data points. For instance, you can highlight negative numbers by changing their color to red.
Below are some of the commonly used formatting options that make data more readable and visually appealing:
- Adding borders to all cells
- Boldening headers
- Adding background colors to headers
- Center-aligning headers
- You can access these formatting options in the Home tab under the Font category.
Lesson 4 - Working with Cells and Ranges in Excel
This tutorial explains the essential concepts of data formatting in Excel.
Data formatting in Excel can improve the appearance of your worksheet and emphasize significant data points. For example, you can highlight negative numbers by changing their color to red.
Here are some common formatting techniques that can make your data more visually appealing and easier to read:
- Adding borders to all cells
- Making headers bold
- Applying a background color to headers
- Center-aligning headers
- You can find these formatting options in the Home tab under the Font category.
Lesson 5 - Managing Worksheets
This lesson in the Free Online Excel Training covers how to manage worksheets in Excel.
The following topics will be covered:
- Navigating between worksheets in Excel
- Changing worksheet name and color
- Adding and deleting worksheets
- Hiding and un-hiding worksheets
- Moving and copying worksheets
- Comparing worksheets side by side
- Splitting a worksheet into panes
- Freezing panes
- Saving and opening workbooks