Course Duration in Hours
30
30
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
1) Working Professionals (Executive, Managers, Business Leaders)
2) Students (Any Graduate, Post Graduates, PhD etc) who are preparing for jobs in MIS, Reporting, Dashboarding, Analytics.
3) Self employed who needs to work on excel on regular basis
4) Anyone who want to upskill and be job ready
Introtallent Pvt Ltd., Indira Nagar (Bangalore),Bangalore,IN