Find files by type, shared by or with me, related to meetings, sent by person or any file anywhere… all using OneDrive and Microsoft 365. Contents Related videos Search everything
Split data in a column into individual words, remove duplicates, remove unwanted characters and count the occurrences of each word. All using the Excel 365 new functions like Reduce, Lambda,
Pivot data using Power Query and Convert flat data with key – value pairs to tabular data. Simplify analysis. Use Power Query – Pivot Column for conversion. Download Sample File
Apply Excel chart templates and customize a chart once. Save as template. Apply it manually or automatically – using a macro. Download macro file from here (zip) Contents Related videos
No extensions. Use Microsoft Edge Browser Right click and choose Screenshot – Capture Full Page Also learn how to show long images using PowerPoint Morph. Bonus: Scrolling screenshot is also
These built-in add-ins are powerful and useful. Power Pivot, Power Maps, and Inquire. Learn how to enable and use them. Contents Related videos Handle millions of rows in Excel –
Select photos, auto-crop, rotate, clean-up, annotate and create PDF. All using Microsoft Office app – for free. Related videos Scanned PDF or picture to Excel data Create PDF from camera
Let us explore Flowcharts in Microsoft Excel. Uainf Data to create thew Flow Chart or using Copilot to make it. Related videos Instant flowchart using Copilot or ChatGPT Stop using
Create professional Flow Chart using Copilot. Get the steps from Copilot and create the actual flowchart using Mermaid Software. Related videos Stop using PowerPoint for flowcharts and infographics – Use
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
