Online Excel Course for Beginners to Advanced Learners

Microsoft excel skills are one of the most valued skills in any organization these days, mastering this skills can enhance an individual’s job prospects and provide better career options. It helps in performing job tasks more efficiently and effectively. It’s very easy for an expert in excel to build a career in corporate finance. With advancements in technology taking place at a rapid pace access to online tutorial in excel has become very easy.

So why wait when GCC Fintax is introducing online tutorials for its users. This online tutorial is for beginners, intermediate, and even advanced users. A mastery in excel gives you a better analysis of data, whereas advanced excel takes your skills to another level. If you enrol for this course, we will help you grow faster. In this, you'll learn to use keyboard shortcuts. You'll also learn how to use advanced formulas and functions and formulas to perform a quality financial analysis and financial modelling.

What you’ll learn?

• How to manipulate data with calculations
• How to unlock the power of dynamic formulas
• How to use pivot tables
• How to reduce complexity of spreadsheets
• How to make custom formulas/functions
• How to master unique tips

Contents

Beginner

Easy to learn

• Easy to learn and Apply
• Data basics (Best usage of Shortcuts, Formatting tricks, cell referencing)
• Simple problem solving (Sort and Filter basics)
• Learn Essential Business Math (Formula Warm up, Pivot table overview

Intermediate Skills

Able to implement techniques in your office

• Build simple models (Combo Formulas, 3-dimensional lookups, Date formulas)
• Error-handling to avoid humiliation (data validation, auditing, track variables)
• Learn Data Cleaning Techniques (Go-to-Special, Text formulas, Flash fill)

Advanced Skills

Ninja-Level Skills

• Slide-ready output (Charts and Graphs, Printing techniques)
• Dynamic Dashboards (Get Pivot data, Learn Reverse lookups, conditional calculations)
• Managing Data Security (Passwords, sheet protection)

Features

The course is a combination of high quality video lectures, which can be watched multiple number of times, notes, demo lectures, query sessions and much more.

• It is mainly designed for students who want to develop skills for worksheet analysis, use advanced excel formulas, use pivot tables, create macros, and much more.
• We have an experienced faculty, which makes it much easier to learn.
• We provide high definition videos.
• We focus on concept building and promise completion on time.
• Some advanced techniques are- using table for presentation of reports, array formulae, superior range names, etc.

Advantage of taking this course

• There is a huge demand for advanced excel executive in the market.
• A combination of the power of Excel with flexibility of other applications like MS Access, Outlook or PowerPoint, promises career advancement opportunities.
• Advanced excel users can complete their task faster and quickly.
• This course provides information regarding technical areas Such as
Statistical functions, mathematical, Data, time and year role, logical and looping functions, chart/graph techniques and so.
• Learn Creating, editing, saving and printing spreadsheets
• Know about Working with functions & formulae
• Learn representing data graphically.
• Learn, how to simplify complex spreadsheets
• Learn to work with templates, charts, graphics, and formulas and streamline operational work.
• Learn to use advanced functions to increase productivity
• You will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, and be able to collaborate with the team on worksheets.
• Have a skill upgrade
• Have Better organisational skill leading to increased efficiency at work.
• Build resume with advanced skill for better job opportunities
• This Course is specially made to help learners with career-building skills. It will help you become better and efficient at your job

Audience

• Students
• Executives
• Managers
• Practitioners
• Chartered Accountants
• Entrepreneurs/Businessmen
• Anyone who wants to use the tool to master organisational skills at work

So, do not spend so much time thinking, go ahead and enroll for this course! We at GCC Fintax are very much concerned about your future. Let's learn together.

About the Training Instructor

Rishabh Pugalia, Founder, Yoda Learning Solutions has trained more than 9,000 professionals on Advanced Excel Ninja across 15+ cities since 2010.

Terms and Conditions:

• Viewers will need Microsoft Excel 2007, 2010 or 2013
• Total Length of Videos: 11 hrs. (177+ Videos)
• Expiry: 6.0 months (Unlimited viewing) from the date of registration
• Videos are meant for web viewing only and cannot be downloaded. Videos are available in Full Screen viewing
• Case Studies (XLSX) for every Video - available for download
• Picture based eBook (PDF) - available for download
• Subject purchased once cannot be cancelled