Trainer :- CA. Vaibhav Doshi

Day 1: 9th October, 2021 – Excel

1. Smart shortcuts, formatting formula and technique, graphical presentation:

Easy scroll and navigations of cells, Justify, Double click Painter, Paste values shortcut, Sub - Total & Sparkline, Date formats, 3D references

2. Data management features (Validation tools, extraction and conversion tools and data modeling tools):

Pivot table with Pivot slicer features and Excel table, recommended Pivots (A.I), Flash Fill, data validation, remove duplicates, Basic Forecasting

3. Advanced formula Part 1:

Concat formula instead of Concatenate - Show with Multiple rows and columns, TextJoin technique, match function with Lookup, V Lookup, H Lookup, Xlookup

Day 2: 10th October, 2021 – Excel and PDF

1. Advanced formula Part 2:

Use of IFS Formula instead of IF and nested IF formula

2. Adobe PDF Pro Version

• Merging of various documents into one file (E.g. Merge Excel file, PowerPoint file, Word file, Image file into one consolidated PDF) and Create PDF from Web
• Convert PDF (including scanned PDF) into editable format with Adobe PDF tool
• Reorder Pages, Organise, split, extract pages
• Fill Forms online in PDF
• Edit PDF - Comment, Stamp, Attachment, Strikethrough Text, Sticky Notes, Highlighter, Crop
• Export PDF to all Microsoft office applications
• Optimize PDF Tool (reduce size)
• Remove sensitive information - Redact Tool
• Insert Password and encrypt PDF. Also, learning of password removal and encryption
• Working on PDF online with two or more people with real time web sharing