Become a Microsoft Excel Expert with AVIT GURU Trainers

Become a Microsoft Excel Expert with AVIT GURU Trainers

Start your Microsoft Excel training online with AVIT GURU trainer. From mastering the basics to exploring dynamic data exchange and object linking and embedding, you will find all the help you need with one of our tutors! Take control of your Excel expertise and start your online MS Excel Training today.

Online Classroom by SKYPE

Learn at your own home/office/any comfort place in our online classroom. Utilize the interactive whiteboard (online webcam by using Skype) to study formulas and rules with your tutor. Upload files into the online classroom and get real-time help. Using the file sharing tool, you can learn alongside your tutor and discover new templates and spreadsheet modeling. Use the chat feature to discuss Component Object Model and Visual Basic for Applications to enhance your knowledge.

AVIT GURU offers following courses in the field of Microsoft Excel:

====================================================================================================

ADVANCED EXCEL & MIS:

You will learn about the following topics.

  • Introduction of MIS.
  • Introduction of Reports – Ad-Hoc and Routine Report.
  • Introduction of Excel.
  • Basic Excel (Special Paste, Go To Special, Fill Series, Sort & Filter, Advance Filter, Find & Select, Slicer, Conditional Formatting , Cell Format, Number Format, Merge & Center, Hyperlink, Print Page, Data Validation, Goal Seek, Freeze Panes, Naming Range, Protection and Many more basic tricks)
  • Advance Excel (Functions & Formulas) (Sum, Sumif, Sumifs, Count, Countif,  Countifs, Sumproduct) (IF, Nested IF, AND, OR) (Isna, ISRR, Iserror, Iferror) (Right, Left, Mid, Search, Find, Substitute, Replace) (Eomonth, Edate, Datediff, Datevalue, Timevalue, Weekday, Weeknum) (Indirect, Lookup, Vlookup, Hlookup, Index, Offset) (Pivot Table, Pivot Table).
  • Dynamic Chart.
  • Dashboard (RCA, KPI, SALES)
  • Microsoft Power BI (Power Query, Power View, Power Pivot, Power Map)
  • Interview Questions & PDF Notes, class videos.

To know more regarding the course fee and class schedule etc about this course, CLICK HERE

====================================================================================================

VBA MACRO AUTOMATION:

You will learn about the following topics

  • Introduction of VBA & Macro.
  • Introduction of Class, Object, Properties and methods.
  • Introduction of Variable & Data Types.
  • Basic Automation with VBA & Macro.
  • All Types of Event (Worksheet Event & Workbook Event)
  • All Types of Error Handler & Controls.
  • All Types of Loop (For Next, For Each, Do While, Do Until, While Wend)
  • Pivot Table & Pivot Chart.
  • All Types of Excel Functions Using In VBA.
  • User Define Functions.
  • Array – Static & Dynamic Array.
  • Connectivity With Other Microsoft Application ( Excel To Excel, Excel To SQL, Excel To Access, Excel To Word, Excel To  Notepad, Excel To  Outlook With Html, Excel To Web)
  • User Forms.
  • Class Module Concept.
  • Introduction  Type Declarations (User-Defined Types)
  • Intro of Enumeration and how to use in type declarations
  • Add INS & Custom Tabs/Ribbons.
  • Interview Questions & PDF Notes

To know more regarding the course fee and class schedule etc about this course, CLICK HERE

====================================================================================================

MS ACCESS REPORTING & AUTOMATION:

You will learn about the following topics

  • Introduction of MS Access Database.
  • Introduction of DBMS & RDBMS.
  • Introduction of Data Types.
  • Introduction of Table, Query, Reports, Forms.
  • Create All Types Of Query From QBD (Query By Design), SQL Syntax.
  • All Types of Join.
  • Create A Table From Wizard, SQL Query & VBA..
  • Create A Reports From Wizard, Using With SQL Query.
  • Create Form From Wizard, Using With SQL Query & Using With VBA.
  • Connectivity Access to Excel,Access to SQL Server From VBA.
  • Protection Database.
  • Interview Question & PDF Notes.

To know more regarding the course fee and class schedule etc about this course, CLICK HERE

====================================================================================================

Leave a Reply