Excelguru Help Site - Video Courses

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
Power Query Academy

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

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
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

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
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
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
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
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
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
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
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
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:

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

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

Recent Forum Posts

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

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

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

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

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

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