Computergaga

Use Copilot in Microsoft Edge to extract from PDF to Excel easily. In this video, we want to extract specific data from a PDF to Excel. By using Copilot in Edge and specifying the data we need. The data was ready to copy to Excel. 🔥ChatGPT and AI for Excel course: https://bit.ly/3NkJyJ8 ⌚ Timestamps 00:00 - Introduction 00:31 - Use Copilot with Microsoft Edge 01:53 - Use Copilot to extract from PDF 03:25 - Paste from Copilot to Excel 👩🏻‍🤝‍👨🏿Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #excel #copilot #ai

Convert negative number to positive number in Excel easily using two different methods. One method shows how to convert a negative number to positive using a formula, and the second method is a quick Excel tip. Find more great free tutorials at; https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #excelshorts #excel #exceltips

How to create a button to clear ALL filters in Power BI. This video will show how to reset filters to default values, clear all slicer filters, and clear all filters on a Power BI report page with a single click of a button. 00:00 - Multiple filters on a Power BI report 00:54 - Reset filters button in the Power BI Service 03:29 - Clear all slicers button 05:13 - Clear all filters button in Power BI ▶️ What filters are applied to this visual https://youtube.com/shorts/0H8Zb-fGm7I ▶️ Drill through filter in Power BI https://youtu.be/9Ml3-TqAvWk ▶️ Fix bad measure totals in Power BI https://youtu.be/NUK6sRglwko Using Bookmarks in Power BI, you have the flexibility to clear the filters you want. These could only be slicer filters, or all filters. Power BI bookmarks are brilliant. Find more great free tutorials at; https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #powerbi #howtopowerbi #powerbitips

Convert US date to UK date format easily in Excel using Text to Columns. There are numerous methods to convert US date to UK date in Microsoft Excel. These include Power Query and formulas such as DATE. But the fastest and no-nonsense way is Text to Columns. Learn more Text to Columns tricks https://youtu.be/xYsCjlzjesQ Calculate age in Excel https://youtube.com/shorts/Ei-MiuAQvCs Find more great free tutorials at; https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #advanceexcel #excelshorts #exceltips

This videos contains three examples of the brilliant Ctrl + Enter Excel shortcut. There are many useful keyboard shortcuts in Excel, and Ctrl = Enter must be one of the best (the paste values shortcut in this video is also awesome). 00:00 - Introduction 00:20 - Enter and stay on the same cell 01:28 - Write formulas to non-adjacent cells 02:42 - Fill empty cells in used range Learning a few Excel shortcuts does not make you an Excel expert, but it certainly helps to save time on tedious tasks. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #excelshortcuts #exceltricks #excel

In this session, Mark presented on Office Scripts , a cross-platform scripting language to automate business processes. Outline: Office Scripts is the new tool in Excel’s automation toolkit. What can we use Office Scripts for? Come and find out. The session covers various projects to demonstrate how you can use Office Scripts to automate your work. Want to master Office Scripts? Well, Mark has a comprehensive online Office Scripts course https://bit.ly/3pKjzT0 (Use code LEM100 for a huge 45% discount) Files that Mark used in the first example https://computergaga.com/_excel/files/london-excel-meetup/office-scripts-example1.zip Who is Mark? Mark is an Excel and BI consultant specialising in the use of Power tools such as Power Automate and Power Query. He focuses on automating business processes and saving people hours of their time. Mark is a Microsoft MVP and runs a blog and YouTube channel named Excel Off the Grid (https://exceloffthegrid.com/). Join London Excel Meetup Events https://www.meetup.com/london-excel-meetup-group/ Learn more Excel and Power BI https://computergaga.com #officescripts #powerautomate #msexcel #londonexcelmeetup

It is easy to export live Power BI reports data to PowerPoint. With your Power BI report published to the service, there are options to export to PowerPoint as an image, or live report data. Subscribe to our channel to learn more Power BI tips https://www.youtube.com/computergaga Find more great free tutorials at https://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #powerbi #powerpoint #powerbitips

Dynamic Top 10 list in Excel using formulas. This method is the easiest way to create an Excel top 10 list using formulas. The SORT and TAKE functions in Excel 365 are used and a cell is referenced making it versatile. It will display the number of items specified in the cell. Learn the 150 best functions in Excel https://amzn.to/3Rg87Go Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #excel365 #excelshorts #excelformulas

How to add leading zeroes in Power BI, both to text and number values. This video shows two examples of adding leading zeroes to a number. An example in Power Query, and then using custom number formatting in Power BI. Timings 00:00 - Add leading zeroes in Power BI 00:26 - Stores values as text 01:12 - Use Number.ToText in Power Query 02:27 - Custom number formatting in Power BI Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1

In this video, we create a case sensitive XLOOKUP formula using the EXACT function to match case of the lookup value, and matching value in the lookup column. Learn the best 150 Excel functions with Advanced Excel Formulas https://amzn.to/3Rg87Go With XLOOKUP in Excel it is easy to create a case sensitive lookup formula. This powerful Excel formula allows the use of the EXACT function and can match the result of the logical value to its lookup value of TRUE. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1

In this meetup, Carlos Barboza presented on creating dynamic and interactive Excel charts. What to Expect Learn how to create interactive Excel charts using the dynamic array functions in Excel. With these functions, we can implement interactive charts easier than before. The only thing you must learn is the logic of spilled ranges so you can easily reference them to your charts. Learn some chart tips and Excel tricks along with some graphs types and pro tips. About the Speaker Carlos Barboza is a bilingual data consultant with 6 years of experience. He started his career in analytics using Microsoft Excel as his swiss army knife. He holds a Bachelor in Economics and Finance from University of Hartford. Currently, as consultant with Microsoft tools, Carlos is interchangeably switching between Power BI and Excel to analyze large volume of data thru data visualization, interaction and exploratory visual analysis. His current main interest today is the science of data visualization for analysis of information. Office Scripts course https://bit.ly/3pKjzT0 (Use code LEM100 for a huge 45% discount) Get involved and attend future London Excel Meetups - https://www.meetup.com/London-Excel-Meetup-Group/ Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1

Calculate how many working days between two dates in Power BI. The NETWORKDAYS function in DAX enables you to find the working days difference between two dates in Power BI. There are a few things to be careful of when using NETWORKDAYS in Power BI. These are demonstrated in the video. Video timings 00:00 Calculate working days between two dates 01:22 Working days difference with DAX 04:30 NETWORKDAYS is inclusive of dates 05:40 Add additional non-working days Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #powerbi #dax #powerbitips