Advance Excel

Advance Excel

Training Mode Regular Fasttrack Crash Brochure
Classroom | Online 1 Month 15 Days 10 Days Download


  • 10th, 12th or Equivalent
  • BCA/MCA, B.Tech, M.Tech, (IT),
  • Diploma Candidates


  • Opening Excel Processing Package
  • Title Bar , Menu Bar ,Work Sheet
  • Open New File , Open Save File , Save As ,Print, Prepare ,Send


  • Clipboard :- Cut, Copy ,Paste And Format Painter
  • Font:- Font Family, Font Size, Bold, Italic, Underline, Border, Text Highlight, Font Color
  • Alignment :- Align (Top, Middle ,Bottom), Align Text ( Right, Left, Center), Decrease And Increase Indent, Wrap Text, Merge & Center
  • Number :- Number Format, Accounting, Number Format, Percent Style, Comma Style, Increase Decimal, Decrease Decimal
  • Style & Editing:- Conditional Formatting, Format as Table, Cell Style
  • Cell:- Insert Cell, Delete Cell, Format
  • Editing :- AutoSum, Fill, Clear, Short & Filter, Find & Select


  • Table:- Pivot Table, Table
  • Illustration :-Picture, Clip Art, Shapes, Smart Art
  • Chart :- Column, Line, Pie, Bar, Area, Scatter, Other
  • Links :- Hyperlink
  • Text :Text Box, Header & Footer, Word Art, Signature Line, Symbol

Page Layout

  • Themes :-Themes, Colors, Font, Effects
  • Page Setup :-Margins, Orientation, Size, Print Area, Breaks, Background, Print Title
  • Scale to Fit :- Width, Height, Scale
  • Sheet Options :- Gridlines, Heading
  • Arrange :- Bring to front, Send to Back, Selection Pane, Align, Group, Rotate


  • Function Library :- Insert Function, AutoSum, Recently Used
  • Sheet :- Mark Sheet, Attendance Sheet, Sale &Purchase Sheet, Loss & Profit Sheet, Stock Inventory, Salary Sheet, Hospital Sheet, Bank Sheet
  • Defined Name :-Defined Name, Use In Formula
  • Formula Auditing :- Trace Precedence & Dependence, Remove Arrow, Evaluate Formula, Watch Window
  • Calculation :- Calculation Options, Calculate Now & Sheet


  • Get External Data :- From Access, From Web, From Text, From Other Sources, Exiting Connections
  • Connections :- Refresh All Connection Properties, Edit Links
  • Short & Filter :- Filter, Clear, Reapply, Advance Filter
  • Data Tool :- Text To Columns, Remove Duplicate, Data Validation, Consolidate, What-If Analysis
  • Outline :- Group, Ungroup, Subtotal, Show & Hide Details


  • Proofing :- Spelling & Grammar, Research, Thesaurus, Translate, Word Count
  • Comments :- New Comment, Delete
  • Changes :- Protect Sheet , Protect Workbook, Share Workbook, Protect and share Workbook, Allow Users to Edit Ranges, Track Changes


  • Workbook Views :- Normal, Page Layout, Show / Hide
  • Zoom :- Zoom, Zoom to Selection
  • Window :- New Window, Arrange All, Freeze Panes, Split, Save Workspace, Switch Window
  • Macros

Advance Formulas

  • Text Functions :-
  1. Char
  2. Clean
  3. Code
  4. Concatenate
  5. Dollar
  6. Exact
  7. Find
  8. Fixed
  9. Left
  10. Len
  11. Lower
  12. Mid
  13. Proper
  14. Replace
  15. Rept
  16. Search
  17. Text
  18. Trim
  19. Upper
  • Mathematical Function :-
  1. Abs
  2. Ceiling
  3. Even
  4. Fact
  5. Int
  6. Log
  7. Mdeterm
  8. Mod
  9. Odd
  10. Power
  11. Product
  12. Roman
  13. Round
  14. Rounddown
  15. Roundup
  16. Sqrt
  17. Sum
  18. Sumif
  19. Sumifs
  20. Sumsq
  • Statistical Functions :-
  1. Average
  2. Averageif
  3. Averageifs
  4. Large
  5. Max
  6. Median
  7. Min
  8. Small
  9. Count
  10. Counta,
  11. Countblank
  12. Countif
  13. Countifs
  • Date & Time Functions :-
  1. Date
  2. Datedif
  3. Day
  4. Hour
  5. Minute
  6. Month
  7. Now
  8. Second
  9. Time
  10. Year
  • Lookup Function :-
  1. Lookup
  2. Hlookup
  3. Vlookup
  4. Column
  5. Row
  6. Transpose
  7. Hyperlink
  8. Choose

Career Options:

  • Excel Expert
  • Data Entry Expert
  • Front End Executive



Our team welcome, all our trainees to ask any doubts related to their course after training, if they face any doubt or got stuck in any topic or if they feel gap in their knowledge , they can contact to our counsellor for doubt session arrangement.
If you are facing any type of problem with class, we insure you to give refund ! We always takes a feedback with our trainees after classes. Further they don't love our classes after 3 or 5 , we will try to resolve it other wise we refund less amount.
Our team always committed to your success, so our institute offers students to pay their fees installment in monthly basis, rather than full amount*.
Equipped with more than 5+ years of industry experience our instructors will assure a successful leap in your knowledge, improvement and preparation. Know about our Instructors.
Our team always committed to your success, so our institute offers students to pay their fees installment in monthly basis, rather than full amount*.
Students at Next-G Education can do maximum practice in lab as they wish with proper internet connection. Our Lab Instructors helps during practice. Students can frequently ask any doubt if they are facing issue during practice session.
At Next-G Education,we make sure for PG or Lodge or Room in very low cost. We always care our students which are coming from different location either they are from India or Outside India. So if your are interested to join our course and looking for Room or PG we definitely provide you in affordable cost. You can also share your arrival details with us in advance for proper adjustment ion few days.
We offers assured job placement to our candidates opting for our all courses. As Next-G Education, associated partner of Web services, Info web tech, Global Sites Solution. You are invited to do paid internship with us after completion of course or our associated placement departments team provides job for you...
Are you interested to book free demo classes or looking for free counselling give us call on 9911012873 or mail us on : [email protected] or [email protected].