Basic Excel Tutorial for Beginner | Excel Tutorial From Scratch | Excel Tutorial 2024 | Best Excel Tutorial for Beginner | Easy Tutorial for Beginner 2024

The self-tutorial was created especially for beginner Excel users, more precisely for “complete figures”. Information is given in stages, starting from the very beginning. From section to section of the tutorial, more and more interesting and exciting things are offered. After completing the entire course, you will confidently apply your knowledge in practice and learn how to work with Excel tools that will solve 80% of all your problems. And most importantly:

  • You will forever forget the question: “How to work in Excel?”
  • On our site you will find many more various courses, lessons, and tutorials on working in Microsoft Excel and more. And all this in one place!

Session 1: Excel Basics

  1. Introducing Excel
  2. Create and open workbooks
    • Create and open Excel workbooks
    • Excel compatibility mode
  3. Saving books and sharing
    • Save and auto-recover workbooks in Excel
    • Exporting Excel workbooks
    • Share Excel workbooks
  4. Cell Basics
    • Cell in Excel – basic concepts
    • Cell contents in Excel
    • Copy, move and delete cells in Excel
    • Autocomplete cells in Excel
    • Find and replace in Excel
  5. Modifying Columns, Rows, and Cells
    • Change column width and row height in Excel
    • Insert and delete rows and columns in Excel
    • Move and hide rows and columns in Excel
    • Wrap text and merge cells in Excel
  6. Formatting cells
    • Setting up a font in Excel
    • Align text in Excel cells
    • Borders, fills and cell styles in Excel
    • Number formatting in Excel
  7. Excel sheet basics
    • Rename, insert and delete worksheet in Excel
    • Copy, move and change the color of a worksheet in Excel
    • Grouping sheets in Excel
  8. Page layout
    • Formatting margins and page orientation in Excel
    • Insert page breaks, print headers and footers in Excel
  9. Book printing
    • Microsoft Excel Print pane
    • Setting the print area in Excel
    • Setting margins and scale when printing in Excel

Session 2: Formulas and Functions

  1. Simple formulas
    • Math operators and cell references in Excel formulas
    • Creating simple formulas in Microsoft Excel
    • Editing formulas in Excel
  2. Complex formulas
    • Introducing complex formulas in Excel
    • Creating complex formulas in Microsoft Excel
  3. Relative and absolute links
    • Relative links in Excel
    • Absolute links in Excel
    • Links to other sheets in Excel
  4. Formulas and functions
    • Introduction to functions in Excel
    • Insert a function into Excel
    • Excel function library
    • Excel Function Wizard

Session 3: Working with Data

  1. Controlling the appearance of a worksheet
    • Freezing regions in Microsoft Excel
    • Split sheets and view an Excel workbook in different windows
  2. Sorting data in Excel
    • Sorting in Excel – basics
    • Custom sorting in Excel
    • Sort levels in Excel
  3. Filtering data in Excel
    • Filter in Excel – basics
    • Advanced filter in Excel
  4. Working with groups and taking stock
    • Groups and subtotals in Excel
  5. Excel tables
    • Create, modify and delete tables in Excel
  6. Charts and spark lines
    • Charts in Excel – the basics
    • Layout, style, and other chart options
    • How to work with sparklines in Excel

Session 4: Excel Advanced Features

  1. Working with notes and tracking revisions
    • Track revisions in Excel
    • Excel revision review
    • Cell notes in Excel
  2. Completion and protection of workbooks
    • Shutdown and protect workbooks in Excel
  3. Conditional formatting
    • Conditional formatting in Excel
  4. Pivot tables and data analysis
    • General information about pivot tables in Excel
    • Data Rollup, Filters, Slicers, and PivotCharts
    • What if analysis in Excel

Session 5: Advanced Excel Formula Work

  1. Solving problems using logical functions
    • How to set a simple Boolean condition in Excel
    • Using Excel Boolean Functions to Set Complex Conditions
    • IF function in Excel with a simple example
  2. Counting and Summing in Excel
    • Counting cells in Excel using COUNT and COUNTIF functions
    • Summing in Excel using SUM and SUMIF functions
    • How to calculate the cumulative amount in Excel
    • Calculating the weighted average using SUMPRODUCT
  3. Working with dates and times in Excel
    • Date and time in Excel – basic concepts
    • Entering and formatting dates and times in Excel
    • Functions to extract various parameters from dates and times in Excel
    • Functions for creating and displaying dates and times in Excel
    • Excel functions for calculating dates and times
  4. Data search
    • VLOOKUP function in Excel with simple examples
    • LOOKUP function in Excel with a simple example
    • Functions INDEX and SEARCH in Excel with simple examples
  5. Good to know
    • Excel statistical functions you need to know
    • Excel math functions you need to know
    • Excel text functions by example
    • An overview of errors encountered in Excel formulas
  6. Working with names in Excel
    • Understanding cell and range names in Excel
    • How to name a cell or range in Excel
    • 5 useful rules and guidelines for creating cell names and ranges in Excel
    • Name Manager in Excel – tools and features
    • How to name constants in Excel?
  7. Working with arrays in Excel
    • Introducing array formulas in Excel
    • Multi-cell array formulas in Excel
    • One cell array formulas in Excel
    • Arrays of constants in Excel
    • Editing array formulas in Excel
    • Applying array formulas in Excel
    • Approaches to Editing Array Formulas in Excel

Session 6: Advanced

  1. Interface customization
    • How to customize the Ribbon in Excel 2013
    • Touch Mode Ribbon in Excel 2013
    • Link styles in Microsoft Excel

Speaking of spreadsheet-oriented programs, we have several alternatives of this type on the market, including one that integrates with Office. In particular, we are talking about Microsoft Excel, a program of this type has been excellent for many years. In fact, it is an application that does not stop growing over time based on new versions and updates .

It is worth noting that although at first glance this may seem like a software solution aimed at the professional market, in reality it is not. It is a valid program for all types of users and work environments, from home to the most professional. And this is because nowadays we can find people who use the program for basic calculation tasks, to make templates , etc .; or do home accounting.

At the same time, there are large companies that use them to manage their accounts on a large scale, which, of course, requires much more effort. Hence the success of the application as such and its huge market penetration. Of course, the complexity of this will depend on how much we are going to delve into working with it. At the same time, it will also affect how much we deepen their internal functions and modes of operation.

With all of this, in these same lines, we’ll talk about everything you need to know to get started with Excel from the beginning. We are also going to show you the most important basic concepts that you need to know in order to use the program and be able to use it in the best possible way.

VLOOKUP Graduation CourseSarkari YojanaIndia Top ExamExcel Tutorial
Spread the love

Leave a Comment