Posts - 6 results

  • Udemy – Ultimate Microsoft Excel Course: Beginner to Excel Expert [100% OFF]

    Posted on 14/01/2019 by | 0 comments

    Course Description

    ★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★

    It is time to master Excel. If you are a beginner and want to develop your Excel skills or have the desire to be an Excel guru, you have come to the right place.

    This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

    This course is perfect if you;

    • Use Excel everyday but want to improve your all-round skills and become the office expert
    • Have a basic knowledge but want to take the plunge and develop your Excel muscles
    • Learn all the essential skills in Excel to help get a new job or promotion

    The course has been designed as a one-stop shop for all of the essential skills of Excel. It is very comprehensive and you can come back again and again to re-visit material.

    The course will be consistently updated with the latest features and techniques of Excel. With big plans for Excel in 2019 and amazing features on the horizon – you can be sure to find lessons added to this course so that you stay ahead of the game.

    I teach in a hands-on way with unique examples demonstrating all of the essential features of Excel. You will not only understand HOW these Excel tools and formulas work, but see examples of WHY they are so awesome.

    By the end of the course you will be a confident user of Excel with the skills to progress your career further, or become the office Excel guru.

    During the course you will learn;

    • To use the power of PivotTables to summarise large amounts of data and produce dynamic reports in minutes.
    • Be confident in using over 30 of the most important Excel functions including INDEX, VLOOKUP, MID, IF, MATCH and COUNTIF.
    • Create charts in a flash that visualize data effectively.
    • Conditional Formatting to highlight data comparisons, progress and issues.
    • Utilise the awesomeness of Power Query to import, shape and transform data.
    • Clean up messy data with formulas, Flash Fill and other Excel features.
    • Understand the data model in Excel and PowerPivot.
    • To use macros to automate time-consuming tasks.
    • And much much more.

    Why learn from me?

    I have been training business all around the world on how to get the most out of Excel for over 20 years.

    Learning and teaching Excel is my passion. I am a full time Excel trainer and consultant, so every day I am in the thick of the action teaching others to master Excel.

    I set up the Computergaga blog and YouTube channel 10 years ago where I am lucky enough to have taught millions of people across the globe to increase their skills and overcome everyday real world Excel problems.

    The course includes the exact files that I use in the lessons to download and follow along, lifetime access and 1 on 1 instructor support every step of the way.

    Don’t delay. Take action. Grab a coffee and let’s get started.

    Your journey towards mastering Excel starts today.

    Read more
  • Udemy – Complete Excel 2016 – Microsoft Excel Beginner to Advanced [100% OFF]

    Posted on 07/08/2018 by | 0 comments

    Description

    Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

    Excel is one of the most important skills in today’s job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

    If you need to know Excel, you’re in the right place. 

    This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

    My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

    This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn’t cover Mac-specific keyboard shortcuts and interface.

    We’ll start at the very beginning, with opening and saving a worksheet in Excel.

    I’ll show you what all the tools do and walk you through each Excel skill that you need to know.

    I’ll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I’ll teach you amazing keyboard shortcuts to make your work faster and more productive. You’ll learn how to record macros so you can do a whole series of actions with the just click of a button.

    We’ll keep going until you’re a pro at Excel.When you finish this course, you’ll know more than most people who use Excel at their job every day.

    Here’s some of what you’ll learn.

    • Creating spreadsheets in Excel
    • Saving your work where you can find it
    • Working with multiple workbooks in Excel
    • Formatting and printing
    • Importing data from CSV files, Access and the web
    • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others
    • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more
    • Creating tables
    • Sorting and filtering your data
    • Creating pivot tables
    • Creating pivot charts from your pivot tables
    • Fun New features for Excel 2016
    • Keyboard shortcuts to make your work go faster
    • How to record basic macros to automate repetitive tasks
    • A whole lot more

    The course comes with a certificate of completion, a full 30-day money back guarantee, and I’m always available to answer questions or share additional resources if you get stuck.

    Thanks for checking out my Biggest Excel Course to date.

    I’ll see you in there!

     

     

    Udemy Coupon Code : https://www.udemy.com/microsoft-excel-2016-complete-beginner-to-advanced-excel-course/?couponCode=NEWEXCEL2016COURSE

     

     

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Excel 2016 Bootcamp – Zero to Hero Training [100% off]

    Posted on 04/07/2017 by | 0 comments

    Microsoft Excel 2016 Bootcamp - Zero to Hero Training
    Description

    Hi there, Welcome to this Microsoft Excel BootCamp. Together we’re going to learn how helpful Excel is in nearly every part of our professional lives.

    This course is for beginners. You do not need any previous knowledge of Excel. We will stick closely to the powerful built in features of Excel and will not get bogged down in confusing code & complicated formulae.

    This training course is project based. We start with a simple company branded invoice and explain how to calculate totals & tax. Using a complex and messy spreadsheet we will clean it up using Excels automatic features. With our new tidy data you’ll learn how easy pivot tables can turn long and hard to understand information into simple tables & beautiful graphs. Before you’re finished you’ll be making helpful drop down menus to help you fill out & sort your financial data. . You will learn how to turn uninspiring profit & loss statements into a good looking, easy to use documents.

    Class Projects

    • Create a quote & invoicing form.
    • Cleaning & formatting messy imported data.
    • Inventory spreadsheet.
    • Pivot tables
    • Regional Sales Report
    • Profit & loss spreadsheet.
    • GST & Tax calculations
    • Graphs for use in Word, PowerPoint, InDesign & Illustrator
    • Creating spreadsheets that work within Word documents.

     

     

    Udemy Coupon Codehttps://www.udemy.com/microsoft-excel-2016-bootcamp-zero-to-hero-training/?couponCode=UDEMY_FB_EXCEL

     

     

     

    Share with your friends :

    Read more
  • Udemy – NEW! EXCEL 2016: Excel from beginner to professional [100% off]

    Posted on 29/05/2016 by | 0 comments

    NEW! EXCEL 2016: Excel from beginner to professional

    Course Description

    By Completing this course, you will receive a verifiable Certificate of Completion.

    This course has cut down on the fluff and empty space to keep it shorter, but still cover a wide range of topics. Designed for people starting out with Excel, it also covers some of the more complicated and important areas like Pivot Tables.

    This Excel course is recorded completely using Excel 2016, the latest version of Excel offered in the Microsoft Office 2016 suite.

    Some of the topics include (but not limited to)

    • Creating your first workbook
    • Referencing from other sheets within a book
    • Quick Charts
    • Quick Sorting
    • Flash Fill
    • Named Ranges
    • Excel Sheet Management (moving, colouring, creating)
    • Creating 3D maps using address data in a list
    • Popular Excel Functions like SumIf, VLookUp, Left, Right, Mid, Len and more
    • Power Excel functionality like nested formulas
    • Using slicers to quickly sort and make spreadsheets look good
    • A complete set of Pivot Table videos

    I aim to add 4 new lectures every month to the course, and would love to have your feedback. So once you have signed up and completed the training, let me know what you would like to learn next!

     

    Udemy Coupon Codehttps://www.udemy.com/excel-with-excel-2016/?couponCode=DISCOUNTSGLOBAL0516

     

     

     

    Share with your friends :

    Read more
  • Udemy – Microsoft Excel 102 – Intermediate Level Excel [90% off] Worth $99!

    Posted on 07/02/2016 by | 0 comments

    Course Description

    Go Beyond the Basics

    Ready to take your Microsoft Office Excel skills to the next level? Then you’ve come to the right course. Enroll now and you will receive step by step mentoring on mastering Microsoft Excel at an intermediate level and beyond. You will learn how to work with some of the most powerful tools Excel has to offer.

    Using my 10+ years of Microsoft Excel training I will guide you through these tools preparing you for the most advanced features used my Excel office workers.

    • Mastering Excel Lists (Sorting, Filtering, Subtotals, and more)
    • Creating Powerful Excel Functions in order to Summarize List Data
    • Become an Excel Report Creating Pro with Excel PivotTables
    • Harness the Power of an Excel Add-In, PowerPivot to Create even more robust PivotTables
    • Work with Data from other Sources through Import and Export Commands

    At completion of this Excel Intermediate course you will have mastered the above mentioned tools and more, supercharging your Excel knowledge and skills to a whole new level of expertise.

    Each section also includes a quiz to test the knowledge you will gain and exercise files for you to download and practice with. These are the same files that are used in the video lectures.

    So, what are you waiting for, enroll now and take the next step in mastering Excel on your way to becoming an Excel Guru!

     

    Udemy Coupon Codehttps://www.udemy.com/microsoft-excel-102-intermediate-level-excel/?couponCode=BlackHat-01

     

     

     

    Share with your friends :

    Read more
  • Udemy – These 5 Excel Tricks Will Save Your Job [100% off]

    Posted on 23/08/2015 by | 0 comments

    Course Description

    Works with any Excel version!

    Would you like to be a professional office worker? Work like a pro?
    Learn how to save your job with the 5 best practice Excel tricks professionals use every day! If you know the basics and how to actually do them, the next step towards a better job will be only a matter of time!

    This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!

    What you will learn

    • The basic way to bring data together
    • Why conditional background colors are so cool
    • Sum up parts of data under a certain condition (sounds complicated, but it’s not!)
    • Compare two tables – line by line – but in a second
    • Why so many people use pivot tables

    30 day full refund policy + no questions asked! (If bought via Udemy website. If you bought the course via App and are not satisfied, please contact me directly.)

     

     

    Udemy Coupon Codehttps://www.udemy.com/5-excel-tricks-that-save-your-job/?couponCode=FREEBIE

     

     

    Read more