Microsoft Excel : Beginner To Expert (Xl Formula & Function)

Beginner to advanced level guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas and Functions

What you'll learn

You will learn basic to advanced level of data management using Excel, Data analysis, Data visualization and representation etc.

You can learn Excel functions for processing data, i.e. create, edit, sort, analyze, and summarize data.

You will learn to create formulas and use built-in functions to perform calculations and solve problems.

You will learn to create PivotTables and to calculate, summarise, and analyse data for comparisons, patterns, and trends.

You will learn Financial Modelling and Business Accounting Excel Function and ANOVA Business Analytics

You will learn Data Searching, Ordering and Analysis, Import-export of data, online data collation and presentation

Requirements

To take-up the Microsoft Excel Course, no formal prerequisites for enrolling in a Microsoft Excel Certification program, it's recommended that candidate should have basic computer knowledge and skills.

To take-up this course some basic knowledge of english language is required.

Description

(I) Worksheet ManagementA Beginner to advanced level Guide to Microsoft Excel  in which you will learn Excel, Spreadsheets, Formulas, Shortcuts, MacrosLearn how to add, move, copy, and organize worksheets to structure your data and analysis efficiently(II) Data Analysis through Chart Learn basic and advanced techniques for data input and manipulation, including quick entry methods and quality control.Chart and Create and customize charts and PivotTables to visualize data effectively, aiding in clear and insightful analysis.Learn to efficiently create, save, open, and manage multiple workbooks to organize your data and projects effectively.Make  presentations using the Conditional and Table formatting optionsEffective Visual for viewers using Bar charts, Scatter Plots, Histograms etc.(III) Excel Formula and FunctionsLearning of all the essential Excel formulasProficiency in Excel data tools like Sorting, Filtering, Data validations and Data importingLearn very popular lookup functions such as Vlookup, Hlookup, Index and MatchHarnessing potential of Excel by creating Pivot tablesIncrease your efficiency by learning how to create and use important Excel shortcuts(IV) ExerciseTest your skills with question papers and case studies.Questions and AnswersGet lifetime access to project files, quizzes, homework exercises, formula functions, shortcut tricks and many more.

Overview

Section 1: Basics of Microsoft Excel

Lecture 1 Introduction of MS Excel Windows : Page View, Tools and Bars

Lecture 2 Introduction about Strips, Tools, Bars

Lecture 3 Calculating Sum, Multiplication of Numbers using formula

Lecture 4 Basic Worksheet Modelling

Lecture 5 Range Functions (Part-1) for Different Formula Creation in Worksheets

Lecture 6 Range Functions (Part-2) for Different Formula Creation in Worksheets

Lecture 7 V Look up Function (Part-1) for "looking-up" value from Worksheet ranges.

Lecture 8 V Look up Function (Part-2) for "looking-up" value from Worksheet ranges.

Lecture 9 H Look up Function for "looking-up" value from Rows in Worksheet ranges.

Lecture 10 Index and Match Function in MS Excel

Lecture 11 Text Function in MS Excel

Section 2: Excel Date & Time Functions with Formula

Lecture 12 Excel Date Functions (Part-1) with Formula

Lecture 13 Excel Date Functions (Part-2) with Formula

Lecture 14 Excel Date Functions (Part-3) with Formula

Lecture 15 Excel Date Functions (Part-4) with Formula

Lecture 16 Time Function in Excel

Section 3: Financial Modelling and Business Accounting Excel Function

Lecture 17 NPV - Net Present Value Function

Lecture 18 XNPV - Returns on Net Present Value Function

Lecture 19 Internal Rate of Return (IRR- Part 1) Function

Lecture 20 Internal Rate of Return (IRR- Part 2) Function

Lecture 21 Modified Internal Rate of Return (MIRR Part -1) Function

Lecture 22 Modified Internal Rate of Return (MIRR Part -2) Function

Lecture 23 Excel XIRR Function

Section 4: Data Searching, Ordering and Analysis

Lecture 24 IF Function in Excel

Lecture 25 IF ERROR Function in Excel

Lecture 26 Paste a Special Command

Lecture 27 INQUIRES Function

Lecture 28 COUNT FUNCTION

Lecture 29 COUNT A FN

Lecture 30 COUNT IF FN

Lecture 31 COUNTBLANK FUNCTION

Lecture 32 AVERAGE IF Function

Lecture 33 AVERAGEIFS Function

Lecture 34 MAXIFS Function

Lecture 35 MINIIFS Function

Lecture 36 SUMIF Function

Lecture 37 SUM IFS Function

Lecture 38 OFFSET Function

Section 5: Conditional Data Formatting and Sorting in Excel

Lecture 39 Conditional Formatting (Part-1) in Excel

Lecture 40 Conditional Formatting (Part-2) in Excel

Lecture 41 Sorting Data in Excel (Part-1)

Lecture 42 Sorting Data in Excel (Part-2)

Section 6: Introduction to Optimization with Excel Solver

Lecture 43 Introduction to Optimization

Lecture 44 Using Solver to Schedule Your Workforce

Lecture 45 Using Solver to Solve Transportation Problems (Part-1)

Lecture 46 Using Solver to Solve Transportation Problems (Part-2)

Lecture 47 Using Solver for Capital Budgeting

Lecture 48 Using Solver for Financial Planning

Lecture 49 Using Solver to Rate Sports Team

Lecture 50 Using Excel Solver to Find Optimal Warehouse Location

Lecture 51 The Traveling Salesperson Problem

Section 7: Importing / Exporting Data from a Text File or Document

Lecture 52 Exporting Data from a Text File or Document

Lecture 53 Importing Data from a Text File or Document

Lecture 54 Power Query (Get Data and Transform Function)

Lecture 55 Stock Data Types

Lecture 56 Geography Data Types

Lecture 57 Data Validation In Excel (Part-1)

Lecture 58 Data Validation In Excel (Part-2)

Section 8: Data Analysis, Presentation and Statistical Functions

Lecture 59 Column Charts

Lecture 60 Pie Charts

Lecture 61 Summarizing Data by using Descriptive Statics

Lecture 62 Creating Data Models

Lecture 63 Pivot Tables

Lecture 64 Pivot Introduction

Lecture 65 Summarizing Data through Statistical Functions

Lecture 66 Creating Sub-total (Part-1)

Lecture 67 Creating Sub-total (Part-2)

Lecture 68 Formula shortcut (Part 1)

Lecture 69 Formula shortcut (Part 2)

Lecture 70 Formula shortcut (Part 3)

Lecture 71 Using correlation to summarize relationship (Part -1)

Lecture 72 Using correlation to summarize relationship (Part -2)

Lecture 73 Simple Regression (Part -1)

Lecture 74 Multiple regression (Part - 2)

Lecture 75 Non-linear Regression (Part - 3)

Section 9: ANOVA Business Analytics

Lecture 76 Anova Introduction

Lecture 77 One Way Anova Business Analytics

Lecture 78 Two Way Anova Business Analytics (Part - 1)

Lecture 79 Two way Anova Business Analytics (Part - 2)

This course is for all those persons who are involved in data collection, compilation and tabulation work. The Microsoft Excel course provide essential skills for careers in data analysis, finance, and administrative tasks.,These programs cover everything from basic functions to advanced formulas and data manipulation techniques, enhancing proficiency in this tool.,This course is for all those who are interested in data for Business analysis and online data sourcing and presentation.