|
Basics of Excel
Data Formatting in Excel like colors, fonts, Bullets etc
Basic Sorting and Filtering
Basic Formulae like SUM,AVERAGE,COUNT,MAX,MIN etc
Spreadsheet Basics
Creating, Editing, saving and Printing spreadsheets
Getting Advance in excel
Sorting Data by values, colors , etc
Filtering by numbers , text , values , logical functions ,colors
Using Filters to Sort Data
Using Auto filter
Creating a custom AutoFilter
Advance Filtering Options
Custom and Conditional Formats
Creating a custom format
Create a custom number format
Conditional Formatting
Creating Conditional Formatting
Editing Conditional Formatting
Adding Conditional Formatting
Deleting Conditional Formatting from the selected range
Searching with Conditional Formatting
Data Validation
Specifying a valid range of value of a cell
Specifying a valid value for a cell
Specifying custom validation based on formula for a cell
Working with Range Names
Using Range names
Creating range names
Using range names in formulas
Creating range names from headings
Deleting range names
Using Formulas and Functions
Text Function
Logical Functions
Date and Time Functions
Information Function
Financial Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and reference functions
Absolute and Relative cell reference
Relative cell reference
Absolute cell reference
Excel Auditing Tool
Trace precedents
Remove arrows
Getting data
Creating subtotal
Using Automatically Outline
Grouping Data Manually
Working with Charts
Creating a chart
Formatting a chart
Adding Labels
Changing the chart type, Data source
Working with Pivot Tables
Creating Pivot tables
Adding Pivot table Report Fields
Refreshing Pivot table Reports
Changing the summary functions
Creating report filter page
Worksheet Protection
Protecting your work sheet
Protecting range with password
Protecting your Workbook and Excel Files
Using Shared Work Books
Sharing a workbook
Opening and editing a shared workbook
Tracking changes
Resolving conflict in a shared workbook
|
Multiple workbooks
Linking workbooks
Editing the Link
Consolidating the workbooks
What-IF Analysis
Goal Seek
Data Tables
Scenario Manager
Working with Range Names
Using Range names
Creating range names
Using range names in formulas
Creating range names from headings
Deleting range names
Using Formulas and Functions
Text Function
Logical Functions
Date and Time Functions
Information Function
Financial Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and reference functions
Absolute and Relative cell reference
Relative cell reference
Absolute cell reference
Excel Auditing Tool
Trace precedents
Remove arrows
Getting data
Creating subtotal
Using Automatically Outline
Grouping Data Manually
Working with Macros
Display the developer Tab
Changing Macro security Settings
Recording and running a Macro
Playing and Deleting a Macro
Create calculator with Macro
Create Data Entry Form
Adding a Macro to the Quick Access Toolbar
Editing a Macro’s Visual Basic Code
Inserting Copied Code in a Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If-Else Statement
Using Looping
Tables
Student Table
Product Table
Employee Table
Loan Table
Closing stock Table
Depreciation
Customizing Excel
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format
Dynamic Attendance Sheet
Calculate Present
Calculate Absent
Calculate Half day
Pay slip
|