Все публикации

Format Table in Excel (Applications, Slicers, Dynamic Chart, Computing Value, Table Style)

Statistical Measures in Excel (Central Tendency in Data Distribution, Measures, Skewness, Kurtosis)

Frequency in Excel (Frequency using COUNTIF, Applications of Frequency, Graphical Representation)

VLOOKUP and HLOOKUP (Applications of VLOOKUP, Approx Match VLOOKUP & HLOOKUP, MATCH, INDEX Examples)

Logical and Conditional Functions in Excel (IF, AND, OR, IFS, SUMIF, COUNTIF, AVERAGEIF, MINIFS)

Logical Operators I (XOR operators, IF function, applications of IF statements, logical functions

GRAPHS AND CHARTS II (Stacked chart, Stock chart, Doughnut chart, Bubble chart, Radar chart)

Mixed Cell References in Excel(Fixed Column & fixed row references, Compute running total)

Cell Styles & Conditional Formatting in excel(Cell value,Date value,Data bars,Color scale,Icon set)

Excel FUNCTIONS(SUM, COUNT, AVERAGE, SUMPRODUCT, AUTO FUNCTIONS, AUTO FILL and FLASH FILL)

Sorting & Filtering in Excel(Sorting, Filtering, Inbuilt Rules For Filtering Text and Date)

GRAPHS and CHARTS I (Pie Chart, Column Chart, Bar Chart, Line Chart, Scatter plot and Area Chart)

Cell Referencing in Excel(Behavior of relative- absolute cell references, Arithmetic operator)

Excel Formatting(Format fonts, cell alignment, Wrap & Merge cells, Borders, Freeze panes)

Excel Environment(Create, save, name workbooks, Keyboard shortcuts, Navigation, Selection)

inbuilt rules for date filter 720p

How to select the Columns and Rows in Excel.

DAPT WEBINAR

DAPT WEBINAR

KnowledgeVarsity Live Stream

4 Perpetuity

How to create Pivot Table on Sales Data (Part 2)

2 PV Calculation with Timeline