About Excel & Microsoft, Uses of Excel, Excel software, Title Bar, Menu Bar, Standard Toolbar, Formatting Toolbar, the Ribbon, File Tab and Backstage View, Formula Bar, Workbook Window, Status Bar, Task Pane, Workbook & sheets – Creating excel data and Filtering excel data

Columns & Rows: Selecting Columns & Rows, Changing Column Width & Row Height, Autofitting Columns & Rows, Hiding/Unhiding Columns & Rows, Inserting & Deleting Columns & Rows, Cell, Address of a cell, Components of a cell ᎓ Format, value, formula, Use of paste and paste special. Using Ranges, Selecting Ranges, Entering Information into a Range

Using Formulas, Formula Functions ᎓ Sum, Average, if, Count, max, min, Proper, Upper, Lower, Using AutoSum, Advance Formulas – Concatenate, Vlookup, Hlookup, Match, Countif, Text, Trim. Spreadsheet Charts: Creating Charts, Different types of chart, Formatting Chart Objects, Changing the Chart Type, Showing and Hiding the Legend, Showing and Hiding the Data Table

Data Analysis: Sorting, Filter, Text to Column, Data Validation. Making Macros: Recording Macros, Running Macros, Deleting Macros. Mathematical functions – summarizing data – pivot table: Creating PivotTables, Manipulating a PivotTable, Using the PivotTable Toolbar, Changing Data Field, Properties, Displaying a PivotChart, Setting PivotTable Options, Adding Subtotals to PivotTables – formula auditing – what-if analysis – AI-Enhanced Data Analytics in Excel

Introduction to Statistics (Descriptive and Inferential). Descriptive Statistics: Tabular & Graphical Presentation. Descriptive Statistics: Numerical Measures (Averages and Variances). Introduction to Probability: Discrete Probability Distributions, Continuous Probability Distributions. Sampling, Interval Estimation, Hypothesis Testing, ANOVA, Simple Linear Regression.