• Microsoft Excel - Basic & Advanced

    Microsoft Excel - Basic & Advanced


    COURSE DESCRIPTION
    Looking for an Excel course for beginners to experts? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to train on the specific topics you need to get the most out of Excel. It has something for everyone, covering beginner, intermediate and advanced lessons in Excel.

    In 49 engaging lessons you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

    Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Excel Ninja! Learn more about how a GoSkills Excel certification can boost your career.

    REGISTRATION
    For full course details and to register, visit the GoSkills website.


    Even better, there's even a discount available to you if you're ready to sign up. Just enter the code XLGURU66 at checkout and you end up getting the course at 1/3 the regular price. Click the banner below to get started, or to check out the sample videos available:

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Murray_Sparkles

    VLOOKUP Formula help!



    Here is a semi-updated version with some more details on the recall sheet and how I would *Like* it to work.

    Thank you again...

    Murray_Sparkles Today, 01:02 AM Go to last post
    Murray_Sparkles

    VLOOKUP Formula help!

    Thanks Ali, I will try to come up with a small mock-up to help clear things up. I apologize for any confusion! I am very new to Excel, really only using...

    Murray_Sparkles Today, 12:47 AM Go to last post
    navic

    Conditionnal Formating

    Select all Date cells in 'I' column. Apply CF and formulas

    - Yellow

    Code:
    =OR(TODAY()-$I2=1;TODAY()-$I2=2;TODAY()-$I2=3)
    - Green...

    navic Yesterday, 08:39 PM Go to last post
    Jlamarre

    Conditionnal Formating

    The only date that should be taken in consideration is the "I" column. All other dates should not be taken in consideration.

    In...

    Jlamarre Yesterday, 07:21 PM Go to last post
    navic

    Conditionnal Formating

    It's still confusing.
    If I understood you well the Subtraction between two dates in the example is the next

    - Red
    Today Date...

    navic Yesterday, 06:31 PM Go to last post