Logo
Post
Image
Izhar Sabri
Sr. Instructor
Category :

Microsoft Excel

258 Reviews:

Overview

XL Technologies is a company specializing in corporate training for Advanced Microsoft Excel and Microsoft Office Professional. Our team comprises skilled trainers with over five years of experience in corporate training. Our tailored training program is designed to elevate your abilities in creating accurate and efficient reports through the utilization of intricate formulas, charts, and graphs. This course will significantly enhance your productivity and contribute to your professional distinction.

Benefits of the Course

The following are some of the key areas wherein the complete knowledge of excel is essential to secure a job. It works as a GREEN CARD for your easy entry apart from being a professional tool.

  • Individuals with MBA, BBA, B.COM, M.COM, MIB, MSW, MA HRM, MA Eco seeking for their first job or experienced professional who want to enhance their work efficiency.
  • Accounting & Book keeping
  • MIS (Management Information System)
  • Financial Modeling
  • Financial Analysts
  • Data Analyst/ Data Scientist
  • Business Analysts
  • Market Research
  • Investment Banking
  • Logistics Executives
  • Human Resource
  • Billing & Project Planning (For Engineers)
  • Backend Process

What you'll learn

  • MIS Reporting & Data Analysis in Excel
  • 50+ Formulas + New Formulas in Excel 365
  • Dynamic Dashboard & Data Visualization
  • V & H Lookup with 15+ Real Examples
  • Macros Automation

Topics for this Course

  • icon 14 Module
  • icon 42 Live class
  • icon 96 Assignment
  • icon 14 Test Project

  • icon Lecture 1.1 About excel (Intro)
  • icon Lecture 1.2 Setting up column and row / Dragging cells
  • icon Lecture 1.3 Basic mathematical calculations
  • icon Lecture 1.4 Paste special and format painter
  • icon Lecture 1.5 Custom formatting and alignment
  • icon Lecture 1.6 All numbers formatting
  • icon Lecture 1.7 Conditional formatting
  • icon Lecture 1.8 Sorting / Custom sorting
  • icon Lecture 1.9 Data filtering (Basic / Advance)

  • icon Lecture 1.1 Pivot Intro
  • icon Lecture 1.2 Use of Rows fields, Column fields & Report Filters
  • icon Lecture 1.3 Use of Value Field Setting in Pivot
  • icon Lecture 1.4 Arranging Date Field in Pivot
  • icon Lecture 1.5 Grouping in Pivot
  • icon Lecture 1.6 Report Layouts in Pivot
  • icon Lecture 1.7 Making Pivot Range Dynamic
  • icon Lecture 1.8 Calculated Fields in Pivot

  • icon Lecture 1.1 Use of Percent of Grand Total
  • icon Lecture 1.2 Use of Row & Column Total
  • icon Lecture 1.3 Difference from & Percent Difference From
  • icon Lecture 1.4 Use of Percent of
  • icon Lecture 1.5 Ranking in Pivot
  • icon Lecture 1.6 Running Total ( Cumulative Frequency)

  • icon Lecture 1.1 Use of Slicer in Pivot
  • icon Lecture 1.2 Pivot Connections with Slicer
  • icon Lecture 1.3 Use of Timeline
  • icon Lecture 1.4 Making Pivot Charts
  • icon Lecture 1.5 Use of Legends in Pivot Charts
  • icon Lecture 1.6 Dashboard Using Slicer and Pivot Charts

  • icon Lecture 1.1 Column, Line, Pie, Bar, Area, Scatter Charts
  • icon Lecture 1.2 Different Methods of Making Charts
  • icon Lecture 1.3 Difference between Clustered & Staked Charts
  • icon Lecture 1.4 Charts Elements Setting
  • icon Lecture 1.5 Linear & Linear Forecast Trend Lines
  • icon Lecture 1.6 Overview of Deep Settings

  • icon Lecture 1.1 Hyperlinking Websites, E-mail, and Files
  • icon Lecture 1.2 Hyperlinking Sheet Cells
  • icon Lecture 1.3 Header And Footer
  • icon Lecture 1.4 Page Setup (Margins, Size, Printing Area)
  • icon Lecture 1.5 Print Titles (Top & Left)
  • icon Lecture 1.6 Content Printing Solutions

  • icon Lecture 1.1 Formulas Intro (Concept & Operators)
  • icon Lecture 1.2 If Function with Logical Arguments
  • icon Lecture 1.3 Nesting with if
  • icon Lecture 1.4 And + Or Formulas in Excel
  • icon Lecture 1.5 Nesting with If + And + Or
  • icon Lecture 1.6 If Error Implementation

  • icon Lecture 1.1 Concatenate
  • icon Lecture 1.2 Upper, Lower, Proper & Trim
  • icon Lecture 1.3 Len & Rept
  • icon Lecture 1.4 Find & Search
  • icon Lecture 1.5 Replace & Substitute
  • icon Lecture 1.6 All above formulas and its Implementation on Real Corporate Data.

  • icon Lecture 1.1 Date & Time Formula
  • icon Lecture 1.2 DateValue & TimeValue
  • icon Lecture 1.3 Day, Month, Year Formulas
  • icon Lecture 1.4 Edate, EOMonth
  • icon Lecture 1.5 Networkdays & Networkdays.INTL
  • icon Lecture 1.6 All above formulas and its Implementation on Real Corporate Data.

  • icon Lecture 1.1 Relative & Absolute References
  • icon Lecture 1.2 Vlookup Intro (Concept & Arguments)
  • icon Lecture 1.3 Use of Vlookup with Different Scenarios
  • icon Lecture 1.4 Vlookup With Match
  • icon Lecture 1.5 Approximate Match & Exact Match in Vlookup
  • icon Lecture 1.6 Vlookup on Large Corporate Data
  • icon Lecture 1.7 Hlookup Formula
  • icon Lecture 1.8 Index & Match Formulas
  • icon Lecture 1.9 All above formulas and its Implementation on Real Corporate Data.

  • icon Lecture 1.1 Sumif & Countif
  • icon Lecture 1.2Sumifs & Countifs
  • icon Lecture 1.3Averageif & AverageIfs
  • icon Lecture 1.4 Count Blank & CountA
  • icon Lecture 1.5 Dynamic Data Update With Above Functions
  • icon Lecture 1.6 All above formulas and its Implementation on Real Corporate Data.

  • icon Lecture 1.1 Name manager & Auditing formals
  • icon Lecture 1.2 Getting external data (Access, SQL)
  • icon Lecture 1.3 Advance filter
  • icon Lecture 1.4 Text to column wizard
  • icon Lecture 1.5 Remove duplicates
  • icon Lecture 1.6 Setting up data validations (with creating drop down list)
  • icon Lecture 1.7Consolidation & Scenario manager
  • icon Lecture 1.8 Goal seek and data table
  • icon Lecture 1.9 Recording & Assign Macros
  • icon Lecture 1.10 Advance conditional formatting
  • icon Lecture 1.11 Course Revision & Doubt Clearing Session

  • icon Lecture 1.1 Abs Formulas
  • icon Lecture 1.2 Round / RoundUp /RoudnDown
  • icon Lecture 1.3 Small & Large
  • icon Lecture 1.4 Rand + RandBetween
  • icon Lecture 1.5 IsText, Is Number, IsBlank, IsError

  • icon Lecture 1.1 Import Data with Filter Formulas in Excel 365
  • icon Lecture 1.2 Sort in Excel 365
  • icon Lecture 1.3 Unique in Excel 365
  • icon Lecture 1.4 Sequence in Excel 365
  • icon Lecture 1.5 Text Join & Text Split in Excel 365
  • icon Lecture 1.6 Dynamic Array Concept in Excel 365

Student Feedback

4.5

Total 258 Student Ratings

  • 5173 Rating
  • 450 Rating
  • 325 Rating
  • 210 Rating
  • 10 Rating
playicon

Course Pricing

₹ 4000

Course Features

  • Lectures 96
  • Assignment 96
  • Duration 44 Hrs
  • Skill level All levels
  • Language English/Hindi
  • Students 10000
  • Assessments Yes