EXCEL TRAINER: Having 15 years Professional Working Experience in Account & Finance
HOME TUITION FACILITY: Learn Advance Excel at your doorstep
COURSE OVERVIEW: Excel is the spreadsheet application in the Microsoft Office suite. This course will show you how to use the powerful tools in Excel for organizing, visualizing and calculating data.
Microsoft Excel is the most widely used productivity tool, Microsoft Excel allows us to accomplish a task in multiple ways allowing us to accept more challenging tasks resulting in an efficient and effective performance.
You will learn Advanced Excel Features & Functions such as:
•Power Query: Extracting, Transforming, Converting & Loading data, Merging & Append Queries
• Power Pivot: Build Relationship b/w Table, Create Measure, KPI, Calculating Columns
• Pivot Table: Value Field Setting, Slicer, Timeline, Frequency Distribution, Calculated Field items• Excel Dashboard: Uses of Control form, Link Data with charts & dynamic presentation
• Lookup Function: VLookup, HLookup, Reversal VLookup & Index & Match Function
• Summarizing Functions: SumProduct, Sumifs, Sumif Functions
• Count Functions: Countifs, Countif, CountA, & Countblank Functions
• Offset Function, Indirect Function, Choose Function• Database Function: Dsum, Daverage, Dcount, Dmax, & Dget Functions
• Whatif Analysis, Hyperlink, Data Consolidation, Data Sorting, Subtotal Options
• Data Validation, Logical Function IF, AND & OR
• Conditional Formatting: Highlighted Cell, Data Bars, Color Scale, Icon Set, New Rules
• Time, Days, Date, Year, Month Function, Elapsed time calculation
• Text Function: Trim, upper, Lower, Proper, Concatenate, Replace, substitute function
• Auto Format, Paste Special, Data Entry form, Text to Column
• Macro View & Record, Filter & Advance Filter
• Protection of Sheet, Cell, file & Workbook
• Large, Small, Mix & Max, Row & Column Function
• Name Manager: Define Name & Create from Selection
• Comment, Insert, Edit, Show & hide Comments
• Use & Benefit of Table, Smart Art, Shapes
• Fill Option with Series, Justify & Across sheet
• Find & Select, Go & Go to Special
• Page Setup: Margin, Orientation, Head Footer
• Screen Shot & Camera in Excel
• Connection: Links Excel Files
• Custom Formatting with Advance Option
• Short Keys, Explore Hidden & Power Feature of Microsoft Excel 2016
By the conclusion of this advanced Excel training, you will have mastered the advanced features and functions of this software
• To gain a solid understanding of the more powerful features and functions in Excel
• To be able to use Microsoft Excel in a commercial environment
• With the basic advance excel skills, you save a good amount of time and increase yours productivity
• Able to create Excel Dash board reporting from Complicated large number of data. Which make you distinguish
• Excel will make you better at your job (No Matter what that is)
Monthly fee of this Training Course is Rs. 12,000/-
Participant Training Plan
• This Advance Excel Training Course having 35 Exercises of most powerful function and feature of Microsoft Excel 2016.
• Participant will practice on almost more than 120 plus professional practical examples in guideline of professional trainer.
• Participant will learn Advance Excel step by step from basic to intermediate to advance level in at least 18 sessions.
• One Day workshop: Introduce all exercise to participant, uses and benefit of these exercises and give orientation how to prepare Excel Dashboard.
Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance