Advanced Excel course Beginner level by Introtallent Pvt Ltd.

Course Content
1) BASICS: Understanding Workbook, Worksheet, Menu, and Ribbon, Select Range, Copy, Paste, and Move data. Formatting Cells, Range, and Worksheet. Insert and Delete Worksheets, Hide-Unhide Worksheets. Cell References: Relative Reference, Absolute Reference, and Mixed Reference, Working with Formula, Shortcut keys.
2) FUNCTION :
Date & Time: DATE, DATEVALUE, DAYS, DAYS360, MINUTE,HOUR, MONTH, NETWORKDAYS, NOW, TIMEVALUE, TODAY, WEEKDAY, TIME, YEAR Math & Trig: AGGREGATE, CEILING, COMBINE, EVEN, EXP, FACT, FLOOR, INT, MOD, ODD, POWER, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDUP, ROUNDDOWN, SQRT, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, TRUNC Statistical: AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS, CORREL, COUNT, COUNTA, COUNTIF, COUNTBLANK, COUNTIFS, FREQUENCY, LARGE, MAX, MAXA, MAXIFS, MEDIAN, MIN, MINA, MINIFS, MODE, PERCENTILE, QUARTILE, RANK, STDEV Lookup & Reference: LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX, FORMULATEXT, TRANSPOSE Text: CLEAN, CONCAT, EXACT, FIND, LEFT, RIGHT, LEN, LOWER, UPPER, MID, PROPER, REPLACE, REPEAT, RIGHT, SEARCH, SUBSTITUTE, TEXT, TRIM Logical: AND, OR, NOT, IF, IFERROR, IFNA Information: ISERROR, ISBLANK, ISNA, ISNUMBER, ISTEXT, ISEVEN, ISODD
3) Visual Representation of Data using Charts: Column chart, Line chart, Pie chart, Bar chart, Area chart, Scatter (X Y) plot, Radar chart, Histogram, Waterfall chart, Funnel chart, Combo chart
4) Working with Data/Table: Freezing Pane, Applying Filters, Sorting data, Grouping Data (Rows and Columns), Ungroup Data, Format Painter, Alignment, Wrap Text, Merge & Center, Conditional Formatting, Format as Table, Text to Column, Remove Duplicates, Data Validation
5) Data Analysis 1: What-if Analysis, Scenario Manager, Goal Seek, Data Table
6) Data Analysis 2: Why Pivot Table?, Working with Pivot Table, Sorting & Filtering in Pivot Table, Calculated Field, Pivot Charts, Slicers
7) Other Features & Functionalities: GoTo, Shapes, SmartArt, Sparklines, Define Names, Name Manager, Calculation Options, Get Data, Subtotal, Comments, Protect Sheet, Protect Workbook, Workbook Views, Show/Hide (Ruler, Formula-bar, Gridlines, Headings)
8) Introduction to Macros (VBA): Record Macro, View Macro, Edit Macro, Assign shortcut keys

Privacy Policy Terms and Conditions Refund Policy