Get a month of TabletWise Pro for free! Click here to redeem 
TabletWise.com
 
36
Views
8:33:07
Share the link to this class
Copied

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

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.

About the instructors

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

All Classes
Free for 30 Days
   The video is currently being processed.
   An error occurred while uploading the video. Please upload another video.
   Please upload the required file.
Quiz: #TITLE#
Questions: #QUESTIONS_COUNT#
Quiz: #TITLE#
Question /#QUESTIONS_COUNT#
Quiz: #TITLE#
Result: You correctly answered out of questions. Result: You correctly answered out of question. Result: You correctly answered out of questions attempted. Result: You correctly answered out of question attempted. Result: You did not attempt any question.
0
Saves
36
Views
This class has not been saved

Sign Up