Advanced Excel Techniques (SOT)

Advanced Excel Techniques (SOT)

Rs.1,000.00

18% GST Extra

Topics to be covered
  1. Introduction of Excel

    In this lecture, we will learn about the Microsoft Excel 2016 Interface in detail. We will also learn to create a new file in this lecture, save the file, open the saved file and print it.

  2. Basic formulas

    In this lecture, we will learn about basic formulas like "SUM", "AUTOSUM", "AVERAGE", "MIN", "MAX" and "ROUND".

  3. Functions

    In this lecture, we are going to learn in detail about functions such as "PMT", "FV", "COUNTIF", "SUMIF" and "AVERAGEIF".

  4. Data-Basics

    In this lecture, we will learn about data basics. With this, we will also learn about different number formats and flash fill.

  5. Pivot tables

    In this lecture, we will learn how to create a table, format them, sort and filter the data range, and add and delete rows and columns.

  6. Workbooks basics

    In this lecture, we will learn how to create excel pivot -tables. We will also talk about this and how it works.

  7. Charts and Graphs

    In this lecture, we will learn to work on multiple workbooks. We will also learn how to transfer information from one worksheet to another worksheet or transfer from one workbook to another.

  8. Worksheet basics

    In this lecture, we will learn about Charts and Graphs. With this, we will also learn how many types of these are and how they insert in their worksheet.

  9. Tables

    In this lecture, we will learn about worksheet basics. Here you have been told what the rows are, what are the columns and what the cells are. With this, you will also learn about sheet tabs.

Benefits:
  • Time-saving & Cost-effective
  • Get trained via industry experts (having 10+ years of experience in the same field, corporate trainers)
  • Full of hands-on practical exposure for better understanding
  • Adding super solid value in your professional career
  • Weekend Doubt clearing sessions.

For inquiry call:  9910043510

Summer Online Live Training Program 2020

Open chat
Powered by