Download Free ebook on Excel Macros

Free Course on Excel Tables

  • Different methods to create Excel Tables
  • 10 Advantages of using Excel Table
  • How to use VLOOKUP on Excel Tables
  • How to Connect Excel Tables

Excel for Data Analysis (Malayalam)

  • Flash Fill, Custom List, Auto Filter
  • Data Validation, Paste Special
  • Data Entry Form, Camera Tool
  • 3D Sum, Advanced Filter

Free Tutorials on Excel

Excel Formula

An Excel Formula is an expression that calculates the value of a cell.

Commonly used Excel formulas explained with Examples…

Excel Functions

An Excel Function is a Predefined Formula with a human-friendly name.

50+ Excel Functions explained with examples…

Excel Tables

Table is one of the most underused features in Excel.

How to make the best out of Excel Tables explained in detail with examples

Excel Macros

Macros are codes written in VBA helps to reduce the manual effort required for a job.

100+ Ready to use Excel Macros

Power Query

Learn how to Write Queries, Tweak Queries, Create custom functions in Power Query and more…

Shortcuts in Excel

200+ keyboard shortcuts in Excel explained (Videos and Articles)

Blog Posts on Excel

Blog Posts explaining Tips & Tricks in Excel

Video Tutorials on Excel​

150+ Video Tutorials on Excel.

Excel Malayalam

150+ Malayalam Video Tutorials on Excel.

Free Tutorials on AutoCAD

Programming in AutoCAD

Macros are codes written in VBA (Visual Basic for Applications) which helps to reduce the manual effort required for a job. Macros save your time and headaches by automating common, repetitive tasks.

Scripting in AutoCAD

Scripting is another method of automating tasks in AutoCAD, without the aid of programming languages like VBA or AutoLISP. We can create and manipulate AutoCAD objects, Open and Plot multiple drawings using Script files.

Blog Posts on AutoCAD

Blog Posts explaining Tips & Tricks in AutoCAD

Programming in AutoCAD

  • Macros to create AutoCAD Objects
  • Macros to extract details from AutoCAD drawings
  • Userforms to collect data and trigger actions
  • Macro for exporting data from Excel to AutoCAD

Click here to Join

Scripting in AutoCAD

  • Create AutoCAD objects using Scripting
  • Microsoft Excel for creating Script files for AutoCAD
  • Import points into AutoCAD drawings using Script file
  • Simple Animations in AutoCAD, using Script files

Click here to Join

Join our YouTube Channel for videos on
Excel Formulas, Functions, Charts, Pivot Tables, Power Query,
Power Pivot & Programming in Excel