Select Your Style

Choose your layout

Color scheme

Crash Course in Advanced Excel Techniques

Crash Course in Advanced Excel Techniques

INR₹2,188.00 + GST

Please login to purchase the course.

Slides in English

Explanation in Hindi + English

Clear
SKU: cid_158969 Category: Tags: , ,
About the course

This course helps you to understand and work with some of the advanced techniques which are used in creating an Excel workbook or excel worksheets. In this course, you will learn to confidently manage worksheets and workbooks, enter data and be able to perform calculations by creating basic formulas. You will also be able to manipulate cell content, edit it, modify, format worksheets and workbooks.

You will also be able to work with advanced formulas, lists, and illustrations and work with charts and advanced formatting including styles. In addition to this, you will be able to use and apply Functions in formulas including the IF function in conjunction with other functions, utilizing the AND/OR functions, VLOOKUP function as well. Also, you will learn to create and manage Pivot Tables and create advanced chart elements. You will also get the feel of basic Macros. This is completely an online course and is accessible worldwide. It also has questions for hands-on practice. So, this makes it all together a complete package.

Credit Score  = 7+1+4+(14+1+48) = 75 (Formula to calculate credit score is available here)
Learning Outcomes

After completing this course, you will be able to:

  • Learn to use different functions like Pivot, Conditional formatting, Excel charts, etc.
  • Efficiently use the various basic, intermediate and advanced level features of Microsoft Excel
  • Automate repetitive tasks using Macros.
  • Boost your hireability through innovative and independent learning.
  • Get a certificate on successful completion of the course.
Target Audience

The course can be taken by:

Students: All students who use Excel regularly in their studies and wish to learn advanced techniques to get the most out of this versatile program.

Teachers/Faculties: All teachers/faculties who wish to acquire new skills or improve their efficiency in the use of Excel.

Professionals: All working professionals who wish to acquire new skills or improve their efficiency in the use of Excel, can take this course.

Why learn Advanced Excel Techniques?

Microsoft Excel is one of the most important tools because of the key role it plays in many sectors. It is the most used spreadsheet program, in many business activities, classwork, and even personal data organization. It was developed by Microsoft in 1985, with the sole purpose of helping businesses compile all their financial data, yearly credit, and debit sheets. Fast forward, to the future after 33 years, it is now the most commonly used program for creating graphs and pivot tables. MS Excel is used for various purposes by business establishments. Some organizations use this spreadsheet software for generating memos, track sales trends, and other business data. Microsoft Excel spreadsheets software come with million rows of data and automate number crunching, but this popular spreadsheet software is capable of doing more than just figures.

Nowadays in the ardent work environment, companies need to adjust to the low-cost efficient mechanism, managing data of businesses, daily transactions and so on. In the preceding situation, Excel helps us in sorting data, doing a calculation with the desirable result. By utilizing Excel our time will save, and it makes our work easy. This great application can be learned by Kids, Housewives, Professionals and so on. There is fairly huge demand for qualified professional in job markets. Students can work in offices and MNC companies. After completing the excel course, you will get job opportunities in different sectors. Thus it is worth learning this course.

Course Features
  • 24X7 Access: You can view lectures as per your own convenience.
  • Online lectures: 7 hours of online lectures with high-quality videos.
  • Hand-on-practice: Includes source code files for hands-on practice.
  • Updated Quality content: Content is latest and gets updated regularly to meet the current industry demands.
Test & Evaluation

There will be a final test containing a set of multiple choice questions. Your evaluation will include the scores achieved in the final test.

Note:
  1. The access to the course can be extended 3 months at a time (for upto 4 times) just by sending a mail requesting for an extension to the email id in the footer.
  2. The hard copy of the certificate shall be shipped to your registered address or your college
  3. There is no soft copy of the certificate.
  4. To get access to the certificate - you need to take the online exam at the end of the course

No prerequisites

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.

As a part of this program, you are required to do project work. The project specifications have been drawn in consultation with the industry. The project work has to meet these specifications and can be done in group of upto 5 members.

Use Microsoft Excel 2016 and create the following projects (~8 hours each):

  • Create a monthly budget of income and expenditures with some money set aside for savings. Compare the amount spent and saved. Draw pie chart for expenditures and saving.
  • Pretend that you have ₹50,000 to buy the ultimate computer system with scanner, color printer, lots of software. Use the Internet to research various products and calculate the costs of 5 different systems. Use plenty of formulas as you analyze costs and compare prices.
  • Compare prices on over a dozen products on lots of different websites, such as the bookstore amazon.com versus the Barnes & Nobles website. Calculate cost savings over shopping in local stores. Don't forget to include shipping & handling charges and taxes.
  • Calculate total calories consumed and total exercise with calories burned. Use web research to explore low-fat menus and various exercise programs. Compare calories from a healthy home-cooked meal to a fast food meal.
  • Imagine the start-up costs for a new business. One student dreamed about a business that would make custom surfboards, so he did web research (and some guessing) on the type of equipment needed, advertising budget, raw materials, labour for artists & other employees, his own salary. The actual data (whether realistic or fantasy) is less important than the technical uses of a variety of formulas, graphs, and formats. You could try to predict what sales would be. You might go any corporate web site and look at the info presented for stockholders. Go to www.microsoft.com -- look at the blue index on the left side. Visit "Company Overview" and "Investor Relations." Check how earnings, investment, and annual report data is presented.
  • Create a Hockey pool for with 8participants.Give each participant a first and last name.  Each participant must pick 3 defense, 4 wingers, 2 centers and 1 goalie. You can decide how the point system will work, but it must be described somewhere on the spreadsheet.  Have a section which lists the participant’s picks, including team, position, # of goals, and #of assists. Have a ‘standings section’, which automatically adjusts which participant is in the lead and rank them from descending order

Please note that you may need to do research to collect information on the Internet.  The more in-depth your research will be, the better will be your project.

Also make sure that these slides or programs are not copied from any source and it should be based on your own research / learning from the course

You may also like…