MS Office combo Courses (Excel, Word, Outlook, PowerPoint)

MS Office Combo (Excel, Word, Outlook, PowerPoint)
Black Friday offer INR 3000
Actual Price INR 1̶0̶0̶0̶0̶ / Watch & Learn MS Office through videos on Phone, TV or Computer
380+ MP4 videos
Total 1400+ mins of videos tutorials
Free Courier
Free Training Files (For practice)
Free Reusable 8 GB Pen Drive

Learn MS Office Combo Courses

Apane trainer dost ko jaanie:

  • Name: Mr. Rishabh Pugalia
  • Profession: Chartered Accountant
  • Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
  • 4.0 years of work experience in the area of Audit, Investment Banking & Proprietary trading
    • Program Director & Training Instructor – Advanced Excel, Advanced PowerPoint, Financial Modeling, VBA Macros
    • 7.0 years of work experience in Corporate Training, eLearning Content Development
    • Under him, He has trained more than 12,000 professionals across 14+ cities
    • Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy
    • Conducted CPE seminars for Chartered Accountants – Kolkata, Mumbai, Jodhpur

Learn Excel in Hindi

✅ AutoSum function in Excel✅ Number filter in Excel
✅ Max function in Excel✅ Remove Duplicates values in Excel
✅ Average function in Excel✅ Create Drop-down in Excel in 30 seconds
✅ CountBlank function in Excel✅ Remove Drop-down in Excel
✅ Count and Counta function in Excel✅ Freeze Panes in Excel
✅ Master logical statements: True or False in Excel✅ Format Painter in Excel
✅ Simple logical statement: True or False in Excel✅ Table Formatting in Excel
✅ Status bar in Excel✅ Hyperlinks in Excel
✅ Data Formatting in Excel✅ UPPER, LOWER, PROPER to change text case in Excel
✅ Autofill dates in Excel✅ Trim function in Excel
✅ Autofill numbers in Excel✅ Round function in Excel
✅ Sort Data in Excel | Descending order✅ Mround function in Excel
✅ Sort Data in Excel | Alphabetically✅ How to store numbers as text in 1 minute in Excel
✅ Sort by Dates in Excel✅ Value function in Excel
✅ Sort by Color in Excel✅ Len function in Excel
✅ Filter Data and then Calculate Sum in Excel✅ Left – Right – Mid function in Excel
✅ Filter in Excel✅ Excel VBA (Macro Basic)
✅ Working with filtered Data in Excel✅ Basics of Charts in Excel
✅ Pivot Table in Excel✅ Calculate Year on Year percentage Growth
✅ Vlookup function in Excel | Part 1✅ Add serial numbers column before sorting in Excel
✅ Vlookup function in Excel | Part 2✅ 2 level sorting in Excel
✅ Vlookup function in Excel | Part 3✅ Subtotal function in Excel
✅ Vlookup function in Excel | Part 4✅ Format Painter Continuously in Excel
✅ Vlookup function in Excel | Part 5✅ Color multiple sheet tab in Excel
✅ Use Vlookup to find the Debtors Ageing analysis in Excel✅ Color cells based on cell value in Excel
✅ I bet you wouldn’t know this Vlookup trick in Excel | Score Grading✅ Color cells based on cell error or blanks in Excel
✅ I bet you wouldn’t know this Vlookup trick in Excel |Food Grading✅ Adding leading Zeroes in cheque number in Excel
✅ Using Vlookup find Service tax in Excel✅ Calculate Fixed Deposit in Excel | Part 1
✅ Excel vlookup in Multiple sheets✅ Calculate Fixed Deposit in Excel | Part 2
✅ Vlookup vs. Hlookup in Excel✅ Formatting Tricks to write x3 in Excel
✅ Excel Logical function – AND, OR✅ Pie Chart in Excel
✅ IF function and Nested IF function in Excel✅ Chart Trick – Best way to present Charts in Excel
✅ Countif function in Excel | Cell Counting✅ View bar in Excel
✅ Sumif function in Excel | Adding numbers✅ Comments in Excel
✅ Avaergeif function in Excel✅ Print Excel Sheets
✅ Sumproduct function in Excel✅ Dashboard
✅ Delete Error cells by using Go To Special in Excel✅ Dashboard Trick – Create a scroll Bar in Excel
✅ Excel Shortcut: Ctrl + Enter✅ Hyperlinked Shortcuts in Excel
✅ Fill Intermittent Blank cells in Excel✅ Horizontal Sort in Excel
✅ Match function in Excel | Part 1✅ Add a blank row in Excel
✅ Match function in Excel | Part 2✅ Sort Data by Custom list in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 1✅ Thermometer Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 2✅ Multi-axis Chart in Excel
✅ 2D Lookup | Vlookup and Match in Excel | Part 3✅ Formula Security
✅ 2D Lookup | Vlookup and Match in Excel | Part 4✅ Formula Audit
✅ Roundup and Rounddown function in Excel✅ 3D Data Consolidation in Excel
✅ Round function in Excel | Practical Applications✅ Goalseek in Excel
✅ Round Tricks from Excel Superstar in Excel✅ Create Scenario in Excel
✅ Substitute function in Excel✅ Substitute and Replace function in Excel
✅ Activate Developer Tab in 2007-2016 in Excel✅ Joining data strings using CONCATENATE, &
✅ Dashboard Trick – Create a spin Button in Excel✅ Reverse 2-way Lookup – INDEX with MATCH
✅ Microsoft Add-in Fuzzy lookup in Excel
✅ Flash fill in Excel | Data Cleaning
✅ Hide a sheet so that no one can easily unhide in Excel
✅ Confidential – Remove “Protect sheet” Password with Notepad
✅ Confidential – Remove “Protect workbook” Password with Notepad
✅ Making a text magically invisible in Excel
✅ OFFSET function in Excel
✅ Indirect function in Excel
✅ Text to Columns in Excel

MS Word Tutorials

0101 Basics of Font Formatting – Part 1
0102 Basics of Font Formatting – Part 2
0103 Basics of Line and Para Spacing
0104 Basics of Page Layout
0105 Basics of Borders and Shading
0201 Basics of Bullet Points
0202 How to convert boring bullet points into a SmartArt
0203 How to create Multi-level numbered bullet points
0204 Shortcut to apply and remove bullet points
0205 How to add Symbols to bullet points
0301 Basics of Header and Footer
0302 Insert the date or time in a Header or Footer
0303 Insert the Company logo in a Header
0304 Add dynamic page numbering – Page X of Y
0305 Troubleshoot – Header and Footer area is not visible
0401 Basics of Table formatting
0402 How to equally distribute rows height
0403 How to equally distribute columns width
0404 Practice Project – Table Tricks
0405 How to add numbers in columns in a Word table
0406 Shortcut to Split a table into two separate tables
0407 Exercise – Split a table into two separate tables
0408 Repeat table headers on every page
0409 Troubleshoot – Repeat Table Rows isn’t working
0410 Basics of Table Borders and Shading
0411 Cell Shading with Pattern
0412 Access Borders and Shading settings faster
0413 Sort Table columns in a Table – Part 1
0414 Sort Table columns in a Table – Part 2
0415 Sort Table columns in a Table – Part 3
0416 Quick Tables – Reusable Table templates
0417 Convert Table text to regular text
0418 Convert Text to Table
0419 How to Indent an Entire Table with precision
0420 How to merge cells 10x faster using Eraser tool
0421 Save Table to Quick Tables Gallery for reuse
0422 Delete Table from Quick Tables Gallery
0423 Using Symbols inside a Table to visually represent numbers
0501 Basics of Find and Replace – Part 1
0502 Basics of Find and Replace – Part 2
0503 Shortcut to find highlighted text
0504 Shortcut to find a word across pages
0505 Advanced Tricks of Find and Replace – Part 1
0506 Advanced Tricks of Find and Replace – Part 2
0507 How to Remove Double Spaces
0508 Find all the Tables in a document
0601 Shortcut to add current Date and Time
0602 Change the case of the text
0603 Using ALT to activate universal shortcut key tips
0604 How to easily access regularly used features through QAT
0605 Shortcut to Undo and Redo action
0606 Shortcuts to clear text and paragraph formatting
0607 Using Notepad to clean the text copied
0608 Shortcut to Quickly delete text
0609 Shortcut to Increase / Decrease Indent
0610 Shortcut to Manual Line Break
0611 Shortcut to Hide / Unhide the Ribbon
0612 Format Painter Tricks
0613 Shortcut to Copy and Paste Format
0614 Why do we use Paste Special
0615 Shortcuts to Paste Special
0616 Use Clipboard to save time
0617 Shortcut to Keep related words on the same line
0618 Shortcut to Change font size
0619 Alignment & Text Direction tricks
0620 Why should you use Page Break
0621 Wrap Text to place pictures correctly along side text
0622 How to add a horizontal line fast
0623 How to delete the mysterious horizontal line
0624 Magic Trick to Hide and Unhide Text
0625 Find more about the formatting applied 
0626 Split a Paragraph in multiple columns
0627 How to Stop a Paragraph from Splitting Between Pages
0628 Insert a screenshot or screen clipping
0629 Reduce file size if HD pictures used
0630 Select Text Vertically
0631 Watermark
0632 Convert PDF to Word PPT and Excel
0633 Use AutoCorrect Options to auto complete words
0634 Use Portrait and Landscape layout in the same document
0635 How to reuse images and text using Quick Parts
0636 Inserting Footnotes and Endnotes 
0701 Basics of Rulers and Margins
0702 Understanding Rulers and Margins in detail
0801 Basics of Navigation Pane
0802 Navigating across Headings using Navigation Pane
0803 Basics of Bookmark
0804 Using Hyperlink with Bookmark
0901 Why should you use Styles for formatting?
0902 How to use Styles?
0903 Create Table of Contents
1001 Essential Print Settings
1002 Shortcut to Print Preview
1003 How to print on legal stamp papers
1101 Mail Merge
1102 How to create a Fillable Form
1201 Why should you use Track Changes?
1202 How to turn the Track Changes ON / OFF?
1203 Reviewing Pane
1204 Mark-up view and Revisions
1205 Customize Track Changes options
1206 Add Track Changes Button to Status Bar
1207 Accept and Reject changes of multiple reviewers fast
1208 Prevent others from disabling Track Changes using Lock Tracking
1209 Add and Delete Comments
1210 Enable Comments only edit mode
1211 Using Comments and Track Changes together
1301 How to use Thesaurus to write better?
1302 How can “Readability Statistics” help to write better?
1401 How to read lengthy documents using Split Window
1402 How to read lengthy documents using multiple Windows
1501 Recover Text from a Corrupted Word Document
1502 Force Word to Repair a Damaged File
1503 How to Change the auto-save Interval 
1504 Find and Recover temporary autosave files
1505 How to create an auto-backup copy
1506 Prevent changes to the final version of a document
1601 Compare two versions of the same document – Why and How?
1602 Accept / Reject changes using right click
1603 Show compare windows
1604 Compare feature won’t work if protection enabled
1701 Activate Developer tab (for Macros)
1702 How to record / run a VBA Macro and how to view the VBA Macro code (Example 1)
1703 How to record / run a VBA Macro and how to view the VBA Macro code (Example 2)
1704 Demo – How to avoid pressing Del & Spacebar multiple times to clean the text
1705 Solution – How to avoid pressing Del & Spacebar multiple times to clean the text
1706 Logic – How to avoid pressing Del & Spacebar multiple times to clean the text
1707 Create Macros – How to avoid pressing Del and Spacebar multiple times to clean the text
1708 View / Edit the Macro code from Visual Basic Editor (VBE)
1709 Watching VBA Macro code getting recorded LIVE
1801 New Feature 2016 – Tell Me assistant

MS Outlook Tutorials

0101 Outlook – An Introduction
0201 Navigating across your workspace #1
0202 Navigating across your workspace #2
0203 Enabling Conversation View (like Gmail)
0204 Prioritize your emails using Custom views
0205 Display Mailbox Quota in Status Bar
0206 Add Back and Forward buttons to toggle between windows accessed
0207 Using “Split” button to read lengthy emails
0208 Tracking Tasks via “Post-it” notes
0209 Color Format your emails based on Conditions
0301 Finding Contacts efficiently #1
0302 Finding Contacts efficiently #2
0303 Export Contacts to an Excel file
0304 Saving a Contact from an email
0305 Scenario: Forwarding emails to select people group
0401 Sending Emails – Shortcuts #1
0402 Sending Emails – Shortcuts #2
0403 Read Receipt and Delivery Receipt settings
0404 Efficient email subject lines
0405 Using Thesaurus to rephrase existing words
0407 Setting Text Styles to save email formatting time #1
0406 Setting Text Styles to save email formatting time #2
0408 Segmenting your email using Horizontal line
0409 Email Signature
0410 Using Tables in email
0411 Clever Paragraph trick
0415 Quick Parts – Create reusable text in emails
0412 Quick Steps Demo – Automate recurring tasks
0413 Quick Steps #1
0414 Quick Steps #2
0416 Creating Email Template (OFT)
0417 Using AutoCorrect Options
0418 Emailing Groups
0419 Delay email sending
0420 Schedule an email for future delivery
0501 Search Folder – Creating a Virtual folder for emails meeting user defined criteria
0502 Search Folder – FAQs
0503 Search email Basics – Criteria based Search
0504 Search email Advanced – Criteria based Search #1
0505 Search email Advanced – Criteria based Search #2
0506 Using Find feature in an open email
0601 Tasks cycle – Creation, Assigning, Tracking & Completion
0602 Export Tasks to an Excel file
0603 Using custom category (color marker) to prioritize tasks
0604 Create Recurring Tasks & Events
0605 Remove recurring appointments – all at once
0606 Assigning Task to Group with Responsible Person Name
0607 Task List: Different Views
0608 Calculation delay in task completion
0701 Organising your work through Calendar
0702 Create an Event or Appointment
0703 Email & Share Calendar
0704 Printing Calendar with Task List

PowerPoint tricks

0101 Drawing and Duplicating Shape Trick
0102 Re sizing Shape Trick
0103 Copying format and Repeat Last Action Trick
0104 Layering and Decomposing Trick
0105 Breaking up objects and Smart art Trick
0106 Merging shapes and learn few shortcuts
0107 Callouts and Highlighters Trick
0108 Lock Drawing Mode Trick
0109 Using Connectors for Flowcharts Trick
0110 Colorpicker and other useful shape Tricks
0201 Picture Tricks
0202 Triggered Animation Trick
0203 Slide Master Trick
0204 Staggered Car Animation
0205 GearBox
0301 LIVE magnification
0302 Flat Icons
0303 Google recommended color combinations
0304 Inspiration for Illustrations
0305 HD Images (free)
0401 Editing Design & Layout 01
0402 Editing Design & Layout 02
0403 Adding Impact 01
0404 Adding Impact 02
0405 Adding Impact 03
0501 Troubleshooting PDF Copy-Paste issues 01
0502 Troubleshooting PDF Copy-Paste issues 02
0503 Troubleshooting PDF Copy-Paste issues 03
0504 Troubleshooting PDF Copy-Paste issues 04
0505 Troubleshooting PDF Copy-Paste issues 05
0601 Hyperlink
0602 Symbol-based Bullets
0603 Embedding Video
0604 Password Protection
0701 Presentation Views & Print Settings 01
0702 Presentation Views & Print Settings 02