Advanced Excel Training Course is delivered in classroom batches held on weekdays and weekends.
Audience:
Course Objectives
Course Outline:
Introduction
- Freeze panes
- Charts (Bar, Column, Line, Pie, Area, 3d
- Auto Sum on the Task-bar
- Usage of Top Ribbon Menu
Using Sort, Filter, Text-to-Column
- Sorting (number. alphabets, color, date, custom)
- Filter, Advanced Filter
- Text to column: Importing .txt files / CSV into excel (Bhav Copy)
- What-If Scenarios
- Solver
- Grouping and Sub-grouping
Creating Graphs & Chart
Formula Writing & Fixing Errors
- Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
- Lookup: Vlookup, Hlookup
- Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
- IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
- Case, Position, Search, Trim, Right, Left, Concatenate
- Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day
- Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power
Working with Data
- Data Validation (List, Error Message)
- Identifying Invalid Data
- Dependent Data List
- Pivot Table (Pivot Chart)
Review and Security
- Password Protection
- Cells Lock
- Making excel as a form
- Track Changes
Using Macros
- Recording macros
- Running macros
Certification Details®
| Course Name |
Exam |
No of (days) |
| Oracle SQL |
SQL Certification Exam 12c or 11g |
1 |
| Total |
1 |
| Course/Exam Name |
Duration |
Fees |
| SQL Course |
24 hours or 12 classes |
Rs. 5,900 |
| SQL Certification Exam |
-- |
Rs.10,900 |
| Total |
Rs. 16,800 |
+91-9051092035
+91-8420594969(24x7)
palium.skills@gmail.com
