Duration:10 Hours For queries and concerns drop an email to learning@snapdeal.com
SUPC: SDL716635089
Other Specifications
Other Details
Country of Origin or Manufacture or Assembly
India
Common or Generic Name of the commodity
Courses & Certifications
Manufacturer's Name & Address
Packer's Name & Address
Marketer's Name & Address
Importer's Name & Address
Description
Master Microsoft Office 2010 with this 10 hours, and over 118 videos. Microsoft Office 2010 is a widespread edition of the famous workplace software, but it’s also one of the more difficult versions for some users to get to grips with. During this 10-hour course, you’ll start from the basics, covering everything that you need to use Excel, Word, PowerPoint, and Access 2010, including advanced courses for Excel & Access that will help you achieves real mastery. So go ahead and impress your colleagues and wow your boss by taking your Office skills to the next level, making yourself capable of tackling almost any task with ease.
Course Content
MS Excel
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
MS Access
Access Intro
Create table in MS Access
How to Import and Export in Access
create form from table
Create Blank Form in Access
Creating Report in Access
Query in access
SQL Queries part 1
SQL Queries part 2
MS Word
MS Word Introduction
Ms word Font Formatting
Paragraph options
bullets and numbering
sorting option
styles in word - Heading Pattern
Page , Cover page, page break
Creating Table in Word
pictures in ms word
Shapes in Ms Word
SmartArt in Ms Word
Chart and Screenshot
Bookmark and Cross Reference
Hyperlink in word
Header and Footer and Page no
Text box, wordart, Drop Cap and symbols
Quick Parts in Ms Word
Print related option
Watermark in MS Word
Page color and page border
Table of Content
Biblography and Citation
Caption in ms word
Footnate and Endnote
Mark Entry in MS Word
Mail merge
language and proof
Track Changes in word
MS PowerPoint
Powerpoint Presentation Intro - Layout and section
Formatting and manage Video
Text box, Header and Footer
Slide show options
Design in Powerpoint
Transition effect in Powerpoint
Animation in Powerpoint
Presentation Intro - Layout and section
Course Highlight
Practical Training on latest version of MS Office 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
118 Lectures and more than 10 hours of Videos
Sample Video
Terms & Conditions
The images represent actual product though color of the image and product may slightly differ.
