Training Programme on Excel and PDF Adobe (Virtual)

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

  1. 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

  1. 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

  1. 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

For short Excel video, please follow on below links:

 

Follow me on YouTube:

https://youtu.be/mFqbdVAM_mI

Follow me on LinkedIn:

https://www.linkedin.com/in/ca-vaibhav-doshi-30ab75124/

Follow me on WhatsApp:

https://chat.whatsapp.com/G29ud5uZV2N2bTfHddk2SA

Follow me on Facebook:

https://www.facebook.com/vaibhav.doshi.315/

Event Information

Event Date 09-10-2021 10:00 am
Event End Date 10-10-2021 12:00 pm
Cut off date 09-10-2021 8:00 am
Available place 467
CPE Credit Hrs 4 Hrs.
We are no longer accepting registration for this event
Press enter to search

THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA
(Setup by an Act of Parliament)

Pune Branch of WIRC of ICAI
‘ICAI Bhawan’, Plot No. 8,
Near Mahavir Electronics,
Parshwanath Nagar, Bibwewadi,
Pune - 411 037, Maharashtra, India.

Working Hours

Monday to Saturday (Except Public Holidays) 10.00 am to 6.30 pm
(Lunch Break 1.00 pm to 1.30 pm)