TECHGENX

Leading to the Future Digital World

Apply Online
Download:Course Content

Advance Excel + Access +VBA+ Excel

 

Please Note: All below course content will be covered in practical scenarios and regular assignments will be shared. All sessions will be recorded and shared with student for future reference (free of cost). Along with below course.

Section 1: MS Excel

  1. Excel structure
  2. Cell properties
  3. Autofill value and text
  4. Autofill date
  5. Autofill Adv tools
  6. Cell reference
  7. Math Function in Excel
  8. Operators based equation in Excel
  9. Print related options in Excel Part 1
  10. Print related options in Excel Part 2
  11. Text Function - Upper, Lower, Proper, Trim
  12. Text Function - Right, Left
  13. Text Function - Find and task
  14. Text Function - Solution and Nested Left
  15. Text Function - Find and Left Nesting
  16. Text Function - MID
  17. Text Function - Mid task and solution
  18. Text Function - Concatenate
  19. Text Function - Concatenate task and solution
  20. Text Function - Replace
  21. Text Function - Replace task and Solution
  22. Text Function - Substitute
  23. Text Function - Len, Rept, Exact, search
  24. Text to column
  25. Workbook protect
  26. Protect sheet
  27. Hide Formulas and unlocked Cell
  28. Protect File with password
  29. If Function - Logical Test
  30. If Function - with Equation and task
  31. If Function - Nested If
  32. If Function - advance
  33. If Function - advance – 2
  34. AND , OR Function
  35. AND, OR, IF Nested
  36. AND, OR Advance
  37. Pivot Table - Intro
  38. Pivot Table - Manage Field Area
  39. Pivot Table - Value Field, Report and more
  40. Pivot Table - Slicer and Duplicate Pivot
  41. Pivot Table - Group to mange date and values
  42. Pivot Table - Insert Calculated Field
  43. Goal seek
  44. Scenario manager
  45. PMT function - EMI calculator
  46. Data table - Create Loan Table
  47. Share book
  48. Chart Preperation
  49. Chart Preperation - Advance
  50. Chart Preperation - Customize
  51. Conditional Formatting
  52. Conditional Formatting - Types of Rules
  53. Conditional Formatting - Apply
  54. Conditional Formatting - Create New Rules
  55. Conditional Formatting - Manage Rules
  56. Data Validation
  57. Data Validation - Input message and Error Alert
  58. Advance Math Function
  59. Advance Math Function 2
  60. Using of Wild Card in Math Function
  61. Vlookup Function
  62. Vlookup with Iferror
  63. Vlookup Nesting with If
  64. Hlookup
  65. Match Function
  66. Index and match nested
  67. Vlookup array
  68. Vlookup column func trick
  69. Vlookup TRUE
  70. Advance VLOOKUP
  71. Macro Recording part 1
  72. Macro Recording part 2
  73. Macro Recording part 3
  74. Types of ways to run macros

Section 2: MS Access and SQL

  1. Access Intro
  2. Create table in MS Access
  3. How to Import and Export in Access
  4. Create form from table
  5. Create Blank Form in Access
  6. Creating Report in Access
  7. Query in access
  8. SQL Queries Part 1
  9. SQL Queries part 2
  10. Section 3: Excel VBA - Macro
  11. Introduction to Macro
  12. Start Macro Programming
  13. Macro Task Basic
  14. Methods to Refer Range
  15. Selection of multiple cell
  16. Formatting through VBA
  17. End Command in VBA
  18. Offset in VBA
  19. Task on Data Entry Automate
  20. Solution for the task
  21. Methods to refer to sheets
  22. Methods related to sheets and its properties
  23. Sheet related task
  24. Sheet Related Task Solution
  25. Methods to Refer to Workbooks
  26. Methods related to workbook
  27. Workbook related project
  28. Declared Variable
  29. Data Types in Variable
  30. Object variable related project
  31. Solution for the task - Object Variable
  32. Variable Project
  33. AND OR in VBA
  34. Project related to IF
  35. Solution of IF task
  36. Select Case
  37. Select Case 2nd Scenario
  38. Select Case 3rd Scenario
  39. Understanding Loop
  40. Loop Practical example
  41. Loop Related Task Solution
  42. Do While Loop
  43. For Loopcounter
  44. For Loopcounter Step importance
  45. For Loopcounter Step Example 2
  46. For Each Loop
  47. For Each Example
  48. For Each Task Solution
  49. Loop Related Task
  50. Loop Solution and Futher Task
  51. Loop Related Project
  52. How to create Events
  53. Events Example and task
  54. Event Task Solution
  55. Sheet Specific Events
  56. Create Function in VBA
  57. Function Related Task
  58. Function Related task Solution
  59. Create Optional Parameter in Function
  60. VBA to control Outlook for mail
  61. Outlook Related Project
  62. Create Userform
  63. Create Pivot Table with VBA
  64. File System Object in VBA
  65. File in FSO
  66. FSO Practical Example
  67. Late Binding Technique in Macro
apply now

Students Testimonials

  • Seeing the demand of Python in programming, I decided to enroll for weekend classes of Python then after joining, Ankit sir took our class and from the beginning we attended all the classes..

    gaurav saini

  • Ankit sir is one of the best mentors I have ever had and he's supportive also . He's is the professional in every branch he know and....

    Anshul

  • Ankit sir is the best trainer and have best knowledge in coding he is the best teacher and also supports the idea help to develop them

    rishabh jain
Read More.....