Search Results

Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more. Excel Power Query has powerful text transformation options.

It’s one thing to have to sit through a boring presentation. It’s quite another to give a boring presentation. The solution is a simple roadmap. Discover how you can add road-maps to your presentations.

The merge shapes tool allows you to create a professional PowerPoint presentation. This way you can create custom shapes and even insert an image into a shape. Using Intersect or Fragment options you can also create custom PowerPoint typography.

Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose – just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.

Quickly learn how to use PowerPoint’s Slide Zoom feature to make more exciting and dynamic PowerPoint presentations. Take a look at this “before” and “after” slide presentation. What a difference a small feature can make!

Choosing the right Chart animation in PowerPoint is the secret to a professional presentation. In this quick tutorial find out how to link your Excel chart to PowerPoint and how to animate the graph to support your story.

Learn how to quickly transform boring bullet points into text that your audience pays attention to. You’ll also learn how to create professional transitions and animations with the new morph feature. And guess what? You can now morph between two different objects. It’s really smooth. Check it out.

Find the links to helpful and free Excel tutorials all in one place. These include videos, articles and downloadable Excel files. Whenever you get stuck, refer to this list.

ONLY UNTIL Dec 2nd.
Save big on Excel, Power Query, Pivot Tables, VBA and Power BI courses. Lifetime and Yearly access available.

Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial shows you what organizational data types are and you can set them up from scratch.

In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.