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?
    Power Query is the most important data analysis tool since PivotTables. It allows you to clean, reshape, and combine your data with ease, no matter where it comes from.

    Introducing Power Query Academy

    Until now, building Business Intelligence solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used. And updates have been tedious and error prone.

    Learning to use Power Query means less time spent manipulating data ...
    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 09: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

    pinarello

    Get a table from each Excel file in folder | speed up the process

    I have now tested this with a directory containing more than 1,000 workbooks. When I create a list of contents with the command "Excel.Workbook",...

    pinarello Today, 09:25 AM Go to last post
    kenabulli

    Timeline does not put in all my 3 pivot tables

    Hello,

    Would need help with this. Was trying to make the timeline to accommodate all 3 pivot tables in "overall view" sheet. When...

    kenabulli Today, 07:08 AM Go to last post
    marcob8986

    Get a table from each Excel file in folder | speed up the process

    Thanks for Text.Upper trick!...

    marcob8986 Yesterday, 04:37 PM Go to last post
    AliGW

    Tracking numbers in a row & counting them in columns

    Glad to help. ...

    AliGW 2021-04-20, 11:03 AM Go to last post
    Enigma909

    Update

    The problem I am having is that I have 80 k rows + and that I need to code them on names and not on cells. The Formula would work perfectly if dont for...

    Enigma909 2021-04-20, 09:31 AM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 05:33 PM.
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