Ms-Excel & Advanced Excel Training

Batch Schedule ’17 – ’18

Dates Days (Online/Classroom) Timing Enquiry
30 DEC 17 Sat- Sun 10:00 Am – 2:00Pm Enroll Now
01 JAN 18 Mon-Fri 09:30 Am – 6:30Pm Enroll Now
06 JAN 18 Sat- Sun 10:00 Am – 2:00Pm Enroll Now
08 JAN 18 Mon-Fri 09:30 Am – 6:30Pm Enroll Now
13 JAN 18 Sat- Sun 10:00 Am – 2:00Pm Enroll Now

Ms-Excel & Advanced Excel Training

  • Advanced Excel  Training

Have some experience with Excel and want to improve your skills? This Advanced Excel online course will help you learn intermediate and advanced Excel techniques.

In 16 or more engaging sessions you will learn how to find a value with VLOOKUP, create and format Pivot Tables, record basic Macros and more.

Whether you use Excel for work or study, these tutorials will help you on your journey to becoming an Excel Expert!

The Advanced Excel Training course  from Mildain is Microsoft Excel 2010, 2013 and 2016 compliant. Videos are recorded in Microsoft Excel 2016 and 2013 for PC, and where the user interface is significantly different.

  • What are the requirements?

  • Microsoft Excel 2013, Windows 8, 7, Vista or XP

  • What am I going to get from this course?

  • Over 128 lectures and 10 hours of content!
  • To take your basic Excel skills to the next level
  • 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

  • What is the target audience?

  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title

Key features

  • 32 hours of instructor-led training
  • 32 hours of high-quality eLearning content
  • 5 simulation exams (250 questions each)
  • 8 domain-specific test papers (10 questions each)
  • 30 CPEs offered
  • 98.6% pass rate

Ms-Excel & Advanced Excel Training                                          Duration :- 4 Days

  • Topics Covered

  • Advance Features of Ms-Excel. Advanced Excel course also enables the student to utilize, the advance
  • features taught in this course in an office environment with maximum efficiency.

  • BASIC Microsoft Excel:

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets

  • ADVANCED Excel Contents:

  • Formulas & Macros Formulas:
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas

  • DATA Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK
  • PIVOT Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

  • MACRO’S:

  • Macros:
  • Definition and use , Record a macro
  • Assign a macro , Run a macro
  • Store a macro, Introduction to VBA Prog.

  • Develop the Worksheet:

  • Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance

  • Special Operations:

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Advance Excel Training With Live Projects

  • Graphic Operations:

  • Create charts , Enhance charts, Drawing toolbar features

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

1. Online ,By deposit the mildain bank account

2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.
Venue is finalized few weeks before the training and you will be informed via email. You can get in touch with our 24/7 support team for more details. Contact us Mob no:- 8447121833, Mail id:  [email protected] . If you are looking for an instant support, you can chat with us too.
We provide transportation or refreshments along with the training.
Contact us using the form on the right of any page on the mildain website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

Find This Training in Other Cities:-

Kolkata, Bangalore, Mumbai, Hyderabad, Pune, Delhi, Chennai.

Drop Us A Query

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Query

For Business

Corporate Training Solutions

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Course, category, and all-access pricing
  • Enterprise-class learning management system (LMS)
  • Enhanced reporting for individuals and teams
  • 24×7 teaching assistance and support

Any Enquiry contacts us:

Contact us

You can reach us for Following locations in India

noidadelhijaipur IndoreChennai HyderabadPuneBangalorechandigarhmumbai

Globally

usa ukAustraliaSingaporecanada

REVIEWS

“ Good session..!!Will be useful to improve my technical Knowledge. ”
Parveen
“ I was enrolled for Online Xamarin Training ,It was wonderful experience. ”
Ajay Nunna
“ My Trainer for Guidwire was knowledgeable and taught me all basic to advance information, huge thanks to Mildain for its support. ”
Gaurav
“ Guys go for Xamarin course , It was best among all , Thanks to Rahul sir for Training. ”
Raghav
“ I enrolled for PMP online training, Thanks for giving me all question bank, study material and post Training support. ”
Sameer
“ I was bit skeptical at starting for Blueprism, As there were not more institutes to offer blueprism, Thanks Mildain and team , I am happy to say that I have learn blueprism. ”
Saleel