XL n CAD

Tutorials on MS Excel and AutoCAD

Training and Consulting

XL n CAD offers Basic to Advanced level training to individuals as well as companies.

Write to [email protected] for a quote and detailed syllabus

Course Detail

Basic/Intermediate

This course will cover all aspects of creating Spreadsheets, Performing calculations, Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index, etc. It also guides you on data presentation using Conditional Formatting, Excel Tables, Pivot Tables, Excel-Charts, Formatting and using page setup for printing. Excel users who have not had any formal training will find this course extremely useful, as it will bridge the gap in your knowledge of Excel

Advanced

This Course is designed for Excel users who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel. Dashboards, Macros, and programming in Excel will be the main Topics covered in this course.

5 Day Advanced Excel Training for the Admin team of United Nations Environment Program at Geneva (17/06/19 to 21/06/19)

Customize Sheets / DashBoard

I design Sheets and Dashboards for individuals and enterprises based on their requirements.