Over 25000+Happy Customers
Over 25000+Happy Customers
Excel Mastery Course-Basics & Advance

Excel Mastery Course-Basics & Advance

Regular price Rs. 3,000.00 Rs. 5.00 100% OFF

ONLY LEFT

Want to get a high paying job in Excel? This is the best opportunity to learn excel from basic to advance. Cost? Less than the price of a pizza!

Course Curriculum


EXCEL - BASICS, ESSENTIALS & FORMULAS

MODULE 1 - EXCEL BASICS (for Beginners)


MODULE 2 - EXCEL ESSENTIALS​

MODULE 3 -EXCEL FORMULAS
  • Lesson 9 – Excel Formula Basics
  • Lesson 10 – Logical Formulas in Excel
  • Lesson 11 – Math Formulas in Excel
  • Lesson 12 – Lookup and Reference Formulas in Excel
  • Lesson 13 – Stats Formulas in Excel
  • Lesson 14 – Text Formulas in Excel
  • Lesson 15 – Date and Time Formulas in Excel
  • Lesson 16 – Formulas Mix and Match (10 Examples)

EXCEL VBA COURSE

MODULE 1
  • Lesson 1 – Introduction to VBA Language and the VB Editor
  • Lesson 2 – Recording/Decoding Macros in Excel
  • Lesson 3 – Running Macros in Excel
  • Lesson 4 – Writing Your First VBA Code

MODULE 2
  • Lesson 5 – Understanding Errors in VBA

MODULE 3
  • Lesson 6 – Working with Cells and Ranges using VBA
  • Lesson 7 – Working with Worksheets
  • Lesson 8 – Workbooks using VBA

MODULE 4
  • Lesson 9 – Using Variables in VBA
  • Lesson 10 – Using Object Variables in VBA
  • Lesson 11 – Using Message Boxes in VBA

MODULE 5
  • Lesson 12 – With Statement Loop
  • Lesson 13 – If-Then Else Loop
  • Lesson 14 – Select Case Loop

MODULE 6
  • Lesson 15 – Do While/Until Loop
  • Lesson 16 – For Next Loop
  • Lesson 17 – For Each Loop

MODULE 7 
  • Lesson 18 – Creating Custom Functions in VBA
  • Lesson 19 – Error Error Everywhere - How to Handle it
  • Lesson 20 – Using Event Procedures to run macros

MODULE 8 
  • Lesson 21 – Userform - Basics + Deep Dive
  • Lesson 22 – Using Array in VBA
  • Lesson 23 – Working with Charts using VBA
  • Lesson 24 – Show and Hide Elements using VBA
  • Lesson 25 – Update Charts/Dashboards with a Single Click

MODULE 9 
  • Lesson 26 – Creating Mouse Rollover Effect using VBA
  • Lesson 27 – Creating Chart Animations using VBA
  • Lesson 28 – Creating Add-ins using VBA
  • Lesson 29 – Creating an Application using VBA
  • Lesson 30 – Working with Files and Folders
  • Lesson 31 – Generating Word Reports using VBA
  • Lesson 32 – Generating PDF Reports using VBA

BONUS

Pre-made Excel Templates
  • Accounts Payable Ledger
  • Attendance Sheet in Excel
  • Content-calendar
  • Gantt-chart_L
  • Loan comparison calculator
  • Make Salary Sheet in Excel
  • MIS BOX Chart Report
  • MIS Progress Report Chart
  • Pivot-Tables-and-Dashboard-in-Excel
  • Profit & Loss Statement
  • Project-timeline
  • Quotation in Excel
  • Salary Slip
  • Sales Funnel
  • Stock Mainteance Report
  • Stock Managment Software
  • Student calendar
  • To-do-list
  • Work-schedule
  • Sales Invoice Tracker


RANGE OF FEATURES & BENEFITS


FREQUENTLY ASKED QUESTIONS


We will give you a link to access all the lessons. You can view the lessons on both Mobile or Desktop. Instant delivery on your email address

Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.

it depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. One of our most successful students Jayne managed to get up at 4am to do her learning! This paid off massively as it landed her a six figure analyst job in a bank!

Please search MasterTheSkills in your email box, also check your spam folder.

 Yes! It is a Microsoft Certified Trainer (MCT) Certified Course.

Please write to us at hellomastertheskills@gmail.co and our support team will get back to you as soon as possible.

All orders are shipped within 24 to 48 hours of you placing the order using Delhivery ,bluedart , expressbess or e Packet depending on your location and fastest available service. Typical delivery time frame is between 14 to 21 business days however, you may receive your items much earlier.

FREE DELIVERY: We pride ourselves on providing free delivery on all our products.

ORDER TRACKING: Not only is your delivery free, it's TRACKED! We track every order to ensure quality service and customer satisfaction. Once you receive your tracking number, simply track your order via our track order page.

100 DAY MONEY BACK GUARANTEE: Our goal is to make you happy, if your not happy, neither are we. Wrong size, wrong color, it's broken, it isn't what you expected. No problem! You have 100 days to send it back to us for a full refund.

FRIENDLY SUPPORT: Customer satisfaction is our main priority, simply send us a message and we will bend over backwards to help you with whatever it is you need.

SECURE PAYMENT: We use some of the most secure payment methods like PayPal. And have secure socket layer technology to ensure all payments are private secure and 100% safe.

people are currently looking at this product

Estimated delivery time 5-10 days

Guaranteed Safe Checkout