- Starting Excel
- Using the Ribbon as the Excel User Interface
- Navigating within the Worksheet
- Selecting a Cell or Range of Cells
- Entering Data
- Entering Cell Contents
- Cutting, Copying, and Pasting Cell Values
- Copy and Paste Special
- Saving your Workbook
- Inserting, Moving & Deleting Cells
- Managing Columns and Rows
- Hide and Unhide Rows/Columns
- Changing Column Width & Row Height
- Format Worksheet Tabs
- Insert and Delete Worksheet
- Move and Copy Worksheet
- Hide & Unhide Worksheet
- Formatting the Cell
- Number and Date Formatting
- Finding and Replacing Text
- Working with Styles
- Excel Arithmetic Operators & Order of Operations
- Using AutoFill Options
- Using Commonly Used Functions
- Using SUMIF() and COUNTIF():
- Adding and Counting only the Cells you Specify
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Summarizing Data Visually Using Charts
- Customizing Chart Data
- Format Chart Legend and Titles
- Change the Chart Body
- Saving the Chart as a Template
- Creating a Pie Chart
- Adding Pictures into a Worksheet
- Customizing Pictures and Objects
- Adding Drawing Objects into a Worksheet
- Adding SmartArt into a Worksheet
- Adding Clip Art into a Worksheet
- Managing Large Workbooks
- Printing Worksheets
- Setting Page Setup Options
- Setting Page Breaks
- Customizing Excel to the Way You Work
- Creating Hyperlinks
- Working with Workbook Themes
- Working with Templates
- Various Methods and Uses of Advance Excel Formulas
- VLOOKUP, HLOOKUP
- SUMIF, SUMIFS, SUMPRODUCT, DSUM
- COUNTIF, COUNTIFS, IF
- GET PIVOT DATA
- DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH ETC
- When should use the "IF" Conditions?
- Creation of Multiple IF Conditions in One Cell
- Use the IF Conditions with the Other Advance Functions
- How to use nested IF statements in Excel with AND, OR Functions
/ul>
- Various Methods of Filter and Advance Filter options
- Creating and Updating Subtotals
- Various Methods of Text to Column options
- Uses of Data Grouping and Consolidation options
- Uses of Goal Seek and Scenarios Manager
- Various Method of Sorting Data
- Creating, Formatting and Modifying Chart
- Data Validation, Creating drop down lists using different data sources
- Linking Workbooks and Uses of Edit Link options
- Excel Options, Customizing the Quick Access Tool Bar
- Mixing Function to get Various MIS Outputs
- Creating Data Table
- Advance Data Validation
- Using conditional formatting with Formulas and Function
- Using Name Manager
- Array Formulas
