Skip to main content

Microsoft excel course for beginner to advanced learners - MODULE 1

Microsoft excel course for beginner to advanced learners

MODULE 1 OF 6

Microsoft excel course for beginner to advanced learners


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) 



If you're an Excel beginner, this video is for you. It explains the various parts of the Excel working area.

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




After becoming comfortable with the layout of Excel, the next step is to learn how to enter and edit data in the software.

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 


In this video, you'll learn the fundamentals of data formatting in Excel.

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
Join Us On Telegram

Comments

Popular posts from this blog

संभाषण कौशल्य, इंग्रजी सुधारणा, ईमेल लेखन, फोन कौशल्ये ! Commuinication Skill FREE COURSE IN MARATHI

संभाषण कौशल्य, इंग्रजी सुधारणा, ईमेल लेखन, फोन कौशल्ये ! Commuinication Skill FREE COURSE IN MARATHI Enroll Now तुम्ही काय शिकाल ? इंग्रजी सुधारणा फोन संभाषणे कशी करावी प्रभावी ईमेल कसे लिहावे या कोर्सचा सिलॅबस  संभाषण कौशल्य, इंग्रजी सुधारणा, ईमेल लेखन, फोन कौशल्ये आपल्याला या कोर्सचे 9 फायदे मिळतील: 1. प्रूव्हन ज्ञान, त्यामुळे आपला आत्मविश्वास वाढेल 2. सॉफ्ट स्किल्स सुधारणा ह्या बद्दल सविस्तर माहिती 3. पॉवरफुल रेझ्यूमे 4. 33 उदाहरणे 5. स्टेप बाय स्टेप मार्गदर्शन 6. प्रॅक्टीकल टिप्स हा कोर्स इंग्रजी उदाहरणांसह मराठीत आहे. 1 तास 1 टू 1 व्हिडिओ कोचिंग सत्र इंग्रजी सुधारणेसाठी 5 सवयी फोन कॉल रचना एखाद्याला कसे अभिवादन करावे प्रभावी ईमेल लिहा लेखनाद्वारे आपली विशिष्ट कौशल्ये आणि वैशिष्ट्ये दर्शवा इंग्रजी सुधारण्यासाठी टिप्स फोनवर बोलण्याची कौशल्ये E-BOOKS ON COMMUNICATION कोच : मयूर  पांगरेकर  Life Coach, Business Coach, Corporate Trainer Enroll Now Join Us On Telegram

Comprehensive User Manual for Filing ITR-1 (Sahaj) Online - How To File Income Tax for Salaried Person

Introduction The e-Filing portal offers registered users the convenient option to pre-fill and file their ITR-1 (Sahaj) online. This service is designed to assist individual taxpayers in filing their ITR-1 form seamlessly. Whether it's through the e-Filing portal or the offline excel utility, this user manual provides a detailed guide on the step-by-step process of filing ITR-1 online. Basic Requirements before starting General: You must be a registered user on the e-Filing portal and have a valid user ID and password. Ensure that your PAN (Permanent Account Number) status is active. Others: Link your PAN with Aadhaar. It is important to note that if your PAN is not linked with Aadhaar, it will be considered inoperative. In such cases, you will receive a notification stating, "Your PAN is made inoperative as it is not linked with Aadhaar. Some accesses may be limited. You can link and make your PAN operative after payment u/s 234H." Pre-v