All the basic and advance topics of excel 2016 will be cover. I preferred online mode and student home for teaching.Student can pay fee in installment as per their convenience. Please contact me for more details.  

I can assure you no one will cover my curriculum topics in this rate and with this flexibility.

Advance MS Excel
Total Duration â?? 15 Hours Total Class: - 10
1. Type of Errors in Excel
2. Type of Excel Files
3. 150+ Excel Short Cuts
4. Inserting Comments, Hyperlink, Shapes, Icons, SmartArt, AutoSum, Clear
5. Protect Sheet & Workbook, Sharing Workbook
6. Track Changes, Allow User to Edit Ranges, Freeze Panes
7. GoTo Option (Amazing Things You Can do)
8. Paste Special
a. Mathematical Operators
b. Values, Comments, Format, Blank
c. Transpose, Linking the Data
9. Conditional Formatting
a. Built in Conditional Formatting
b. Using Conditional Formatting with Multiple Cell Rules
c. Using Color Scales and Icon Sets in Conditional Formatting
d. Creating New Rules and Managing Existing Rules
10. Auto Fill & Flash Fill
a. How to Fill Date
b. How to Fill Number Series
c. How to Fill Alphabet Series
d. How to Fill Formula & Functions Automatically
11. Advanced Sorting
a. Sorting Data by Values, Cell Color, Font Color, Cell Icon
b. Sorting the Data with Multiple Level
12. Filter the Data
a. Advance Filter
b. Filter the Data with Multiple Condition
c. Filter the Data using ? and * Operators
d. How to Copy Filtered Data on a New Sheet
13. Naming of Range
a. Benefits of Defining Range
b. How to Define Names of a Range
c. How to Use Defined Names in Formulaâ??s
d. How to Define Range in Existed Data
14. Data Validation
a. Set Data Validation in New Sheet
b. Validate Existed Data
c. Mark Invalid Data
d. Creating Drop Down List
e. Creating Dynamic Drop Down List
15. Consolidate
a. Consolidating the Data from Different Sheets
b. Consolidate by Value
c. Consolidate by Vales
16. Table
a. Benefits of Creating Table
b. Creating Table
c. Creating Relation Between Multiple Tables
17. Slicer
a. Insert Slicer
b. Linking Slicer with Multiple Pivot or Tables

18. Difference Between Functions & Formulaâ??s
19. Lookup Functions
a. Vlookup, Hlookup, Index, Match, Offset, Indirect, Choose, Column, Columns, Hyperlink,
Address, Row, Rows, Transpose
20. Text or String Functions
a. Char, Concatenate, Dollar, Exact, Find, Left, Right, Mid, Upper, Lower, Proper, Replace,
Search, Substitute, TextJoin, Text, Trim, Rept
21. Date & Time Functions
a. Date, DatedIf, DateValue, Days, Days360, EDate, EoMonth, NetworkDays, Now, Today,
Weekday, Weeknum, Workday, Yearfrac
22. Math Functions
a. ABS, Aggregate, Even, Fact, Mod, Odd, ISEven, ISODD, Power, Product, Randbetween,
Round, Roundown, Roundup, SQRT, Subtotal, Sumif, Sumifs,
23. Statistical Functions
a. Average, Averageif, Averageifs, Count, CountA, CountBlank, Countif, Countifs, Frequency,
Large, Max, Maxifs, Median, Min, MINIFS, Mode, Rank, Small, STDEV
24. Logical Functions
a. AND, OR, NOT, IF, Nested IF, IFS, IFERROR, IFNA, Switch, XOR,
25. Information Functions
a. Cell, Info, ISBLANK, ISERROR, ISNONTEXT, ISNUMBER, ISTEXT
26. Financial & Engineering Functions
a. ACCRINT, ACCRINTM, DB, DDB, FV, IPMT, NPER, NPV, ISPMT, PMT, RATE
b. BIN2DEC, BIN2HEX, BIN2OCT
27. Database Functions
a. DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, Array Formula
28. Pivot Table
a. Creating Pivot
b. Classic Pivot
c. Creating Single Pivot from Multiple Sheets
d. Creating Single Pivot from Multiple Tables
e. Linking Multiple Pivot Tables
f. Manage Multiple Pivot Tables
g. Working with Timelines
29. Chart & Graphs
a. Column, Line, Pie, Bar, Area, Treemap, Sunburst, Histogram, Waterfall, Funnel, XY
Scatter, Bubble, Stock, Surface, Radar, Box & Whisker, Combo, Doughnut, Map, Process,
Pyramid (Total 21 Graphs)
b. Use & Analysis from Every Chart
c. Spark Line Chart
d. Modifying All Chart Elements
30. Formula Auditing
a. Trace Precedents & Dependents
b. Evaluate Formula
c. Error Checking
31. Outline
a. Group the Data
b. Ungroup the Data
c. Subtotal
32. Analyze
a. Data Analysis
b. Solver

33. Amazing Excel Features
a. What if Analysis
i. Goal Seek
ii. Data Table
iii. Scenario Manager
iv. Removing Duplicate Values with 3 Methods
b. Forecast Sheet
c. How to Import Data from Text file, Web and Other Sources.
d. How to Manage Existed Connection
e. Power Query
34. Excel Macros
a. Recording Macro
b. Use of Recorded Macro
c. Introduction of VBA Editor
d. Writing a Simple Code
35. Dashboard
a. Creating Simple Dashboard
b. Creating Dynamic Dashboard