• Live Training RSS Feed

    by Published on 2019-02-19 09:08 PM



    Transform the way you work with data forever! If you need to learn one skill in Excel today, it is how to work with Power Query. Not only will it change the way you "Get & Transform" data in Excel, but it's also the system used to collect data for Power BI Desktop, meaning these skills are transferable to other programs. Let us show you how to master your data in this small group hands-on ...
    by Published on 2017-06-28 11:34 PM

    Course Description

    The sad reality is that not all data we need for our reports is stored in nicely curated databases. While some of the data may be, the reality is that we also need to piece together data provided in text files, Excel files, web pages and even the body of emails in order to build the complete business intelligence solutions we need. Until now this has been a ...
    by Published on 2016-12-01 01:00 PM


    Course Description

    For years, Excel has been the business intelligence tool of choice for accountants and business analysts around the world. In July 2015, however, Microsoft released a free software package that has become the hottest software commodity in the business intelligence landscape: Power BI Desktop.

    Join us for an intensive three-day, hands-on boot camp that will allow you to hit the ground running with Power BI. Geared specifically towards Excel users who have never used Power BI, this course takes you from opening the Power BI Desktop for the first time to publishing live, ...
    by

    Course Description

    In this hands-on course we are going to look at the most important Excel features that will turn you into a quick and efficient data master in Excel.

    Most users missed the implementation of the Excel Tables feature that happened in Excel 2007. It stealthily slid its way into the product with very little fanfare, yet it is one of the most important architectural features that you can implement to enforce data integrity in your solutions. Its with that feature well start, showing you how and why this little feature should form the foundation of every solution you build.

    ...
    by

    Course Description

    How many times have you begun building a spreadsheet, only to have it evolve on you based on requests from users and managers? While this is a great compliment to your work and skills, these changes can cause our spreadsheets to grow and change to the point where we introduce errors and instability very easily. ...
    by Published on 2011-08-22 07:44 AM  Number of Views: 32855 
    The tools within Microsoft Office are extremely powerful, and already exist on your systems... but do your staff know how to use them?

    The biggest issue facing corporate efficiency today is not the inability to afford powerful systems, but rather the lack of recognition of what you already have and how to leverage it. Does a knowledge gap exist in your staff's Office skill-set? Would you like to fix it?

  • MVP Logo
  • Recent Forum Posts

    TJDetweiler

    Specify which slicers are reset

    I have inherited a 2010 workbook that I have been told needs to stay in this version, as well as add a 5th slicer ( YAY! ). What I initially looked for...

    TJDetweiler Today, 07:53 PM Go to last post
    mikemck

    Power Query to move 24 values

    Much appreciated. I'll check out Gil Raviv's book as well. I'm making progress, but I have a very long way to go.

    I need to ask for help...

    mikemck Today, 06:31 PM Go to last post
    MOUSA

    Vba code

    Hi
    i am new to vba , kindly assist me getting code for the below task.


    1. Want to auto save worksheet with another duplicate...

    MOUSA Today, 02:26 PM Go to last post
    AliGW

    Power Query to move 24 values

    (With apologies to Ken), there is another, more recent book really worth getting by Gil Raviv - if you find his Datachant blog, you can find out about...

    AliGW Today, 02:00 PM Go to last post
    mikemck

    Power Query to move 24 values

    That is just incredible. I have been working my way through M is for Data Monkey, and have been trying to get this done for way more hours than I care...

    mikemck Today, 01:03 PM Go to last post