Excel with Excel: Learn to use Microsoft Excel 2021 Part 2


Step By Step Excel

English
language

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

Time and Date Functions


Subscribe to latest coupons on our Telegram channel.

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

Course content

1 section • 6 lectures • 2h 19m total length

  • Introduction

    04:42

  • Be Function Friendly Using Textual, Mathematical and Logical Functions Together

    35:42

  • Textual, Mathematical and Logical Functions

    5 questions

  • Be Function Friendly Using Time and Date Functions Together

    10:53

  • Reordering and Sorting with Lookup and Reference

    43:32

  • Sorting and Lookup with reference

    5 questions

  • Combining Data From Multiple Workbooks

    18:08

  • Combining Multiple Workbooks

    5 questions

  • Analyzing Data Sets, Solver and Scenarios

    26:34

  • Analyzing Data Sets , Solver and Scenarios

    5 questions

  • Project Part II

    1 question

Enroll for Free

Share This Course on:
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock