Advance Excel Training

 

 

 

 

 

img

Advance Excel & VBA Training

img Various Professional Faculties ...
img

Enroll now

Fee-Rs 5000 / $ 70

About The Course

EBEES has been training advance excel in Delhi for last 11 years. We have been providing classroom & corporate training in advance excel. As a consultancy, EBEES has been creating world class content in advance excel. Our advance excel content is based on our working experience as a consultancy. As a consultancy, we use advance excel in our daily work and thus, we provide live projects to our students. None of the training organizations across the world, can provide content like EBEES for advance excel training.

Advance Excel

MODULE 1 – Advance Excel
    Important Advance Functions of Excel
  1. Writing Conditional Expression(using IF)
  2. Using Logical Function(AND, OR, NOT)
  3. Using Lookup & Reference Function(LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX)
  4. Date & Time Functions
  5. Text Functions
  6. Concept of Cell Referencing
  7. Relative
  8. Absolute
  9. Mixed
  10. Paste Special
  11. 15 Diff Operations
  12. Freeze Pane
  13. What if Analys is
  14. Scenario Manager
  15. Goal Seek
  16. Data Table
  17. Data Analysis
  18. Solver
  19. Correlation
  20. Histogram
  21. Pareto Analysis
  22. Pivot Table
  23. Pivot Table Creating Method
  24. Custom Calculated Columns
  25. Creating Pivot from external data source, i.e. SQL, ACCESS.
  26. Consolidating Data from external source or multiple files
  27. Filter & Summarization of Pivot Table
  28. Grouping & ungrouping in Pivot
  29. Dynamic Pivot Table
  30. Conditional Formatting
  31. Conditional formatting using formula & cell value
  32. Highlighting Duplicate
  33. Calculation based conditional formatting
  34. Data Validation
  35. Custom & Dynamic Validation
  36. Multilevel Validation
  37. Input Message
  38. Error Alert
  39. Filter
  40. Filter & Custom Filter
  41. Advance Filter (Multiple Criteria for Advance Filter)
  42. Sort
  43. Sorting
  44. Custom Sort
  45. Sort on Custom List
  46. Sort on Colour
  47. Name Manager
  48. Defining Static & Dynamic Name & its uses
  49. Slicer
  50. Sparkline
  51. Consolidate & Connection from Database (SQL & Access)
  52. Others Important topics
  53. Table Creation
  54. Cell Formatting
  55. Hyperlink for TOC
  56. Print Options
  57. Text to Columns
  58. Remove Duplicate
  59. Summarizing data using Group & Ungroup
  60. Subtotal
  61. Track Changes
  62. Sharing & Protecting a Sheet or Cell
  63. MODULE 2 - Excel Macro Programming using VBA
  64. Introduction to Visual Basic
  65. Object Orient Programming concepts and Illustration
  66. Excel Object Model
  67. VBA Data Types
  68. Operators
  69. Arithmetic Operators
  70. Comparison Operators
  71. Logical Operators
  72. Concatenation Operator
  73. Basic Excel Operations
  74. Dialogs in VBA screen
  75. Defining Constants
  76. Defining variables
  77. Defining Global variables
  78. Defining Static variables
  79. Working with Functions
  80. Creating Functions using Optional Arguments
  81. Creating Private Functions
  82. Creating Public Functions
  83. Working with Subroutines
  84. Creating Subroutine using Arguments
  85. Creating Subroutine using optional Arguments
  86. Creating Private Subroutines
  87. Creating Public Subroutines
  88. Handling errors
  89. Working with Message Box
  90. Decision Statements
  91. Looping Statements
  92. Working with User Forms
  93. Developing different Consolidation Tools using VBA programming
  94. Database Connectivity using VBA
  95. Introduction to SQL Server
  96. Making connections in MS Access & SQL Server through VBA
  97. Retrieving records from database
  98. Updating records to database
  99. Adding records to database
  100. Deleting records from database
  101. Creating Excel based application
  102. Creating Time saving tools
  103. Creating Plug-Ins

Course Title Instructor Duration
Advance Excel Various Professional Faculties 20 days
VBA & Macros Various Professional Faculties 20days

Featured

  • ...
  • ...

Sponsor Add

img