Downloadable Office Ninja Course

Downloadable Files & Read to use Instructions for Office Ninja Course

  Enroll in Course

This bundle includes four courses with video tutorials worth 26 hours. The courses are also include one license of offline access so you can take you courses anytime with /without the internet.

What do we cover?

Excel Ninja:

  • Handpicked Ninja Shortcuts
  • Formula Warm-Up
  • Formatting Tricks
  • Cell Referencing ($) - Relative & Absolute
  • Go To - Special "magic wand"
  • Sort (Vertical, Horizontal, Custom), Filter & Advanced Filter
  • Working with Dates
  • Data (Cell Input) Validation
  • Setting up work area view
  • Pivot Table
  • Lookups (1D, 2D, 3D, Reverse) & Conditional Calculations (Sum, Average, Count, Special Running Total)
  • Data Cleaning / "Sanitizing" & Text Formulas
  • Logical Formulas - Single & Combo
  • Conditional Formatting
  • What-If Analysis
  • Subtotal & 3D Data Consolidation
  • Workbook & Worksheet Security
  • Printing
  • Multiple Windows, Comments, Hyperlinking

Excel VBA:

  • Introduction 1
  • Introduction 2
  • Google
  • Objects, Properties, Methods
  • Workspace
  • Range & Cells Object
  • Absolute Vs Relative Reference
  • Range Navigation
  • Variable Declaration
  • Loops
  • Optimizing Code Effeciency
  • Events
  • Input Box
  • Msg Box
  • Activex Controls
  • User Forms
  • User Defined Functions
  • MIS Projects

PowerPoint Ninja:

  • Speed Tricks: Lightning fast shortcuts and custom tricks to perform recurring activities such as alignment, editing text, cloning shapes, working with SmartArt etc.
  • Creating Impact: Emerging trends on visual effects such as magnifiers, highlighters, de-highlighters, cut-outs, layers, topic trackers
  • Ninja Charting: Waterfall or Bridge, Thermometer, Combo, Multi-axis, Spider, Butterfly or Tornado, ringed doughnut & more
  • Animation: Button triggered activity & motion path animation
  • Templates: 10,000+ ready-made templates from SlideModel at special price
  • Industry best practices – Annual reports, Investor presentations, Research reports, Pitch books
  • New features of 2013: Merge shapes, Eyedropper (color picker), Smart alignment guides

Word Tricks:

  • How do you avoid typing out frequently used text?
  • Do you know that your clipboard saves up to 24 instances (when you cut/copy)?
  • Do you struggle with creating a table of content, list of figures, etc?
  • How to you use mail merge by using data from excel

Your Instructor

Rishabh Pugalia
Rishabh Pugalia
  • Qualified Chartered Accountant
  • Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
  • Four years of work experience in the area of Audit, Investment Banking & Proprietary trading
  • Program Director & Training Instructor – Advanced Excel, Advanced PowerPoint, Financial Modeling
  • 5.5 years of work experience in Corporate Training & Workshops
  • Under him, Excel Next has trained more than 6,500 professionals across 14+ cities
  • Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy.

Course Curriculum

  Downloadable Resource & Instructions
Available in days
days after you enroll

Get started now!


- An accelerated, Practical approached Advanced Office Tutorials to teach you Skill needed to compete in competitive work environment
- You'll get offline access to our complete courses like Excel, PowerPoint, VBA, Word Tricks
- All Advanced tutorials case studies related to videos
- A picture based Excel PDF handbook on Excel Tips, Functions & Techniques
- Access to all video tutorials 24 x 7 - learn Offline from anywhere on your Windows Laptop or PC without activate internet connection
- You will also get support for doubt and assistance to implement your learning in real-life challenges.

You can access downloadable office ninja course by just a click on Enroll in Course button Payments can be made using any of the following options and receipts of the same will be issued to the candidate automatically via email.
- Visa/Master Card credit and debit card
- PayPal
- Net Banking

This is a Self-paced lean office ninja course program with videos from basics to advanced tutorials. Watch the preview of videos tutorials to get a flavor the program's uniqueness and relevance. Video courses may not be your first preference. But I promise this – After watching 3 videos, this courses will give a tough fight to your usual classroom training.

Refund policy won't be applicable for course post activation key is sent to you.

To know more please read our Refund Policy. If you just want to get to know the flavor of the course, you click on any one of the tutorials

- We are covered by YourStory | Inc42
- Recommended by MBAExcel.com | Excel Made Easy | WmfExcel | Excel Champs | Engineers Excel | Get Digital Help | AJP Excel | Deskbright
- Our Client list include: Big Fours (KPMG, PwC, EY), Tata Group (Our Corporate Training Company)
- We are among Top 35 Excel Resource Websites in the world

Simple – Our feedback form from each corporate clients give us a rating between 4.8 to 5 (5 being the highest). We will empower you with tips and tricks based on real issues faced by 1000s of students we teach. We created these advanced tutorials after so many years of research and hundreds of hours of training.

Still have more questions?

Call us on +91-8080042523 or Email us at [email protected]