- 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
Similar Courses
- Basic & Advance Excel
- Data Science
- ArcGIS
- React Js
- Ethical Hacking(Cybersecurity)
- SW ROAD V2 TRAINING
- Basics of Programming
- Digital Marketing
- AutoCad
- CCNA Networking
- DataBase (SQL/NoSQL)
- Quality Assurance
- Graphics Design
- Web Design
- Javascript
- MERN Stack
- MEAN Stack
- C++ Programming
- C Programming
- ASP C# .Net + MSSQL
- PHP + Laravel +MySQL
- Android (Mobile App Development)
- Python + Artificial Intelligence
- Python + Django
- Java + Spring Training
- PHP with Laravel
- CodeIgniter Training
- Zend Framework Training
- Web Development with Laravel Training
- Advanced PHP Training
- Yii PHP Training
- PHP Training
- Civil Eng.Courses
- Designing Courses
- IT Courses