• Basic & Advance Excel

Basic & Advance Excel Course Content:

1.Excel Introduction:

Excel –  Home

Excel – Getting Started
Excel – Explore Window
Excel – Entering Values
Excel – Move Around
Excel – Save Workbook
Excel – Create Worksheet
Excel – Copy Worksheet
Excel – Delete Worksheet
Excel – Close Workbook
Excel – Open Workbook
Excel – Context Help
Excel – Office Button
Excel – Ribbon & Tabs
Excel – Features of Tab
Excel – Quick Access Toolbar
Excel – Mini Toolbar
Excel – Title, Help, Zoom, View

 

2.Excel Worksheet Editing

Excel – Insert Data
Excel – Select Data
Excel – Delete Data
Excel – Move Data
Excel – Rows & Columns
Excel – Copy & Paste
Excel – Find & Replace
Excel – Spell Check
Excel – Zoom In – Out
Excel – Special Symbols
Excel – Insert Comments
Excel – Add Text Box

 

3.Formatting Cells

Excel – Setting Cell Type
Excel – Setting Fonts
Excel – Text Decoration
Excel – Rotate Cells
Excel – Setting Colors
Excel – Text Alignments
Excel – Merge & Wrap
Excel – Borders & Shades
Excel – Apply Formatting

 

4.Formatting Worksheets

Excel – Sheet Options
Excel – Adjust Margins
Excel – Page Orientation
Excel – Header & Footer
Excel – Insert Page Breaks
Excel – Set Background
Excel – Freese Panes
Excel – Conditional Format

 

5.Excel Calculation

Excel – Addition
Excel – Sigma Addition
Excel – Substraction
Excel – Calculate Average
Excel – Sigma Average

 

6.Excel Fill Handle

Excel – Fill Handle
Excel – Fill Handle with Text
Excel – Text with Numbers
Excel – Fill Handle with Dates

 

7.Excel Formula

Excel – Create Formula
Excel – Copy Formula
Excel – Formula Reference
Excel – Using Functions
Excel – Built in Functions
Excel – Fill Handle in Formula
Excel – Relative Referencing
Excel – Absolute Referencing
Excel – Instruction for Typing
Excel – Quick Excel Functions

 

8.Excel IF

Excel – If Function
Excel – If with Calculations
Excel – COUNTIF
Excel – Advance If
Excel – SumIf

 

9.Excel Advance

Excel – Data Filtering
Excel – Data Sorting
Excel – Using Ranges
Excel – Data Validation
Excel – Using Styles
Excel – Using Themes
Excel – Using Templates
Excel – Using Macros
Excel – Adding Graphics
Excel – Cross Referencing
Excel – Printing Worksheets
Excel – Email Workbooks
Excel – Translate Worksheets
Excel – Workbook Security
Excel – Data Tables
Excel – Pivot Tables
Excel – Simple Charts
Excel – Keyboard Shortcuts
Excel – Find & Remove Duplicates
Excel – Create Dropdown List
Excel – VLookup
Excel – HLookup
Excel – Merge cells

10.Excel Data Visualization Using Charts

11.Excel Gantt Chart