Microsoft Excel
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.
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.
14 Module
42 Live class
96 Assignment
14 Test Project Lecture 1.1 About excel (Intro) Lecture 1.2 Setting up column and row / Dragging cells Lecture 1.3 Basic mathematical calculations Lecture 1.4 Paste special and format painter Lecture 1.5 Custom formatting and alignment Lecture 1.6 All numbers formatting Lecture 1.7 Conditional formatting Lecture 1.8 Sorting / Custom sorting Lecture 1.9 Data filtering (Basic / Advance) Lecture 1.1 Pivot Intro Lecture 1.2 Use of Rows fields, Column fields & Report Filters Lecture 1.3 Use of Value Field Setting in Pivot Lecture 1.4 Arranging Date Field in Pivot Lecture 1.5 Grouping in Pivot Lecture 1.6 Report Layouts in Pivot Lecture 1.7 Making Pivot Range Dynamic Lecture 1.8 Calculated Fields in Pivot Lecture 1.1 Use of Percent of Grand Total Lecture 1.2 Use of Row & Column Total Lecture 1.3 Difference from & Percent Difference From Lecture 1.4 Use of Percent of Lecture 1.5 Ranking in Pivot Lecture 1.6 Running Total ( Cumulative Frequency) Lecture 1.1 Use of Slicer in Pivot Lecture 1.2 Pivot Connections with Slicer Lecture 1.3 Use of Timeline Lecture 1.4 Making Pivot Charts Lecture 1.5 Use of Legends in Pivot Charts Lecture 1.6 Dashboard Using Slicer and Pivot Charts Lecture 1.1 Column, Line, Pie, Bar, Area, Scatter Charts Lecture 1.2 Different Methods of Making Charts Lecture 1.3 Difference between Clustered & Staked Charts Lecture 1.4 Charts Elements Setting Lecture 1.5 Linear & Linear Forecast Trend Lines Lecture 1.6 Overview of Deep Settings Lecture 1.1 Hyperlinking Websites, E-mail, and Files Lecture 1.2 Hyperlinking Sheet Cells Lecture 1.3 Header And Footer Lecture 1.4 Page Setup (Margins, Size, Printing Area) Lecture 1.5 Print Titles (Top & Left) Lecture 1.6 Content Printing Solutions Lecture 1.1 Formulas Intro (Concept & Operators) Lecture 1.2 If Function with Logical Arguments Lecture 1.3 Nesting with if Lecture 1.4 And + Or Formulas in Excel Lecture 1.5 Nesting with If + And + Or Lecture 1.6 If Error Implementation Lecture 1.1 Concatenate Lecture 1.2 Upper, Lower, Proper & Trim Lecture 1.3 Len & Rept Lecture 1.4 Find & Search Lecture 1.5 Replace & Substitute Lecture 1.6 All above formulas and its Implementation on Real Corporate Data. Lecture 1.1 Date & Time Formula Lecture 1.2 DateValue & TimeValue Lecture 1.3 Day, Month, Year Formulas Lecture 1.4 Edate, EOMonth Lecture 1.5 Networkdays & Networkdays.INTL Lecture 1.6 All above formulas and its Implementation on Real Corporate Data. Lecture 1.1 Relative & Absolute References Lecture 1.2 Vlookup Intro (Concept & Arguments) Lecture 1.3 Use of Vlookup with Different Scenarios Lecture 1.4 Vlookup With Match Lecture 1.5 Approximate Match & Exact Match in Vlookup Lecture 1.6 Vlookup on Large Corporate Data Lecture 1.7 Hlookup Formula Lecture 1.8 Index & Match Formulas Lecture 1.9 All above formulas and its Implementation on Real Corporate Data. Lecture 1.1 Sumif & Countif Lecture 1.2Sumifs & Countifs Lecture 1.3Averageif & AverageIfs Lecture 1.4 Count Blank & CountA Lecture 1.5 Dynamic Data Update With Above Functions Lecture 1.6 All above formulas and its Implementation on Real Corporate Data. Lecture 1.1 Name manager & Auditing formals Lecture 1.2 Getting external data (Access, SQL) Lecture 1.3 Advance filter Lecture 1.4 Text to column wizard Lecture 1.5 Remove duplicates Lecture 1.6 Setting up data validations (with creating drop down list) Lecture 1.7Consolidation & Scenario manager Lecture 1.8 Goal seek and data table Lecture 1.9 Recording & Assign Macros Lecture 1.10 Advance conditional formatting Lecture 1.11 Course Revision & Doubt Clearing Session Lecture 1.1 Abs Formulas Lecture 1.2 Round / RoundUp /RoudnDown Lecture 1.3 Small & Large Lecture 1.4 Rand + RandBetween Lecture 1.5 IsText, Is Number, IsBlank, IsError Lecture 1.1 Import Data with Filter Formulas in Excel 365 Lecture 1.2 Sort in Excel 365 Lecture 1.3 Unique in Excel 365 Lecture 1.4 Sequence in Excel 365 Lecture 1.5 Text Join & Text Split in Excel 365 Lecture 1.6 Dynamic Array Concept in Excel 365Course Pricing
₹ 4000
Course Features
