Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Video Courses

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • Video Courses RSS Feed

    Power Query Academy 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Power Query Academy

    Power Query Academy

    COURSE DESCRIPTION

    What is Power Query?
    Only the BEST tool for business users since PivotTables!

    Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.

    Until now, building BI solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, ...
    Read More Read More

    Dimensional Modeling for the Excel and Power BI Pro 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Dimensional Modeling for the Excel and Power BI Pro

    Dimensional Modeling for the Excel and Power BI Pro

    COURSE DESCRIPTION

    What is Dimensional Modeling and why should you care?
    The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years. There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn’t scale to multiple data source tables. And worse, it actually kept you from learning the terms to scale your own knowledge.
    ...
    Read More Read More

    Microsoft Excel - Basic & Advanced 


    Microsoft Excel - Basic & Advanced


    COURSE DESCRIPTION

    Looking for an Excel course online to improve your skills and save you time? Ken Puls has worked with a company called GoSkills to help design and build Basic and Advanced Excel, an online training course that can quickly get you up to speed with ...
    Read More Read More

    Microsoft Excel - Basic 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - Basic


    COURSE DESCRIPTION

    New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to design and build a targeted Excel course which is offered in an online format.

    This online course is designed to give you a solid foundation in the basics of Excel.

    Supports Excel for Windows 2010, 2013, 2016, 2019, Microsoft 365. Also available: Excel ...
    Read More Read More

    Microsoft Excel - Advanced 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - Advanced


    COURSE DESCRIPTION

    Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course Ken Puls has built with GoSkills will help you learn intermediate and advanced Excel techniques.

    Supports Excel for Windows 2010, 2013, 2016, 2019, Microsoft 365. Also available: Excel Advanced for Mac.

    In 28 engaging lessons you will ...
    Read More Read More

    Microsoft Excel - PivotTables 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - PivotTables


    COURSE DESCRIPTION

    New to Pivot Tables or want to get more out of them? Ken Puls worked with a company called GoSkills to design and build this online course to give you a solid understanding of Pivot Tables, taking you from novice to ninja!

    Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way.
    ...
    Read More Read More

    Microsoft Excel - Macros & VBA 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - Macros & VBA


    COURSE DESCRIPTION

    Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course that Ken Puls designed and built with a company called GoSkills, ...
    Read More Read More

    Excel Dashboards 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2020-10-29 10:51 PM

    Excel Dashboards


    COURSE DESCRIPTION

    Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. Ken Puls has worked with a company called GoSkills to help design and build and online course that will teach you the data visualization skills ...
    Read More Read More

    Excel Power Query 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - Power Query


    COURSE DESCRIPTION

    So you’ve impressed your coworkers with your encyclopedic memory of formulae, become a Pivot pro, and started working IF statements into regular conversation. Now what? We say, Power Query. In a world where data is king, you should know how to work with and understand it – and this tool helps you do just that.

    In this Power Query online course Ken Puls has designed and built with a company GoSkills, you will learn the BI (Business Intelligence) process of importing data, appending and merging tables, conditional logic, data transformation, and organization. The course starts with the basics of Power Query, and works its way up. This means that you’ll be a pro in no time, even if you’re a beginner with the tool. ...
    Read More Read More

    Excel Power Pivot 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Microsoft Excel - Power Pivot


    COURSE DESCRIPTION

    Are you ready to turbocharge your PivotTables? Power Pivot is a free Excel add in that allows you to perform powerhouse data analysis and modeling to make intelligent business decisions.

    This Power Pivot online training, which Ken Puls has developed with a company called GoSkills, will help you step up your game and take your skills to new heights.

    If you aren't familiar with this amazing tool, here are four reasons you will want to learn Power Pivot:

    1. Power Pivot makes analysis easy. You can output data visually to
    ...
    Read More Read More

    Power BI 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles

    Power BI


    COURSE DESCRIPTION

    Make your data come to life with beautiful, interactive reports in Power BI. Ken Puls has worked with a company called GoSkills to help design and build an introductory course which is offered in an online format.
    ...
    Read More Read More

  • MVP Logo
  • Recent Forum Posts

    lmuhr

    here's my example

    here is the example:
    in combine_query.xlsx I am trying to combine all tables (3 per sheet) from all sheets (2 per file) from all files (2: source_a.xlsx,...

    lmuhr Today, 09:48 AM Go to last post
    pinarello

    load, transform and combine multiple tables

    No helper can work out solutions and test them with a picture. Or do you expect helpers to create an appropriate data model to be able to help you? That's...

    pinarello Today, 08:51 AM Go to last post
    Pecoflyer

    Macro that concatenates two cells, references a Date and then copy pastes value into

    Hi and welcome
    Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...

    Pecoflyer Today, 08:35 AM Go to last post
    rj1600

    Macro that concatenates two cells, references a Date and then copy pastes value into

    Would love some help writing this macro
    i tried attaching a file with more explanations within the file if it helps make it clearer. (in yellow...

    rj1600 Today, 03:08 AM Go to last post
    lmuhr

    load, transform and combine multiple tables

    I am trying to combine data from tables (formatted as tables) that have identical structures. there are multiple tables per sheet and multiple sheets...

    lmuhr Yesterday, 11:14 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 10:21 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it