What you'll learn
- Master Microsoft Excel from Beginner to Advanced
- Learn the most common Excel functions used in the Office
- Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
- Become Master in using Advance Features Like Slicer, Flashfill, Sparkline charts
- How to Import Data from Web, Tally ODBC Server
- How to Record Macro and how VBA Works
- Attain in-depth knowledge on the fundamentals of SAP S/4HANA Finance
- Gain clear understanding on the scope of SAP
- Understanding of How Cost Centre Works in SAP
- Learn How to execute T Codes in SAP S/4 HANA
- AP, AR, Asset Accounting in SAP S/4 HANA
- How to Extracts B/S, P/L & Monthly Reports from SAP
Microsoft Excel & SAP Certification Course
In our continuous endeavor to empower more and more finance professionals, this Microsoft Excel & SAP Certification Course has been designed for you. Detailed 9 Days course has been designed where daily more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Files. Live training on Excel & SAP will be given.
How I will get the course:
This is an online Microsoft Excel & SAP Certification Course so there will not be any physical delivery of the lectures. After the purchase of the Microsoft Excel & SAP Certification Course , you can see the Microsoft Excel & SAP Certification Course under my account option under purchased courses. All the videos, study materials, PDF files, PPT’s, files will be uploaded there for quick access of participants. This Microsoft Excel & SAP Certification Course is valid for 60 Days.
Who is Eligible to Join Microsoft Excel & SAP Certification Course :
There is no bound on the eligibility from our side for Microsoft Excel & SAP Certification Course . Any person who wants to learn and master in Excel & SAP can join this course. However, it will be more beneficial for the below-mentioned persons:
⭐Commerce Graduates/CA/CS/CMA/Law students
⭐Tax professionals whether in JOB or Practice
⭐Semi-qualified CA/CS/CMA working in CA Firms or in Industry
⭐Any other person not covered above can join course if interested.
The course duration is around 18 hours.
A Certificate of Participation from the Studycafe will be provided on completion of the Microsoft Excel & SAP Certification Course .
This is a Completely online course, no bar on the number of views. During 60 days you can access this Microsoft Excel & SAP Certification Course from anywhere at any time with unlimited views.
Course Start Date:
Microsoft Excel & SAP Certification Course is starting from Aug 16, 2021, and will be completed on Sep 7, 2021.
Timing: 07:00 PM to 09:00 PM.
Excel from Aug 16 to Aug 22 & SAP from Sep 6, to Sep 8
Day 1 - Data Cleansing & Date related Calculation Functions :120 Mins
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 :120 Mins
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 :120 Mins
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 :120 Mins
Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,
Day 5 - Advanced Excel Functions :120 Mins
Table, Vlookup, Hlookup, X Lookup Funcation, How to Create Pivot Table, USe of Pivot Table Pivot Table, Advance Pivot Table Features, Pivot Charts, Sparkline Chart,
Day 6 - Advanced Excel Functions :120 Mins
Preparation of Balance Sheet from trial, 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.) the current value of investments, Reconciliation of GSTR2A with GSTR3B
Day 7 - SAP S/4 HANA – Technology Design & Integration120 Mins
• How S/4 HANA is transforming Businesses
• SAP Design and Modules
• Integrating Business Processes with FICO, MM, PP and SD
• SAP Live – Navigation and Transactions (T-code)
Day 8 - SAP FI - Multiple Accounting Principle & Financial Controls120 Mins
• New General Ledger – Accounting & Financial Statement
• Accounting for Vendors (AP), Customers (AR) & Asset (AM)
• SAP Live Demonstration
Day 9 - SAP CO - Management Decision making120 Mins
• Why you need Controlling? Controlling Components
• Cost Centre Accounting, Internal Order
• Product Costing (PC), Marginal Costing (COPA), SBU Accounting (PCA)
• Career in SAP FICO
• SAP Live Demonstration
Who can join this Certification Course?
⭐ Commerce Graduates/CA/CS/CMA/Law students ⭐ Tax professionals whether in JOB or Practice ⭐ Qualified CA/CS/CMA/LLB ⭐ Semi-qualified CA/CS/CMA working in CA Firms or in Industry ⭐ Any other person not covered above can join course if interested.
What will be Language of Certification Course
PowerPoint Course will be in Mix of English and Hindi Language.
What is the Duration of the Course?
Course will be of 9 Days and more than 18 Hrs.
Whether Course Material will be Provided?
Yes, Course Material will be Provided.
Whether Course Recording will be Provided?
Yes Recording will be Provided for 60 Days.
How Can we Join ths Course?
Please register yourself and make the fees. After making fees you will get call fom our side.
Terms and Conditions
- Recording will be Valid for 60 Days Only.
- Fees will not be Refunded After the Enrollment. Check Course Description Before Buying
- Required internet connection. Lectures can be viewed on Mobile or Laptop
This course includes:
- 18+ Hours of Video Content
- Recording is Available for 60 Days
- Studycafe Certificate of Completion
- Access on mobile or Computer/Laptop
Certificate to be provided to all the participants.