Posts - 70 results

  • Udemy – Easy Excel Dashboards, Models, Visualizations & Power Query [100% off]

    Posted on 17/04/2018 by | 0 comments

    Description

    Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work.

    Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance.

    Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade.

     

    Udemy Coupon Code : https://www.udemy.com/easy-excel-dashboards-models-visualizations-power-query/?couponCode=FBFREE

     

     

    Share with your friends :
    Read more
  • Udemy – Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel [100% off]

    Posted on 23/11/2016 by | 0 comments

    Excel VBA Blueprint: Build 9 VBA Macros & Automate Excel

    Course Description

    Are you tired of the same long, boring days creating dashboards, charts and Vlookups while barely having time to do anything else?

    Wouldn’t it be cool if you could automate all these tasks, spend less time in front of the computer and more time advancing your career,   scaling your business, or doubling your salary?

    Why Learn VBA?

    Excel VBA can completely skyrocket your productivity – if you learn how to automate Excel processes you will achieve the same results in 50% of the time.

    However, it is not something easy to learn – it will take you countless hours in front of the computer. The good news is that with the right approach you can shortcut that process and learn the fundamentals that will give you 80% of the skills with 20% of the effort.

    If you learn how to program in Excel properly, you can:

    • Have one task always execute the same way with the push of 1 button
    • Perform that task at a much higher speed than if you were to do it manually
    • Ensure 100% accuracy
    • Enable people that don’t know much about the task to execute it the same way as yourself
    • Differentiate yourself at the workplace by enabling Excel to do operations that might seem impossible to others
    • Sit back and relax while letting your macros handle the complex tasks that take up computational power and a lot of time

    The Excel VBA Blueprint

    That’s why we created the Excel VBA Blueprint. Rather than taking you through a long list of boring features, we teach you 9 specific VBA Macros that you can apply straight away.

    Tired of time consuming deeply nested formulas? You’ll learn how to create your own tailor made Excel functions

    Want to automate your reporting process? Learn how to automatically send emails directly from Excel

    How about upgrading your charts? Learn the simple code to create charts that are customisable through a dropdown menu.

     All of this, and much more.

    When building this course, our main focus was practicality.  That’s why:

    • You get class test scenarios and solutions at every Section end so that you can test your newly learned abilities
    • You get every spreadsheet at every step along the way – this way you can always check your code for accuracy
    • Each section is a scenario for a particular Macro – this is our version of learning by doing!

    If you want to learn the VBA hacks that will skyrocket your productivity, then this course will take you there. Have a look at our free preview lectures, take this course now and join us on this exciting journey!

     

    Udemy Coupon Codehttps://www.udemy.com/excel-vba-blueprint-build-9-vba-macros-automate-excel/?couponCode=UDEMYREVIEW0

     

     

     

    Share with your friends :

    Read more
  • Udemy – Ultimate Beginners Excel VBA Finance Course for Banking [100% off]

    Posted on 14/11/2016 by | 0 comments

    Ultimate Beginners Excel VBA Finance Course for Banking

    Course Description

    This course will provide you with essentials about Visual Basic Applications (VBA) Excel for Finance. VBA is the programming language of Excel and is a fast programming language. When correctly mastered, it can automate almost every task that is required in Banking and Investment Banking.

    By taking this class, you will see that getting a job in investment banking is not just a matter of luck, but of technique and forward thinking.

    This course is best suited for university students who are studying business, finance, accounting, economics or any other finance related programmes.

    This course is also for anyone who is interested in knowing more about the Banking and Finance world, and to know about necessary skills to acquire to get into these sectors.

    No prior technical knowledge is required. The course covers:

    Fundumentals of VBA :

    • Functions, Sub, Variables, Loops, Conditions.

    Real life applications that are used in Banks today

    • Build pricers for options and bond
    • Create Userforms and top-notch charts
    • Link your VBA application to a database
    • Understand the concept of Object Oriented Programming

    Why should you take this course?

    You are a finance student. You are really struggling in finding a good and challenging position in Banking. You would like to start your career with a great asset on your resume and you are motivated to reach that goal.

    You are a banker facing issues with repetitive tasks to run on a daily basis and you want to learn how you could automate all of those tasks in a single process.

    You are already a banking employee, but you are working in a department that does not fit your ambitions, and you would like to join a more challenging department such as front-office, and work in the exciting environment of the trading room. In order to do that you need to prove that you can bring value to the team.

    With this course, you get everything you need to be able to quickly design performant VBA applications.

     

    Udemy Coupon Codehttps://www.udemy.com/ultimate-beginners-vba-finance-course-for-banking/?couponCode=VBA2016

     

     

     

    Share with your friends:

    Read more
  • Udemy – Microsoft Excel 2013 for Beginners: Master the Basics [100% off]

    Posted on 02/11/2016 by | 0 comments

    Microsoft Excel 2013 for Beginners: Master the Basics

    Course Description

    Excel is the most widely used spreadsheet software. Most people have learned to use Excel on their own or at work, learning just what they need to know to do their job. Are you one of those people? Would you like to get more comfortable using this software? Knowing how to use Excel and discovering some shortcuts will help you be more productive at work. These skills might even help you get the job you’ve always wanted!

    Visualize yourself creating spreadsheets that are easy to understand!

    When you have completed this course, you will be able to do just that! You will know how to enter data in your worksheet, use basic Excel functions with confidence, format cells like a pro, and create and format basic charts.

    Why This Course Will Help You

    This course will help you get more comfortable with Excel and be more confident when creating your spreadsheets.

    You’ll pick up shortcuts to improve your productivity with daily tasks. You’ll build a solid foundation of the basics of Excel.

    This course is broken down into short lessons so that you are learning only one concept at a time.

    Impress Your Boss with Your New Knowledge

    You will learn:

    • How to move around in Excel quickly and efficiently
    • How to confidently use formulas and basic functions
    • How to proficiently format cells
    • How to skillfully create and format column, bar, and pie charts

    Lots of Practice

    The Excel file used in the course is provided so that you can follow along with the exercises. You’ll be able to work right along with me to complete each exercise.

    Contents and Overview

    You will start off by learning the parts of the Excel window. You’ll learn how to navigate an Excel worksheet and discover some shortcuts on how to do this quickly.

    You will learn how to use formulas and functions and more shortcuts for entering them.

    You will understand the how to format cells to present your data professionally.

    And you will know how to create the most popular types of charts.

    Take Action Now!

    Enroll now by clicking on the “Take This Course” button!

     

    Udemy Coupon Code : https://www.udemy.com/microsoft-excel-2013-for-beginners-master-the-basics/?couponCode=UDEMYFB

     

     

    Share with your friends :

    Read more
  • Udemy – Excel With Excel Pivot Tables in 1 Hour! [100% off] Worth $99!

    Posted on 11/10/2016 by | 0 comments

    Course Description

    No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this 1 hour webinar tutorial which goes through the most important tools that are available in an Excel Pivot Table. The course is designed for Excel 2007, 2010, 2013 and 2016.

    In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.

    What you will learn?

    • How to set up your data and create a Pivot Table in less than 3 minutes which will increase your efficiency!
    • How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Pivot Table, taking your analytical skills to another level!
    • How to create an Interactive Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management!
    • Pivot Table tips & special Bonus material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!
    • Scroll down this page to view the full Course Curriculum…

    What you get?

    1. An hour long Pivot Table tutorial that touches on the most important tools you need, in order to get you up and running and start applying to your job straight away…with CONFIDENCE!
    2. BONUS Pivot Table tips & tricks video tutorial;
    3. All tutorials come with downloadable videos in mp4 format, so you can watch while you are offline or traveling;
    4. Access to the Excel workbook that is shown in the training video, so you can follow along and practice the new tricks learned;
    5. High Definition quality videos viewable from your PC, laptop, tablet or mobile phone.
    6. LIFETIME online access, anywhere in the world, 24×7!
    7. My personal support if you ever get stuck with a Pivot Table problem;
    8. When you have finished with this course you will receive a Certificate of Completion, which you can add to your resume!

    What some of the thousands of students who have viewed this tutorial have said…

    You taught me many things that I hadn’t known (and I’m not a beginner…) – Leigh, Birmingham

    Thank you so much! I have learned a lot, this will wow my boss. – Tammy – New York

    A really useful webinar, which has taken me up a level from being an existing basic pivot table user to advanced level, if not quite an expert. – Peter – Adelaide

    The webinar was fantastic! I had quite a few jaw-dropping moments! – Tan – Livingston

    I would like to say I have been wary and ‘scared’ of Pivot Tables for years. No longer! – Mary – Toronto

    That was an awesome hour of my time well spent. – Carlos – Madrid

    Thank you John, great tutorial. You certainly packed a great deal of information into that hour. Bernard – Michigan

    Thank you so much for this session. I am new to creating pivot tables but you made it easy to understand. Teresa – Vancouver

    I am one of the more advanced users in our organisation but I have realised that I knew next to nothing.Jocelyn – Melbourne

    Not a question but just wanted to say in the space of 9 minutes I’ve learnt a lot. Richard – London

    Wow! No question, just wow! Amazing! John – Hamburg

    Simply awesome, with in an hour I found myself a Pivot expert – Natalie – Boston

    I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way and I want to help you out as well because you deserve it! These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

    So go ahead and learn from the following Pivot table subjects and click the TAKE THIS COURSE button, top right, NOW… every hour you delay is delaying your professional progress

     

    Udemy Coupon Codehttps://www.udemy.com/excel-with-excel-pivot-tables-free-tutorial/?couponCode=UCOURSECOUPON

    or

    Other Coupon Codehttps://www.udemy.com/excel-with-excel-pivot-tables-free-tutorial/?couponCode=PIVOTSTUDENT

     

     

    Share with your friends :

    Read more
  • Udemy – Excel Hacking: Real Strategies for Excel Mastery + Templates [100% off]

    Posted on 25/08/2016 by | 0 comments

    Course Description

    Top Udemy Instructor with 8 courses, 5,000+ Students and over 200 Reviews!

    Course Up to date as of July 2015

    Have you ever been confused by the sheer complexity of Excel? Ever struggled with an annoying problem that you couldn’t solve fast enough? Or maybe you’re just looking to start learning to use Excel and master it quickly…

    The truth is a lot of the Excel Trainings out there throw a bunch of formulas at you and teach you how to use them. However, they neglect to tell you their practical applications and what the most important shortcuts are.

    A few years ago I was an Excel rookie. I thought I knew how to use it (what’s so hard right?), but found out about my limitations as soon as I started a job in a Financial Controlling role. Everything that I have learned in Excel came as a result of the challenges that I faced on the job and my relentless drive to discover solutions that were more and more efficient.

    The truth is I didn’t have one of the most efficient learning curves because nobody told me what the most efficient path to mastering Excel was.

    What do experts do on a daily basis? What are the key formula combinations for particular situations? What sort of tips & tricks do they use to be faster & more efficient when using Excel?

    Those questions led to this course. I bundled all of my knowledge in a way that prioritises the most important Excel Hacks. This will ensure that you will get to your best Excel level in the fastest possible time. Doesn’t that sound better than sitting through boring Excel Training Seminars for 8 hours during a whole day?

    Here’s what this course covers:

    1. The Excel Essentials – discover the quickest ways to navigate and manipulate data in Excel so that you can master the basics straight away
    2. 20+ Quick & Killer Hacks – These are individual lectures focused on particular Excel hacks which boost your productivity & use of Excel
    3. Bulls-Eye Formula Blueprint – master Excel Formulas by shifting the focus away from HOW they work to WHAT their usability is in practical scenarios

    And much, much more. Just have a look at the Learning Outcomes.

    I’ve also compiled a list of 3 Bonuses available to you straight away:

    1. Ready-Made Templates -these are ready for you to use at your leisure & include Balance Sheets and Cash flow Statements amongst others
    2. The Lightning Speed Shortcuts Tutorial: a PDF with all the essential Keyboard Shortcuts + an entire Section on how Investment Bankers use Excel without even touching the Mouse
    3. An Entire Section about how to use a secret ingredient that will revolutionise your Chart creation from Excel to PowerPoint

    The Excel Mastery Guarantee

    I’m extremely confident that if you take action and follow these steps, you will revolutionise your Excel skills at a very fast pace. However, if for any reason you’re not satisfied with this course, then I will personally jump on a 30 Minute Skype Call with you and help you get to the next level.

    Nobody can give you a Magic Pill for learning Excel – it takes time & practice. However, if you’re aware of the most important shortcuts from the beginning, that will end up saving you countless hours of your precious time. Take this course now and join me in this exciting journey!

     

    Udemy Coupon Codehttps://www.udemy.com/excel-hacking-real-strategies-for-excel-masterytemplates/?couponCode=Freeff

     

     

     

    Share with your friends :

    Read more
  • Udemy – Excel 2016 Intermediate Training Course | Video Tutorial [100% off]

    Posted on 20/07/2016 by | 0 comments

    excel 2016 intermediate training course | Video tutorial

    Course Description

    Microsoft Excel 2016 Intermediate Training Course

    This course is designed for people with some limited experience of using PowerPoint 2016.  It will also suit people who has studied my Excel 2016 Foundation level course.

    The course starts by looking at Excel 2016 Setup & Printing Issues

    We then start looking at Excel Functions and Formulas including Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions and finally Database Functions

    Next we see how to create and use Named Ranges within an Excel worksheet.

    The next chapter shows you how to use Cell Formatting techniques.

    Then we see the various Worksheets manipulation techniques.

    Finally we look at the use of Excel Templates and the Excel Paste Special Options.

     

    Udemy Coupon Codehttps://www.udemy.com/excel-2016-intermediate-training-videos/?couponCode=EX2016Intermediate

     

     

     

    Share with your friends :

    Read more
  • Udemy – Excel 2016 Foundation Training Course | Video Tutorial [100% off]

    Posted on 20/07/2016 by | 0 comments

    Excel 2016 Foundation Training Course | Video Tutorial

    Course Description

    Excel 2016 Foundation Training Course

    This course is for Excel beginners.  We start by looking at the various Excel Selection Techniques and then see how to use these techniques for Manipulating Rows and Columns and also for Manipulating Cells and Cell Content

    Next we look at how to use Excel 2016 Worksheets.

    The next few chapter cover things such as Font Formatting , Alignment Formatting, Number Formatting and Freezing Row and Column Titles

    Then then examine Formulas and Functions.  Next we see how to create and format Charts within Excel 2016

    Finally we have a look at options for customizing Excel 2016

     

    Udemy Coupon Code : https://www.udemy.com/excel-2016-foundation-training-video-tutorials/?couponCode=EX2016Foundation

     

     

     

    Share with your friends :

    Read more
  • Udemy – Become an Excel VBA Troubleshooter: Save Time and Earn More [100% off]

    Posted on 01/07/2016 by | 0 comments

    Become an Excel VBA Troubleshooter: Save Time and Earn More

    Course description

    *** Course last updated on 25th June 2016 ***

    This course is designed to take your basic VBA skills and quickly move you into the intermediate category.  You can probably already put together “most of the way there” programs.  These will usually have some form of problem (even if you don’t realise it).  They might have calculation errors, be a bit slow or break under specific use cases.  This course will teach you to track down and fix these problems … and then how to restructure your code to prevent such problems and handle run time errors in an effective way.

    A VBA Troubleshooter is a valuable team member.  You will quickly find people coming to you for help and advice.  Your CV will look much better and it will put in a great position to negotiate a pay rise or even use this as the first step in a new career.

    Some assumptions about you

    Let’s agree that you are highly motivated, want to learn new skills and want to get ahead in life.  Maybe you want to earn more in your current role, maybe you want to enhance your CV or maybe you want to switch careers.  Let’s also agree you are willing to put in the time and effort to learn new skills … yet want to do so in an efficient and effective way.  Finally, let’s agree you believe in getting what you pay for.

    Still with me? Keep reading and see exactly why so many students have already chosen to enrol on this course

    How this course is different

    There are lots of great VBA courses both on the internet and on Udemy.  Many however try to cover a bit of everything related to VBA.  Before building my own course I looked at what was available and made sure I was providing something new and different.  Instead of teaching “a little bit of everything” I listened to my existing students, took the most useful VBA coding skill set and turned it into a full blown course all of its own.

    I don’t aim for the complete beginner (you won’t learn about the basics such recording macros, CELL objects and RANGE objects).  Instead I assume you have some VBA knowledge and want to quickly improve on this by learning some higher level skills.  If you are a complete beginner however, just ask me for a list of resources to get you to the starting point.

    Rather than the usual passive “tell you how to do stuff” method of delivery, my teaching style is very much active – if you are lazy you will still get something out of it … but nowhere near as much as if you put in a reasonable amount of work to do the quizzes and exercises. In addition to all of this my goal is for the course to become a living entity with a “community of students”.  I have a long list of additional material, techniques and examples I plan to add.  I want it to become a reference point for future where you can dip in and out as you encounter new problems,  where you can request a specific topic to be covered and where you can provide the feedback needed to fine tune the course.

    Who will benefit most from the course?

    Almost everyone will gain something but some will gain more than others:

    • Do you get a nice warm fuzzy feeling from those “Aha!!” moments when you understand something new?
    • Are you willing to put in some time and effort to learn new skills?
    • Are you willing to stick up your hand and ask a question … even if you think it sounds silly?

    If you answered “Yes” to at least 2 of these then you have the right attitude and I want you as part of my student community.  I would much rather have a small set of the right students that complete the course and get involved actively. You should enrol on this course:

    • BECAUSE you answered “Yes” to 2 questions from above – you fit my ideal student description;
    • BECAUSE you are driven, motivated, want to get ahead in life;
    • BECAUSE you are willing to work to get what you want from life;

    Frequently Asked Questions

    Q: Why should I pay for a course when there is lot’s online for free?

    A: Very good point.  There are two problems with the free online content.  Firstly, it will take a long time to find what you need.  Even if you do find something it probably won’t be exactly what you want and need modification.  This takes time and time is the only real scarce resource – it’s valuable and you shouldn’t go wasting it.  Secondly, although there is a lot of  good content online there is also a lot of complete and utter s*it£.  If you willing to spend the time finding content, are able to tell the difference between good and bad and able to modify what you find confidently then you don’t need this course anyway.  Otherwise  you can save yourself some time and stress by enrolling.

    Q: Why do you put so much emphasis on exercises and quizzes?

    A: Past experience tells me the best way to lean coding is by doing.  I have taken this principle and used it to create this course.  You will find material in the exercises and quizzes that is not covered in the main body of the course and this is deliberate!

    Q: Why do you not provide solutions to exercises?

    A: There are two reasons.  Firstly, there is often more than one answer to a given exercise.  Secondly, and more importantly, if I do put up solutions then many students will become lazy and simply look at the solutions before attempting exercises.  I don’t want this and instead want to encourage you to have a go yourself first.

    Still unsure? – try it for free!

    I am giving away 30% of my course free as preview lectures.  I am doing this because I believe in the quality of my course, I am confident the previews will prove the course is well worth the price and that once you look at them you will want to buy the full course.

    If that isn’t enough my course is backed by the Udemy 30 day 100% money back guarantee – if you enrol and change your mind you can get a full refund with no questions asked.  Why would I highlight? Because I’m confident that once you enrol you won’t want to give it back!

    Share with your friends :
    Read more
  • Udemy – Advanced Excel: Date Cleaning, Formulas, Tricks and Calcs [100% off]

    Posted on 23/06/2016 by | 0 comments

    Advanced Excel: Date Cleaning, Formulas, Tricks and Calcs

    Course Description

    Before you read what I have to say, see what my students are saying about my courses on Excel:

    “I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.” by Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO) in various companies

    “I thought you knew me – You solved  the exact problem which I face at my office in your course” by Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.

    ——————————————————————————————————————-

    “Date” data type is crucial for every report as lot of important decision making exercises are based on it. Similarly, The aesthetics and design of every report helps read the report better and faster.

    • Concept: How Excel reads date
    • Date formulas & tricks
    • Pivot Table – Grouping based on Dates
    • Formatting tricks
    • Paste Special & Auto-fill tricks

    We have 14 videos of duration 42 mins (in one sitting). Through practical examples, You’ll learn Ninja level application on Advanced Excel: Date Cleaning, Formulas, Tricks and Calcs

    ——————————————————————————————————————-

    Your Question – Why should I take this mini-course on Excel?

    Our Response 

    E.g.

    ——————————————————————————————————————

    Your Question – So will I learn Pivot table, Vlookup, Sort & Filter?

    Our Response – No. This course covers Advanced Excel: Date Cleaning, Formulas, Tricks and Calcs

    ——————————————————————————————————————

    “The courses are really helpful whether in terms of saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda” by Arundhati Raychaudhuri, Finance Professional, India

    ——————————————————————————————————————-

    Important information before you join:

    • Once enrolled, you have unlimited, lifetime access to the course!
    • You will have instant and free access to any updates I’ll add to the course.
    • I will give you my full support regarding any issues or suggestions related to the course.
    • Guided practice worksheets included for immediate practice
    • Access to all videos 24 x 7 – learn online from anywhere
    • A 30-day money back guarantee (we want you to be 100% satisfied)

    —————————————————————————————————————–

    If you have read this far, next action is JOINING this course. Invest 42 mins (in one sitting) for a benefit of lifetime Ninja status on Advanced Excel: Date Cleaning, Formulas, Tricks and Calcs!

     

    Udemy Coupon Codehttps://www.udemy.com/advanced-excel-date-cleaning-formulas-tricks-and-calcs/?couponCode=FIRST101

     

     

     

    Share with your friends :

    Read more