- October 12, 2016
- Posted by: admin
- Category: Excel Next Blog
We conduct Microsoft Excel Training programs in Riyadh, Dubai, Abu Dhabi, Qatar, Muscat, etc. Our programs are supported by videos, blogs, eBook, relevant industry experience.
We customize Microsoft Excel training programs as per:
- Beginner: Sort, Filter, VLookup, Shortcuts
- Intermediate: Sumifs, Countifs, VLookup with Match, Pivot Table, Text & Date Functions
- Advanced: Index with Match, What if Analysis, Charts
Customization Example: (1) Microsoft Excel function “NETWORKDAYS.INTL” allows the user to customize the weekend as per Friday / Saturday and help calculate the number of business days between a start date and end date. Similarly, Microsoft Excel function “WORKDAY.INTL” will help find the deadline date assuming Friday / Saturday to be the weekend. This customization will be valuable for tracking projects based in Dubai. In locations such as Dubai, Abu Dhabi, Qatar, Muscat, etc., Friday and Saturday are excluded from business days computation.
Top 10 must know Excel Tricks:
- FlashFill: Ctrl + E – v. 2013
- Excel COM Add-in: Inquire (Compare Spreadsheets, Clean Excess Cell Formatting, Diagram) – v. 2013
- Remove Password using a Notepad
- Sparklines (chart inside a cell) – v. 2010
- SUMIFS, COUNTIFS, AVERAGEIFS
- VLOOKUP + MATCH
- INDEX + MATCH
- Go To (Special) with Ctrl + Enter
- Array Formula for MAXIFS and MINIFS – (Ctrl Shift Enter)
- Macros – How to find relevant VBA codes on Google and apply for them
Our online courses on Microsoft Excel Training are watched by users from Riyadh, Dubai, Abu Dhabi, Qatar, Muscat, etc.