Certified Excel Professional
About Course
Our course is thoughtfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.
It is 80% practical with industry used case studies.
Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.
Content Of Course
Module 1
Basic Formula- Formulae that Add/Subtract/Multiply/Divide
- BODMAS/Formula Error Checking
- The Sum Function
- The VLOOKUP/HLOOKUP Functions
- Creating, Formatting Simple PivotTables
- Page Field in a PivotTable
- Formatting a PivotTable
- Creating/Modifying a PivotChart
- IFs and Nested IF Functions
- Using AND/OR/NOT Functions
- Using The AVERAGE/COUNT/LARGER/SMALLER Functions
- Adding new calculated Fields / Items
- Changing the Summary Function
- Consolidate Pivot table
Module 2
LOOKUP Functions – Advance- MATCH with VLOOKUP Functions
- INDEX & MATCH Functions
- OFFSET/ INDIRECT functions
- If Loop and Nested IF Loop Functions
- Using IF/ISERROR Functions
- The Chart Wizard
- Chart Types
- Adding Title/Legends/Lables
- Printing Charts
- Adding Data to a Chart
- Formatting/Renaming/Deleting Data Series
- Changing the Order of Data Series
- Using the Today
- Now & Date Functions
- Using theDatedif/ Networkdays/ Eomonth Functions
- Using theWeeknum Functions
- Using theEdate/ Networkdays.Intl/ Weekdays.Intl Functions.
- The Mid/ Search/ Left/ Right Functions
- Using the Trim/ Clean/ Upper/ Lower Functions
- Using theSubsitute/ Text Functions
- Input Messages / Error Alerts/ Drop-Down Lists
- Conditional Formatting
Module 3
Advanced Filters- Extracting Records with Advanced Filter
- Using Formulas In Criteria
- Sorting by Top to Bottom / Left to Right
- Creating / Deleting Custom List
- Sort by using Custom List
- Hyper linking data, within sheet / workbook
- Linking & Updating links between workbooks & application
- Using SUMPRODUCT Functions
- Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
- Conduct sensitivity and ‘What if Analysis’, Scenario Analysis, Dashboards, Interactive Financial Models, Monte Carlo Simulation
- Loan Amortization Schedule and functions like PV, FV, PMT, Rate, Nper, IPMT, CUMPMT, etc
Module 4
Summarizing Data- Creating Subtotals/Nested Subtotals
- SUBTOTALS Formula
- Creating/Working with an Automatic/Manual Outline
- Grouping / Ungrouping
- Consolidating Data with Identical/Different Layout
- Displaying/Removing Dependent & Precedent Arrows
- Evaluate Formula – Step IN/ Step Out
- Creating Custom Views
- Displaying Custom Views
- Deleting Custom Views
- Sharing Workbooks & Tracking Changes
- Protecting sheets / workbooks / Files
- Importing Data from Database/ Text Files/ Web
- Exporting Data
- Changing External Data Range
Module 5
Dashboard Preparation-- Dashboard for MIS, Analysis, different dashboards for different business types and business segments, will include a self-assignment (formulas like offset, advance formatting, macros, hyperlink, etc.)
Duration
Duration of Basic Latest Tally Prime Course : 1.5 Months
Batch Timing
COURSE | TRAINING TYPE | BATCH | CITY | REGISTER |
Certified Account Executive | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
Certified Business Account Executive | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
Certified Professional Accountant | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
Certified society accountant professional | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
Certified Excel professional | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
certified GST Professional | Classroom / Online | Regular Batch (Mon-Fri) | Pune | |
Certified Taxation Professional | Classroom / Online | Regular Batch (Mon-Fri) | Pune |
Benefit with us
- Understand practical issues faced with EXCEL with the focused FAQ session
- Gain experience of computer-based practical training on Excel
- Get knowledge on recent amendments & their challenges
- Resolve doubts on EXCEL during & after training
- Real-life cases and experiences shared by EXCEL experts
1. Increased salary percent
With the course certificate, the salary of the people working in the financial sector may increase by a significant amount. They are also likely to get a superior and advanced job position with increased perks.
2. Improved Career Progress
The course certificate may also increase the chances of getting in a better position at the workplace. They can make the work of the individual with this certificate extra inevitable in the tax sector than the ones not having it. They may accelerate the career path with less effort and give better outcomes for the given Hard work.
3. Improved Skill set
The certification course in goods and services tax can also increase the taxation skills of the professionals. They can also provide skills to individuals eager to learn about the indirect tax system. So the people can learn extra about the indirect taxes easily and get a clear picture of their EXCELdetails.
4.Sophisticated syllabus
Unlike some other courses, these certification courses have a better understanding of the syllabus with many types of course delivery. They could even be learned with online classes if the individual has previous experience or a better understanding of the taxation system.
Eligiblity
- B.com, M.com, MBA Finance
- There are as such no prerequisites
- Student of any field can enroll
- Graduates, Undergraduates, 10+2
- Business Owner
- Commerce Subject Students
Salary Package
Salary Package is around Rs 200000 to Rs 300000 as per Industry Standard.
Exams & Certification
Training Earning Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees. Our certification in Latest Tally at Training Earning is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects.
Job Roles After Training
- Student can assist his client in developing Accounting and Book keeping Framework.
- Freelance Opportunities.
- Student can do accounting of Micro, Small, Medium Enterprises.
- Student can be a master of Statutory Compliances.
- Preparation of Books of accounts for all types of Audit work.
- Huge opportunities to work as a Account Manager, Assistance Account Manager, Compliance Officer, etc.
- In BPO or KPO as a Excel Expert.