Excel for Data Analysis

Workbooks and Worksheets, Moving Around a Worksheet, Ribbon tabs, Using Shortcut Menus, cell formatting options , Modifying Cell Contents. Some handy data entry techniques, Number Formatting. Insert picture, chart, hyperlink, header footer, symbols, etc. Printing your worksheet and page setup.

Creating a Table, Adding, Deleting new rows or columns, Moving a Table, Removing duplicate rows from a table. Sorting and filtering a table, auto filter, advanced filter ,formatting of table.

series, auto fill series, ,Cell referencing (Relative, Absolute, Mixed).

Data from other sources: Importing external data from different database files. Creating PDF files. Creating Custom Views of your Worksheet.

 Functions and its parts, Some useful Functions in spreadsheet (SUM, COUNT, MAX, MIN, IF), Mathematical Functions (Ceiling, Floor, Trunc, Mid, abs,fact, int,log, mod, power, round, exp), logical functions(IF,AND,OR).Date & Time functions(now,date,time,time value)

Financial Functions (PV, NPV, IPR, Rate, FV, PMT, NPER),  V look up, H-look up, What if analysis: Scenario, Goal seek ,Sub-total, group, ungroup, Pivot Table ,Macros, Protection.

 line graph, bar graph, pie chart, histogram, scatter plot. Descriptive Statistics (mean, median, mode, standard deviation, sample variance, Range).