Duration:7 Hours For queries and concerns drop an email to learning@snapdeal.com
SUPC: SDL221310273
Description
Buy now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 10+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you participate each of the videos you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions
Create dynamic report with Excel PivotTables
Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!
Course Content
Excel structure
Cell properties
autofill val and text
autofill date
Autofill Adv tools
cell reference
Operators based Equation
Math Function
Text Function - Upper, Lower, Proper, Trim
Text Function - Right, Left
Text Function - Find and task
Text Function - Solution and Nested Left
Text Function - Find and Left Nesting
Text Function - MID
Text Function - Mid task and solution
Text Function - Concatenate
Text Function - Concatenate task and solution
Text Function - Replace
Text Function - Replace task and Solution
Text Function - Substitute
Text Function - Len, Rept, Excat, Search
text to column
workbook protect
protect sheet
Hide Formulas and unlocked Cell
Protect File with password
If Function - Logical Test
If Function - with Equation and task
If Function - Nested If
If Function - advance
If Function - adv 2
AND , OR Function
AND, OR, IF Nested
AND, OR Advance
Pivot Table - Intro
Pivot Table - Manage Field Area
Pivot Table - Value Field, Report and more
Pivot Table - Slicer and Dublicate Pivot
Pivot Table - Group to mange date and values
Pivot Table - Insert Calculated Field
goal seek
scenario manager
pmt function - EMI calculator
Data table - Create Loan Table
Print option in Excel - Part 1
Print option in Excel - Part 2
share book
Chart Preperation
Chart Preperation - Advance
Chart Preperation - Customize
Conditional Formatting
Conditional Formatting - Types of Rules
Conditional Formatting - Apply
Conditional Formatting - Create New Rules
Conditional Formatting - Mange Rules
Data Validation
Data Validation - Input message and Error Alert
Advance Math Function
Advance Math Function 2
Using of Wild Card in Math Function
Vlookup Function
Vlookup with Iferror
Vlookup Nesting with If
Hlookup
Match
Index and match nested
Vlookup array
vlookup col trick
Vlookup true
Advance VLOOKUP
Macro Recording part 1
Macro Recording part 2
Macro Recording part 3
Types of ways to run macros
Course Highlight
Practical Training on latest version of MS Excel 2010
MIS level Training will be provided
Candidate will be Job Ready after the Course Completion
One of the Most Comprehensive training
Highly experienced Trainer with over 2000+ projects in MIS
70 Lectures and more than 7 hours of Videos
Sample Video
Terms & Conditions
The images represent actual product though color of the image and product may slightly differ.
