Topic: 6 Days Online Excel Certification Course

6 Days Online Excel Certification Course

Topic: 6 Days Online Excel Certification Course

Date and Time:
Saturday July 25, 2020 - 19:00 - 21:00
Speaker Name:
Deepak Gupta, B. Com, FCA
Platform:
Zoom
Fee:
Rs 600
Studycafe is happy to invite you for Third Batch of 6 Days Online Advance Excel Certificate Course.

Time : 06:30 pm to 8:30 pm

Days : July 25, 2020 to July 30, 2020

Deepak Gupta, B. Com, FCA

Day 1: Data Cleansing & Date related Calculation Functions :

Alt Function, Excel Smart Shortcuts, Edit Tool Bar, Randomdata, Smart Copy Paste, Smart Paste special, Transpose, now, date function, Format Cell, Concatenate, Trim & Clean, Proper, Upper, Lower, Left, Right, Mid & Len, Filter, Advance Filter, Format Painter.

Day 2: Advanced Features in Excel :

Concatenate & Text Join, Giving password to excel and back up, Advance Find & Replace, Smart Sorting, Skip Blank, TDS Working Check list, GST Late Fees Calculator, Import 26 AS data and converting in to excel

Day 3: Advanced Excel Functions :

Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, if functions, Goto Special, Macro of Spell Number, etc.

Day 4: Advanced Excel Functions :

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal,  Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup

Day 5: Advanced Excel Functions :

Data Merge from Multiple file, Table, Pivot Table, Sparkline Chart, Preperation of Balance Sheet from trial.

Day 6: Advanced Excel Functions :

Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit, CFO or Management Dashboard, Extract data in Excel from NET, Excel worksheet to corporate (or Tally) database & extract any data that you want, Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments

Organisation: Studycafe India Pvt Ltd
Address: 1523, Hemkunt Chambers, 89 Nehru Place
Delhi - 110019 India

Contact Person: CA Amrish Aggarwal
Mobile: 8376042623

Studycafe India Pvt Ltd

Contact Us: CA Amrish Aggarwal

Address

1523, Hemkunt Chambers, 89 Nehru Place,
Delhi - 110019 India