Step By Step Excel

What You Will Learn

Learn to use complex functions like VLookup, XLookup and HLookup,

Combining Data from multiple resources and Using Pivot Tables

Analayzing the data sets, Charts and Graphics, Setting Prints, Macros

creating Templates

Requirements

  • Basic knowledge about Excel, Workbooks Worksheets and working with data.

Description

This Course is designed for people with Basic knowledge about Excel. It covers Functions and Analyzing the Data and even Creating Templates.

It has various Exercises which are downloadable and contains very complex topics, that are suitable to be used in organizations in work as well as in home administration.

One who has done the course Part I will be very comfortable with the exercises and will find it easier to complete the exercises throughout the course.

The functions taught in the course are very popular and frequently used for ease in calculations and working on data. It is very important to move ahead and learn more about Excel.

I have covered Topics like

Textual Functions

Mathematical Functions

Logical Functions

Lookup and Reference Functions


Get Instant Notification of New Courses on our Telegram channel.


Time and Date Functions

Complex Calculations

Error Tracing in Calculations

Analysing the data by using Data Analysis and Solver

Creating Scenarios and Saving Scenarios

Combining Multiple Workbooks and Doing Consolidation of Data

Creating Templates and Inserting Templates in Microsoft Excel

The course has quiz after every session and project at the end of the Course.

When you understand Excel at a more advanced level, you will have the ability to use its more sophisticated tools, which will allow you to complete your tasks and analyze your data more quickly. It will also allow you to keep team members up-to-date on data, which can streamline the workflow process

It can boost your employability and career prospects, whilst also being a useful tool to analyze data in everyday life, such as when managing personal finances. Excel is easily accessible software that is a valuable tool in all aspects of life and should be considered critical for personal development.

Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks.

With a vast program full of formulae, it can add, subtract, multiply and divide hundreds of numbers altogether, and can easily re-do it if a value is changed or added. This feature can be used to easily make a company’s yearly sales and other spreadsheets.

Who this course is for:

  • Learn the advanced features in Microsoft Excel
  • Textual, Logical and Mathematical, Date and Time, Lookup and Reference Functions in Excel
  • Learn to Combine multiple Workbooks and link the data in the workbooks
  • Learn to Analyze Data by using data solver and data analysis

English
language