Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 

Advanced Excel Crash Course

Learn time saving advanced Excel concepts.

Advanced Excel Crash Course

Learn time saving advanced Excel concepts.
74
Views
1
Save
8:33:07
Share the link to this class
Copied

About the Class

Advanced Excel remains one of the most extensive pieces of software used in workplaces around the world.

In this course, you will build on the strong foundations of Excel at all the following levels, i.e., basic, intermediate Excel skills.

Why choose our Advanced Excel crash course?

  • Automate your routine
  • Learn industry best practices, shortcuts, and tips and tricks to get things done and become 4x faster
  • This course will help you create efficient workflows without any coding involved
  • The modules are prepared to understand the need and requirement of the learners and will help them create workflows with ease
  • The course and study materials are available at a reasonable price
  • Self-paced online course, which you can view at your comfort
  • Lifetime access to each of the videos present the course

Who should take this course?

  • Professionals working with a large amount of data
  • Somebody looking to gain a tangible skill on your resume or gain a competitive advantage over your peers
  • An analyst or the ones who work in consulting, management, or supervisory roles
  • Graduate students who aspire to become investment bankers, financial advisory professionals, consultants, etc.

What will you learn in this course?

  • Learn to become an advanced excel user
  • Learn to reduce the complexity of spreadsheets
  • Learn to manipulate data with calculations
  • Learn to save time using excel tricks
  • Learn to automate tasks using excel
  • Learn to create dynamic reports
  • Learn to unlock the power of dynamic formulas
  • Learn to make custom formulas/functions
  • Learn to conquer logical operators
  • Learn to set up special commands
  • Learn to build valuation models
  • Learn to apply easy coding techniques
  • Learn to use pivot tables
  • Learn to build spreadsheets
  • Learn to master unique tips

Class Requirements

  • You should have any version of Microsoft Excel installed on your PC/Mac. The course works on all Microsoft Excel versions 2003, 2007, 2010, 2013, 2016. Of course, the newer, the better, but some features work the same in all the versions.
  • You should have a basic understanding of Microsoft Excel because we'll take you to the advanced level in this Excel crash course.
Signup to access the class
Unlimited Access to All Classes

What's included in the class?

 133 video lessons
 1 document

Class Contents

Class Authors

Yoda Learning

Director, Yoda Learning | Previously J.P. Morgan, Futures First, KPMG
Share the instructor profile
Copied

I have tried three work profiles in 4.5 yrs. before I settled on the fourth one (9.5 yrs). 

I transformed from a College Fresher to a polished professional by working for a Big Four (Audit). I traded Interest Rates Futures & Options and learnt what is greed, fear and stop loss. I worked for an I-Bank and understood how to pitch for new business.

The fourth assignment - my own venture. Theme - Corporate Training & eLearning. It taught me a lot in human psychology, new technologies, know-how of diverse industries, communication, interpersonal skills, team building - and most importantly - "Stay Hungry - Stay Foolish".

Problems we solve @ Yoda Learning Solutions:

1. Make classroom training programs 3-5x time more effective - by creating an ecosystem of learning aids such as pre-training prep videos, post-training recap videos, "non-Google searchable" case study based assessments, 1-pager cheat sheet, picture based eBook.

2. Make elearning modules (a) shorter in duration (45 mins. video courses broken in 5-7 mins video) with better planning and (b) more engaging with animations, annotations, smart editing. This ensures 5-8x times better completion rate. We believe in creating a "pull" from learners rather than rely on L&D's "push".

3. Heavy focus on Tips & Tricks with "quick wins" and actionable learning.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Topics: Power BI, Alteryx, Spotfire, Tableau, SAS, Knime, Excel Analytics, VBA Macros, Financial Modeling
--------------------------------------------------------------------
www.yodalearning.com | www.excelnext.in | www.excelsuperstar.org

1
Save
74
Views
This class has not been saved

Sign Up