• Free alternatives to Photoshop, Office, Premiere, and Netflix

    You don't have to go for the paid software options. Image: Timothy Exodus/Unsplash

    Get the Popular Science daily newsletter
    Breakthroughs, discoveries, and DIY tips sent every weekday.

    Most of us are signed up to plenty of digital subscriptions, covering streaming services, cloud storage, fitness apps, and plenty more. This extends to software subscriptions, too: Both Adobe Photoshop and Microsoft Officeask for monthly or yearly subscriptions if you want to stay up to date.
    Add up here and there and you can soon find yourself paying out more each week than you want. What you might not know is that for just about every paid software program out there, there’s a perfectly adequate and free replacement—so you can cut your dependency on software subscriptions right down.
    GIMP is an image editor packed with features. Screenshot: GIMP
    The rather oddly named GIMP—it stands for GNU Image Manipulation Program—is a head-on challenger to Adobe Photoshop, with a lot of the same advanced features on offer across object selections and manipulations, layers, and effects. GIMP doesn’t have as much AI stuffed into it as Photoshop does, but you might see that as a benefit.
    Whether you want to touch up and enhance the photos you’ve taken, or you want to create digital art, GIMP can handle it all. Open up the software and you’ll see you get a wealth of tools to play around with; there are plenty of third-party extensions and customizations available too—plus lots of tutorials and more help on the web.
    Download GIMP for Windows or macOS.
    LibreOffice Writer is a solid alternative to Microsoft Word. Screenshot: LibreOffice
    Microsoft Office is now called Microsoft 365, but however you refer to it, it’s anchored by Word, Excel, and PowerPoint. While Microsoft asks for a one-off fee or regular subscription, you can use LibreOffice completely free of charge—including the equivalent apps Writer, Calc, and Impress.
    If you have any experience using the Microsoft apps, you’ll feel right at home inside the LibreOffice apps—and they can import and export using Office file formats too. And just because you’re not paying for the software doesn’t mean you’re missing out on features, because these programs come backed with a host of useful options and tools.
    Download LibreOffice for Windows or macOS.
    Watch as much as you want on Tubi, for free. Screenshot: Tubi
    When it comes to movies and shows, there are plenty of services that will charge you a fee for access, including Netflix. Not so Tubi, which is completely funded by ads. Okay, it might not have the latest and greatest selection of titles, but there’s still plenty to watch, completely free. You aren’t going to run out of viewing material anytime soon.
    Tubi is one of a growing number of FAST streaming services, which stands for free ad-supported streaming television; others you might want to check out include Pluto TV and the Roku Channel. While content on these platforms is usually older than on the alternatives, you’ll probably be surprised at how much good stuff there is.
    Watch Tubi on the web, or on Android or iOS.
    Use KeePass as your password manager
    KeePass is a simple, straightforward password manager. Screenshot: KeePass
    We’ve written before about the benefits of using a password manager, but most of them require a subscription to use all of their features. If a password manager offers a free plan at all, it usually restricts how many passwords you can save or how many devices you can sync between, or apply some other limitations.
    KeePass is different, as it’s completely free and open source. It comes with plenty of features to keep your passwords private and secure, and while there’s only an official version for Windows, there are several unofficial ports so you can sync your passwords across macOS, Android, and iOS too.
    Download KeePass for Windows.
    Create videos with ease with OpenShot. Screenshot: OpenShot
    We’ll finish where we started, with an alternative to a program from the Adobe Creative Cloud suite. Unless you’re a professional filmmaker who needs the very best in industry-standard tools, OpenShot will give you everything you need in video editing features and options, and it’s capable of some impressive results.
    The extensive list includes support for key frame animations, an unlimited number of tracks, easy-to-use scaling and trimming tools, compositing, image overlays, title creating, and support for a broad range of video, audio, and image formats. Despite all of those features and more, you won’t find it difficult to use.
    Download OpenShot for Windows or macOS.
    #free #alternatives #photoshop #office #premiere
    Free alternatives to Photoshop, Office, Premiere, and Netflix
    You don't have to go for the paid software options. Image: Timothy Exodus/Unsplash Get the Popular Science daily newsletter💡 Breakthroughs, discoveries, and DIY tips sent every weekday. Most of us are signed up to plenty of digital subscriptions, covering streaming services, cloud storage, fitness apps, and plenty more. This extends to software subscriptions, too: Both Adobe Photoshop and Microsoft Officeask for monthly or yearly subscriptions if you want to stay up to date. Add up here and there and you can soon find yourself paying out more each week than you want. What you might not know is that for just about every paid software program out there, there’s a perfectly adequate and free replacement—so you can cut your dependency on software subscriptions right down. GIMP is an image editor packed with features. Screenshot: GIMP The rather oddly named GIMP—it stands for GNU Image Manipulation Program—is a head-on challenger to Adobe Photoshop, with a lot of the same advanced features on offer across object selections and manipulations, layers, and effects. GIMP doesn’t have as much AI stuffed into it as Photoshop does, but you might see that as a benefit. Whether you want to touch up and enhance the photos you’ve taken, or you want to create digital art, GIMP can handle it all. Open up the software and you’ll see you get a wealth of tools to play around with; there are plenty of third-party extensions and customizations available too—plus lots of tutorials and more help on the web. Download GIMP for Windows or macOS. LibreOffice Writer is a solid alternative to Microsoft Word. Screenshot: LibreOffice Microsoft Office is now called Microsoft 365, but however you refer to it, it’s anchored by Word, Excel, and PowerPoint. While Microsoft asks for a one-off fee or regular subscription, you can use LibreOffice completely free of charge—including the equivalent apps Writer, Calc, and Impress. If you have any experience using the Microsoft apps, you’ll feel right at home inside the LibreOffice apps—and they can import and export using Office file formats too. And just because you’re not paying for the software doesn’t mean you’re missing out on features, because these programs come backed with a host of useful options and tools. Download LibreOffice for Windows or macOS. Watch as much as you want on Tubi, for free. Screenshot: Tubi When it comes to movies and shows, there are plenty of services that will charge you a fee for access, including Netflix. Not so Tubi, which is completely funded by ads. Okay, it might not have the latest and greatest selection of titles, but there’s still plenty to watch, completely free. You aren’t going to run out of viewing material anytime soon. Tubi is one of a growing number of FAST streaming services, which stands for free ad-supported streaming television; others you might want to check out include Pluto TV and the Roku Channel. While content on these platforms is usually older than on the alternatives, you’ll probably be surprised at how much good stuff there is. Watch Tubi on the web, or on Android or iOS. Use KeePass as your password manager KeePass is a simple, straightforward password manager. Screenshot: KeePass We’ve written before about the benefits of using a password manager, but most of them require a subscription to use all of their features. If a password manager offers a free plan at all, it usually restricts how many passwords you can save or how many devices you can sync between, or apply some other limitations. KeePass is different, as it’s completely free and open source. It comes with plenty of features to keep your passwords private and secure, and while there’s only an official version for Windows, there are several unofficial ports so you can sync your passwords across macOS, Android, and iOS too. Download KeePass for Windows. Create videos with ease with OpenShot. Screenshot: OpenShot We’ll finish where we started, with an alternative to a program from the Adobe Creative Cloud suite. Unless you’re a professional filmmaker who needs the very best in industry-standard tools, OpenShot will give you everything you need in video editing features and options, and it’s capable of some impressive results. The extensive list includes support for key frame animations, an unlimited number of tracks, easy-to-use scaling and trimming tools, compositing, image overlays, title creating, and support for a broad range of video, audio, and image formats. Despite all of those features and more, you won’t find it difficult to use. Download OpenShot for Windows or macOS. #free #alternatives #photoshop #office #premiere
    WWW.POPSCI.COM
    Free alternatives to Photoshop, Office, Premiere, and Netflix
    You don't have to go for the paid software options. Image: Timothy Exodus/Unsplash Get the Popular Science daily newsletter💡 Breakthroughs, discoveries, and DIY tips sent every weekday. Most of us are signed up to plenty of digital subscriptions, covering streaming services, cloud storage, fitness apps, and plenty more. This extends to software subscriptions, too: Both Adobe Photoshop and Microsoft Office (now Microsoft 365) ask for monthly or yearly subscriptions if you want to stay up to date. Add up $5 here and $10 there and you can soon find yourself paying out more each week than you want. What you might not know is that for just about every paid software program out there, there’s a perfectly adequate and free replacement—so you can cut your dependency on software subscriptions right down. GIMP is an image editor packed with features. Screenshot: GIMP The rather oddly named GIMP—it stands for GNU Image Manipulation Program—is a head-on challenger to Adobe Photoshop, with a lot of the same advanced features on offer across object selections and manipulations, layers, and effects. GIMP doesn’t have as much AI stuffed into it as Photoshop does, but you might see that as a benefit. Whether you want to touch up and enhance the photos you’ve taken, or you want to create digital art, GIMP can handle it all. Open up the software and you’ll see you get a wealth of tools to play around with; there are plenty of third-party extensions and customizations available too—plus lots of tutorials and more help on the web. Download GIMP for Windows or macOS. LibreOffice Writer is a solid alternative to Microsoft Word. Screenshot: LibreOffice Microsoft Office is now called Microsoft 365, but however you refer to it, it’s anchored by Word, Excel, and PowerPoint. While Microsoft asks for a one-off fee or regular subscription, you can use LibreOffice completely free of charge—including the equivalent apps Writer (documents), Calc (spreadsheets), and Impress (presentations). If you have any experience using the Microsoft apps, you’ll feel right at home inside the LibreOffice apps—and they can import and export using Office file formats too. And just because you’re not paying for the software doesn’t mean you’re missing out on features, because these programs come backed with a host of useful options and tools. Download LibreOffice for Windows or macOS. Watch as much as you want on Tubi, for free. Screenshot: Tubi When it comes to movies and shows, there are plenty of services that will charge you a fee for access, including Netflix. Not so Tubi, which is completely funded by ads. Okay, it might not have the latest and greatest selection of titles, but there’s still plenty to watch, completely free. You aren’t going to run out of viewing material anytime soon. Tubi is one of a growing number of FAST streaming services, which stands for free ad-supported streaming television; others you might want to check out include Pluto TV and the Roku Channel. While content on these platforms is usually older than on the alternatives, you’ll probably be surprised at how much good stuff there is. Watch Tubi on the web, or on Android or iOS. Use KeePass as your password manager KeePass is a simple, straightforward password manager. Screenshot: KeePass We’ve written before about the benefits of using a password manager, but most of them require a subscription to use all of their features. If a password manager offers a free plan at all, it usually restricts how many passwords you can save or how many devices you can sync between, or apply some other limitations. KeePass is different, as it’s completely free and open source (so you can look at the source code yourself, if you wish). It comes with plenty of features to keep your passwords private and secure, and while there’s only an official version for Windows, there are several unofficial ports so you can sync your passwords across macOS, Android, and iOS too. Download KeePass for Windows. Create videos with ease with OpenShot. Screenshot: OpenShot We’ll finish where we started, with an alternative to a program from the Adobe Creative Cloud suite. Unless you’re a professional filmmaker who needs the very best in industry-standard tools, OpenShot will give you everything you need in video editing features and options, and it’s capable of some impressive results. The extensive list includes support for key frame animations, an unlimited number of tracks, easy-to-use scaling and trimming tools, compositing, image overlays, title creating (including 3D titles), and support for a broad range of video, audio, and image formats. Despite all of those features and more, you won’t find it difficult to use. Download OpenShot for Windows or macOS.
    0 Комментарии 0 Поделились 0 предпросмотр
  • Selection Sort Time Complexity: Best, Worst, and Average Cases

    Development and Testing 

    Rate this post

    Sorting is a basic task in programming. It arranges data in order. There are many sorting algorithms. Selection Sort is one of the simplest sorting methods. It is easy to understand and code. But it is not the fastest. In this guide, we will explain the Selection Sort Time Complexity. We will cover best, worst, and average cases.
    What Is Selection Sort?
    Selection Sort works by selecting the smallest element from the list. It places it in the correct position. It repeats this process for all elements. One by one, it moves the smallest values to the front.
    Let’s see an example:
    Input:Step 1: Smallest is 2 → swap with 5 →Step 2: Smallest in remaining is 3 → already correctStep 3: Smallest in remaining is 5 → swap with 8 →Now the list is sorted.How Selection Sort Works
    Selection Sort uses two loops. The outer loop moves one index at a time. The inner loop finds the smallest element. After each pass, the smallest value is moved to the front. The position is fixed. Selection Sort does not care if the list is sorted or not. It always does the same steps.
    Selection Sort Algorithm
    Here is the basic algorithm:

    Start from the first element
    Find the smallest in the rest of the list
    Swap it with the current element
    Repeat for each element

    This repeats until all elements are sorted.
    Selection Sort CodejavaCopyEditpublic class SelectionSort {
    public static void sort{
    int n = arr.length;
    for{
    int min = i;
    for{
    if{
    min = j;
    }
    }
    int temp = arr;
    arr= arr;
    arr= temp;
    }
    }
    }

    This code uses two loops. The outer loop runs n-1 times. The inner loop finds the minimum.
    Selection Sort Time Complexity
    Now let’s understand the main topic. Let’s analyze Selection Sort Time Complexity in three cases.
    1. Best Case
    Even if the array is already sorted, Selection Sort checks all elements. It keeps comparing and swapping.

    Time Complexity: OReason: Inner loop runs fully, regardless of the order
    Example Input:Even here, every comparison still happens. Only fewer swaps occur, but comparisons remain the same.
    2. Worst Case
    This happens when the array is in reverse order. But Selection Sort does not optimize for this.

    Time Complexity: OReason: Still needs full comparisons
    Example Input:Even in reverse, the steps are the same. It compares and finds the smallest element every time.
    3. Average Case
    This is when elements are randomly placed. It is the most common scenario in real-world problems.

    Time Complexity: OReason: Still compares each element in the inner loop
    Example Input:Selection Sort does not change behavior based on input order. So the complexity remains the same.
    Why Is It Always O?
    Selection Sort compares all pairs of elements. The number of comparisons does not change.
    Total comparisons = n ×/ 2
    That’s why the time complexity is always O.It does not reduce steps in any case. It does not take advantage of sorted elements.
    Space Complexity
    Selection Sort does not need extra space. It sorts in place.

    Space Complexity: OOnly a few variables are used
    No extra arrays or memory needed

    This is one good point of the Selection Sort.
    Comparison with Other Algorithms
    Let’s compare Selection Sort with other basic sorts:
    AlgorithmBest CaseAverage CaseWorst CaseSpaceSelection SortOOOOBubble SortOOOOInsertion SortOOOOMerge SortOOOOQuick SortOOOOAs you see, Selection Sort is slower than Merge Sort and Quick Sort.
    Advantages of Selection Sort

    Very simple and easy to understand
    Works well with small datasets
    Needs very little memory
    Good for learning purposes

    Disadvantages of Selection Sort

    Slow on large datasets
    Always takes the same time, even if sorted
    Not efficient for real-world use

    When to Use Selection Sort
    Use Selection Sort when:

    You are working with a very small dataset
    You want to teach or learn sorting logic
    You want stable, low-memory sorting

    Avoid it for:

    Large datasets
    Performance-sensitive programs

    Conclusion
    Selection Sort Time Complexity is simple to understand. But it is not efficient for big problems. It always takes Otime, no matter the case. That is the same for best, worst, and average inputs. Still, it is useful in some cases. It’s great for learning sorting basics. It uses very little memory. If you’re working with small arrays, Selection Sort is fine. For large data, use better algorithms. Understanding its time complexity helps you choose the right algorithm. Always pick the tool that fits your task.
    Tech World TimesTech World Times, a global collective focusing on the latest tech news and trends in blockchain, Fintech, Development & Testing, AI and Startups. If you are looking for the guest post then contact at techworldtimes@gmail.com
    #selection #sort #time #complexity #best
    Selection Sort Time Complexity: Best, Worst, and Average Cases
    Development and Testing  Rate this post Sorting is a basic task in programming. It arranges data in order. There are many sorting algorithms. Selection Sort is one of the simplest sorting methods. It is easy to understand and code. But it is not the fastest. In this guide, we will explain the Selection Sort Time Complexity. We will cover best, worst, and average cases. What Is Selection Sort? Selection Sort works by selecting the smallest element from the list. It places it in the correct position. It repeats this process for all elements. One by one, it moves the smallest values to the front. Let’s see an example: Input:Step 1: Smallest is 2 → swap with 5 →Step 2: Smallest in remaining is 3 → already correctStep 3: Smallest in remaining is 5 → swap with 8 →Now the list is sorted.How Selection Sort Works Selection Sort uses two loops. The outer loop moves one index at a time. The inner loop finds the smallest element. After each pass, the smallest value is moved to the front. The position is fixed. Selection Sort does not care if the list is sorted or not. It always does the same steps. Selection Sort Algorithm Here is the basic algorithm: Start from the first element Find the smallest in the rest of the list Swap it with the current element Repeat for each element This repeats until all elements are sorted. Selection Sort CodejavaCopyEditpublic class SelectionSort { public static void sort{ int n = arr.length; for{ int min = i; for{ if{ min = j; } } int temp = arr; arr= arr; arr= temp; } } } This code uses two loops. The outer loop runs n-1 times. The inner loop finds the minimum. Selection Sort Time Complexity Now let’s understand the main topic. Let’s analyze Selection Sort Time Complexity in three cases. 1. Best Case Even if the array is already sorted, Selection Sort checks all elements. It keeps comparing and swapping. Time Complexity: OReason: Inner loop runs fully, regardless of the order Example Input:Even here, every comparison still happens. Only fewer swaps occur, but comparisons remain the same. 2. Worst Case This happens when the array is in reverse order. But Selection Sort does not optimize for this. Time Complexity: OReason: Still needs full comparisons Example Input:Even in reverse, the steps are the same. It compares and finds the smallest element every time. 3. Average Case This is when elements are randomly placed. It is the most common scenario in real-world problems. Time Complexity: OReason: Still compares each element in the inner loop Example Input:Selection Sort does not change behavior based on input order. So the complexity remains the same. Why Is It Always O? Selection Sort compares all pairs of elements. The number of comparisons does not change. Total comparisons = n ×/ 2 That’s why the time complexity is always O.It does not reduce steps in any case. It does not take advantage of sorted elements. Space Complexity Selection Sort does not need extra space. It sorts in place. Space Complexity: OOnly a few variables are used No extra arrays or memory needed This is one good point of the Selection Sort. Comparison with Other Algorithms Let’s compare Selection Sort with other basic sorts: AlgorithmBest CaseAverage CaseWorst CaseSpaceSelection SortOOOOBubble SortOOOOInsertion SortOOOOMerge SortOOOOQuick SortOOOOAs you see, Selection Sort is slower than Merge Sort and Quick Sort. Advantages of Selection Sort Very simple and easy to understand Works well with small datasets Needs very little memory Good for learning purposes Disadvantages of Selection Sort Slow on large datasets Always takes the same time, even if sorted Not efficient for real-world use When to Use Selection Sort Use Selection Sort when: You are working with a very small dataset You want to teach or learn sorting logic You want stable, low-memory sorting Avoid it for: Large datasets Performance-sensitive programs Conclusion Selection Sort Time Complexity is simple to understand. But it is not efficient for big problems. It always takes Otime, no matter the case. That is the same for best, worst, and average inputs. Still, it is useful in some cases. It’s great for learning sorting basics. It uses very little memory. If you’re working with small arrays, Selection Sort is fine. For large data, use better algorithms. Understanding its time complexity helps you choose the right algorithm. Always pick the tool that fits your task. Tech World TimesTech World Times, a global collective focusing on the latest tech news and trends in blockchain, Fintech, Development & Testing, AI and Startups. If you are looking for the guest post then contact at techworldtimes@gmail.com #selection #sort #time #complexity #best
    TECHWORLDTIMES.COM
    Selection Sort Time Complexity: Best, Worst, and Average Cases
    Development and Testing  Rate this post Sorting is a basic task in programming. It arranges data in order. There are many sorting algorithms. Selection Sort is one of the simplest sorting methods. It is easy to understand and code. But it is not the fastest. In this guide, we will explain the Selection Sort Time Complexity. We will cover best, worst, and average cases. What Is Selection Sort? Selection Sort works by selecting the smallest element from the list. It places it in the correct position. It repeats this process for all elements. One by one, it moves the smallest values to the front. Let’s see an example: Input: [5, 3, 8, 2]Step 1: Smallest is 2 → swap with 5 → [2, 3, 8, 5]Step 2: Smallest in remaining is 3 → already correctStep 3: Smallest in remaining is 5 → swap with 8 → [2, 3, 5, 8] Now the list is sorted.How Selection Sort Works Selection Sort uses two loops. The outer loop moves one index at a time. The inner loop finds the smallest element. After each pass, the smallest value is moved to the front. The position is fixed. Selection Sort does not care if the list is sorted or not. It always does the same steps. Selection Sort Algorithm Here is the basic algorithm: Start from the first element Find the smallest in the rest of the list Swap it with the current element Repeat for each element This repeats until all elements are sorted. Selection Sort Code (Java Example) javaCopyEditpublic class SelectionSort { public static void sort(int[] arr) { int n = arr.length; for (int i = 0; i < n - 1; i++) { int min = i; for (int j = i + 1; j < n; j++) { if (arr[j] < arr[min]) { min = j; } } int temp = arr[min]; arr[min] = arr[i]; arr[i] = temp; } } } This code uses two loops. The outer loop runs n-1 times. The inner loop finds the minimum. Selection Sort Time Complexity Now let’s understand the main topic. Let’s analyze Selection Sort Time Complexity in three cases. 1. Best Case Even if the array is already sorted, Selection Sort checks all elements. It keeps comparing and swapping. Time Complexity: O(n²) Reason: Inner loop runs fully, regardless of the order Example Input: [1, 2, 3, 4, 5] Even here, every comparison still happens. Only fewer swaps occur, but comparisons remain the same. 2. Worst Case This happens when the array is in reverse order. But Selection Sort does not optimize for this. Time Complexity: O(n²) Reason: Still needs full comparisons Example Input: [5, 4, 3, 2, 1] Even in reverse, the steps are the same. It compares and finds the smallest element every time. 3. Average Case This is when elements are randomly placed. It is the most common scenario in real-world problems. Time Complexity: O(n²) Reason: Still compares each element in the inner loop Example Input: [3, 1, 4, 2, 5] Selection Sort does not change behavior based on input order. So the complexity remains the same. Why Is It Always O(n²)? Selection Sort compares all pairs of elements. The number of comparisons does not change. Total comparisons = n × (n – 1) / 2 That’s why the time complexity is always O(n²).It does not reduce steps in any case. It does not take advantage of sorted elements. Space Complexity Selection Sort does not need extra space. It sorts in place. Space Complexity: O(1) Only a few variables are used No extra arrays or memory needed This is one good point of the Selection Sort. Comparison with Other Algorithms Let’s compare Selection Sort with other basic sorts: AlgorithmBest CaseAverage CaseWorst CaseSpaceSelection SortO(n²)O(n²)O(n²)O(1)Bubble SortO(n)O(n²)O(n²)O(1)Insertion SortO(n)O(n²)O(n²)O(1)Merge SortO(n log n)O(n log n)O(n log n)O(n)Quick SortO(n log n)O(n log n)O(n²)O(log n) As you see, Selection Sort is slower than Merge Sort and Quick Sort. Advantages of Selection Sort Very simple and easy to understand Works well with small datasets Needs very little memory Good for learning purposes Disadvantages of Selection Sort Slow on large datasets Always takes the same time, even if sorted Not efficient for real-world use When to Use Selection Sort Use Selection Sort when: You are working with a very small dataset You want to teach or learn sorting logic You want stable, low-memory sorting Avoid it for: Large datasets Performance-sensitive programs Conclusion Selection Sort Time Complexity is simple to understand. But it is not efficient for big problems. It always takes O(n²) time, no matter the case. That is the same for best, worst, and average inputs. Still, it is useful in some cases. It’s great for learning sorting basics. It uses very little memory. If you’re working with small arrays, Selection Sort is fine. For large data, use better algorithms. Understanding its time complexity helps you choose the right algorithm. Always pick the tool that fits your task. Tech World TimesTech World Times (TWT), a global collective focusing on the latest tech news and trends in blockchain, Fintech, Development & Testing, AI and Startups. If you are looking for the guest post then contact at techworldtimes@gmail.com
    0 Комментарии 0 Поделились 0 предпросмотр
  • The Legal Accountability of AI-Generated Deepfakes in Election Misinformation

    How Deepfakes Are Created

    Generative AI models enable the creation of highly realistic fake media. Most deepfakes today are produced by training deep neural networks on real images, video or audio of a target person. The two predominant AI architectures are generative adversarial networksand autoencoders. A GAN consists of a generator network that produces synthetic images and a discriminator network that tries to distinguish fakes from real data. Through iterative training, the generator learns to produce outputs that increasingly fool the discriminator¹. Autoencoder-based tools similarly learn to encode a target face and then decode it onto a source video. In practice, deepfake creators use accessible software: open-source tools like DeepFaceLab and FaceSwap dominate video face-swapping². Voice-cloning toolscan mimic a person’s speech from minutes of audio. Commercial platforms like Synthesia allow text-to-video avatars, which have already been misused in disinformation campaigns³. Even mobile appslet users do basic face swaps in minutes⁴. In short, advances in GANs and related models make deepfakes cheaper and easier to generate than ever.

    Diagram of a generative adversarial network: A generator network creates fake images from random input and a discriminator network distinguishes fakes from real examples. Over time the generator improves until its outputs “fool” the discriminator⁵

    During creation, a deepfake algorithm is typically trained on a large dataset of real images or audio from the target. The more varied and high-quality the training data, the more realistic the deepfake. The output often then undergoes post-processingto enhance believability¹. Technical defenses focus on two fronts: detection and authentication. Detection uses AI models to spot inconsistenciesthat betray a synthetic origin⁵. Authentication embeds markers before dissemination – for example, invisible watermarks or cryptographically signed metadata indicating authenticity⁶. The EU AI Act will soon mandate that major AI content providers embed machine-readable “watermark” signals in synthetic media⁷. However, as GAO notes, detection is an arms race – even a marked deepfake can sometimes evade notice – and labels alone don’t stop false narratives from spreading⁸⁹.

    Deepfakes in Recent Elections: Examples

    Deepfakes and AI-generated imagery already have made headlines in election cycles around the world. In the 2024 U.S. primary season, a digitally-altered audio robocall mimicked President Biden’s voice urging Democrats not to vote in the New Hampshire primary. The callerwas later fined million by the FCC and indicted under existing telemarketing laws¹⁰¹¹.Also in 2024, former President Trump posted on social media a collage implying that pop singer Taylor Swift endorsed his campaign, using AI-generated images of Swift in “Swifties for Trump” shirts¹². The posts sparked media uproar, though analysts noted the same effect could have been achieved without AI¹². Similarly, Elon Musk’s X platform carried AI-generated clips, including a parody “Ad” depicting Vice-President Harris’s voice via an AI clone¹³.

    Beyond the U.S., deepfake-like content has appeared globally. In Indonesia’s 2024 presidential election, a video surfaced on social media in which a convincingly generated image of the late President Suharto appeared to endorse the candidate of the Golkar Party. Days later, the endorsed candidatewon the presidency¹⁴. In Bangladesh, a viral deepfake video superimposed the face of opposition leader Rumeen Farhana onto a bikini-clad body – an incendiary fabrication designed to discredit her in the conservative Muslim-majority society¹⁵. Moldova’s pro-Western President Maia Sandu has been repeatedly targeted by AI-driven disinformation; one deepfake video falsely showed her resigning and endorsing a Russian-friendly party, apparently to sow distrust in the electoral process¹⁶. Even in Taiwan, a TikTok clip circulated that synthetically portrayed a U.S. politician making foreign-policy statements – stoking confusion ahead of Taiwanese elections¹⁷. In Slovakia’s recent campaign, AI-generated audio mimicking the liberal party leader suggested he plotted vote-rigging and beer-price hikes – instantly spreading on social media just days before the election¹⁸. These examples show that deepfakes have touched diverse polities, often aiming to undermine candidates or confuse voters¹⁵¹⁸.

    Notably, many of the most viral “deepfakes” in 2024 were actually circulated as obvious memes or claims, rather than subtle deceptions. Experts observed that outright undetectable AI deepfakes were relatively rare; more common were AI-generated memes plainly shared by partisans, or cheaply doctored “cheapfakes” made with basic editing tools¹³¹⁹. For instance, social media was awash with memes of Kamala Harris in Soviet garb or of Black Americans holding Trump signs¹³, but these were typically used satirically, not meant to be secretly believed. Nonetheless, even unsophisticated fakes can sway opinion: a U.S. study found that false presidential adsdid change voter attitudes in swing states. In sum, deepfakes are a real and growing phenomenon in election campaigns²⁰²¹ worldwide – a trend taken seriously by voters and regulators alike.

    U.S. Legal Framework and Accountability

    In the U.S., deepfake creators and distributors of election misinformation face a patchwork of tools, but no single comprehensive federal “deepfake law.” Existing laws relevant to disinformation include statutes against impersonating government officials, electioneering, and targeted statutes like criminal electioneering communications. In some cases ordinary laws have been stretched: the NH robocall used the Telephone Consumer Protection Act and mail/telemarketing fraud provisions, resulting in the M fine and a criminal charge. Similarly, voice impostors can potentially violate laws against “false advertising” or “unlawful corporate communications.” However, these laws were enacted before AI, and litigators have warned they often do not fit neatly. For example, deceptive deepfake claims not tied to a specific victim do not easily fit into defamation or privacy torts. Voter intimidation lawsalso leave a gap for non-threatening falsehoods about voting logistics or endorsements.

    Recognizing these gaps, some courts and agencies are invoking other theories. The U.S. Department of Justice has recently charged individuals under broad fraud statutes, and state attorneys general have considered deepfake misinformation as interference with voting rights. Notably, the Federal Election Commissionis preparing to enforce new rules: in April 2024 it issued an advisory opinion limiting “non-candidate electioneering communications” that use falsified media, effectively requiring that political ads use only real images of the candidate. If finalized, that would make it unlawful for campaigns to pay for ads depicting a candidate saying things they never did. Similarly, the Federal Trade Commissionand Department of Justicehave signaled that purely commercial deepfakes could violate consumer protection or election laws.

    U.S. Legislation and Proposals

    Federal lawmakers have proposed new statutes. The DEEPFAKES Accountability Actwould, among other things, impose a disclosure requirement: political ads featuring a manipulated media likeness would need clear disclaimers identifying the content as synthetic. It also increases penalties for producing false election videos or audio intended to influence the vote. While not yet enacted, supporters argue it would provide a uniform rule for all federal and state campaigns. The Brennan Center supports transparency requirements over outright bans, suggesting laws should narrowly target deceptive deepfakes in paid ads or certain categorieswhile carving out parody and news coverage.

    At the state level, over 20 states have passed deepfake laws specifically for elections. For example, Florida and California forbid distributing falsified audio/visual media of candidates with intent to deceive voters. Some statesdefine “deepfake” in statutes and allow candidates to sue or revoke candidacies of violators. These measures have had mixed success: courts have struck down overly broad provisions that acted as prior restraints. Critically, these state laws raise First Amendment issues: political speech is highly protected, so any restriction must be tightly tailored. Already, Texas and Virginia statutes are under legal review, and Elon Musk’s company has sued under California’s lawas unconstitutional. In practice, most lawsuits have so far centered on defamation or intellectual property, rather than election-focused statutes.

    Policy Recommendations: Balancing Integrity and Speech

    Given the rapidly evolving technology, experts recommend a multi-pronged approach. Most stress transparency and disclosure as core principles. For example, the Brennan Center urges requiring any political communication that uses AI-synthesized images or voice to include a clear label. This could be a digital watermark or a visible disclaimer. Transparency has two advantages: it forces campaigns and platforms to “own” the use of AI, and it alerts audiences to treat the content with skepticism.

    Outright bans on all deepfakes would likely violate free speech, but targeted bans on specific harmsmay be defensible. Indeed, Florida already penalizes misuse of recordings in voter suppression. Another recommendation is limited liability: tying penalties to demonstrable intent to mislead, not to the mere act of content creation. Both U.S. federal proposals and EU law generally condition fines on the “appearance of fraud” or deception.

    Technical solutions can complement laws. Watermarking original mediacould deter the reuse of authentic images in doctored fakes. Open tools for deepfake detection – some supported by government research grants – should be deployed by fact-checkers and social platforms. Making detection datasets publicly availablehelps improve AI models to spot fakes. International cooperation is also urged: cross-border agreements on information-sharing could help trace and halt disinformation campaigns. The G7 and APEC have all recently committed to fighting election interference via AI, which may lead to joint norms or rapid response teams.

    Ultimately, many analysts believe the strongest “cure” is a well-informed public: education campaigns to teach voters to question sensational media, and a robust independent press to debunk falsehoods swiftly. While the law can penalize the worst offenders, awareness and resilience in the electorate are crucial buffers against influence operations. As Georgia Tech’s Sean Parker quipped in 2019, “the real question is not if deepfakes will influence elections, but who will be empowered by the first effective one.” Thus policies should aim to deter malicious use without unduly chilling innovation or satire.

    References:

    /.

    /.

    .

    .

    .

    .

    .

    .

    .

    /.

    .

    .

    /.

    /.

    .

    The post The Legal Accountability of AI-Generated Deepfakes in Election Misinformation appeared first on MarkTechPost.
    #legal #accountability #aigenerated #deepfakes #election
    The Legal Accountability of AI-Generated Deepfakes in Election Misinformation
    How Deepfakes Are Created Generative AI models enable the creation of highly realistic fake media. Most deepfakes today are produced by training deep neural networks on real images, video or audio of a target person. The two predominant AI architectures are generative adversarial networksand autoencoders. A GAN consists of a generator network that produces synthetic images and a discriminator network that tries to distinguish fakes from real data. Through iterative training, the generator learns to produce outputs that increasingly fool the discriminator¹. Autoencoder-based tools similarly learn to encode a target face and then decode it onto a source video. In practice, deepfake creators use accessible software: open-source tools like DeepFaceLab and FaceSwap dominate video face-swapping². Voice-cloning toolscan mimic a person’s speech from minutes of audio. Commercial platforms like Synthesia allow text-to-video avatars, which have already been misused in disinformation campaigns³. Even mobile appslet users do basic face swaps in minutes⁴. In short, advances in GANs and related models make deepfakes cheaper and easier to generate than ever. Diagram of a generative adversarial network: A generator network creates fake images from random input and a discriminator network distinguishes fakes from real examples. Over time the generator improves until its outputs “fool” the discriminator⁵ During creation, a deepfake algorithm is typically trained on a large dataset of real images or audio from the target. The more varied and high-quality the training data, the more realistic the deepfake. The output often then undergoes post-processingto enhance believability¹. Technical defenses focus on two fronts: detection and authentication. Detection uses AI models to spot inconsistenciesthat betray a synthetic origin⁵. Authentication embeds markers before dissemination – for example, invisible watermarks or cryptographically signed metadata indicating authenticity⁶. The EU AI Act will soon mandate that major AI content providers embed machine-readable “watermark” signals in synthetic media⁷. However, as GAO notes, detection is an arms race – even a marked deepfake can sometimes evade notice – and labels alone don’t stop false narratives from spreading⁸⁹. Deepfakes in Recent Elections: Examples Deepfakes and AI-generated imagery already have made headlines in election cycles around the world. In the 2024 U.S. primary season, a digitally-altered audio robocall mimicked President Biden’s voice urging Democrats not to vote in the New Hampshire primary. The callerwas later fined million by the FCC and indicted under existing telemarketing laws¹⁰¹¹.Also in 2024, former President Trump posted on social media a collage implying that pop singer Taylor Swift endorsed his campaign, using AI-generated images of Swift in “Swifties for Trump” shirts¹². The posts sparked media uproar, though analysts noted the same effect could have been achieved without AI¹². Similarly, Elon Musk’s X platform carried AI-generated clips, including a parody “Ad” depicting Vice-President Harris’s voice via an AI clone¹³. Beyond the U.S., deepfake-like content has appeared globally. In Indonesia’s 2024 presidential election, a video surfaced on social media in which a convincingly generated image of the late President Suharto appeared to endorse the candidate of the Golkar Party. Days later, the endorsed candidatewon the presidency¹⁴. In Bangladesh, a viral deepfake video superimposed the face of opposition leader Rumeen Farhana onto a bikini-clad body – an incendiary fabrication designed to discredit her in the conservative Muslim-majority society¹⁵. Moldova’s pro-Western President Maia Sandu has been repeatedly targeted by AI-driven disinformation; one deepfake video falsely showed her resigning and endorsing a Russian-friendly party, apparently to sow distrust in the electoral process¹⁶. Even in Taiwan, a TikTok clip circulated that synthetically portrayed a U.S. politician making foreign-policy statements – stoking confusion ahead of Taiwanese elections¹⁷. In Slovakia’s recent campaign, AI-generated audio mimicking the liberal party leader suggested he plotted vote-rigging and beer-price hikes – instantly spreading on social media just days before the election¹⁸. These examples show that deepfakes have touched diverse polities, often aiming to undermine candidates or confuse voters¹⁵¹⁸. Notably, many of the most viral “deepfakes” in 2024 were actually circulated as obvious memes or claims, rather than subtle deceptions. Experts observed that outright undetectable AI deepfakes were relatively rare; more common were AI-generated memes plainly shared by partisans, or cheaply doctored “cheapfakes” made with basic editing tools¹³¹⁹. For instance, social media was awash with memes of Kamala Harris in Soviet garb or of Black Americans holding Trump signs¹³, but these were typically used satirically, not meant to be secretly believed. Nonetheless, even unsophisticated fakes can sway opinion: a U.S. study found that false presidential adsdid change voter attitudes in swing states. In sum, deepfakes are a real and growing phenomenon in election campaigns²⁰²¹ worldwide – a trend taken seriously by voters and regulators alike. U.S. Legal Framework and Accountability In the U.S., deepfake creators and distributors of election misinformation face a patchwork of tools, but no single comprehensive federal “deepfake law.” Existing laws relevant to disinformation include statutes against impersonating government officials, electioneering, and targeted statutes like criminal electioneering communications. In some cases ordinary laws have been stretched: the NH robocall used the Telephone Consumer Protection Act and mail/telemarketing fraud provisions, resulting in the M fine and a criminal charge. Similarly, voice impostors can potentially violate laws against “false advertising” or “unlawful corporate communications.” However, these laws were enacted before AI, and litigators have warned they often do not fit neatly. For example, deceptive deepfake claims not tied to a specific victim do not easily fit into defamation or privacy torts. Voter intimidation lawsalso leave a gap for non-threatening falsehoods about voting logistics or endorsements. Recognizing these gaps, some courts and agencies are invoking other theories. The U.S. Department of Justice has recently charged individuals under broad fraud statutes, and state attorneys general have considered deepfake misinformation as interference with voting rights. Notably, the Federal Election Commissionis preparing to enforce new rules: in April 2024 it issued an advisory opinion limiting “non-candidate electioneering communications” that use falsified media, effectively requiring that political ads use only real images of the candidate. If finalized, that would make it unlawful for campaigns to pay for ads depicting a candidate saying things they never did. Similarly, the Federal Trade Commissionand Department of Justicehave signaled that purely commercial deepfakes could violate consumer protection or election laws. U.S. Legislation and Proposals Federal lawmakers have proposed new statutes. The DEEPFAKES Accountability Actwould, among other things, impose a disclosure requirement: political ads featuring a manipulated media likeness would need clear disclaimers identifying the content as synthetic. It also increases penalties for producing false election videos or audio intended to influence the vote. While not yet enacted, supporters argue it would provide a uniform rule for all federal and state campaigns. The Brennan Center supports transparency requirements over outright bans, suggesting laws should narrowly target deceptive deepfakes in paid ads or certain categorieswhile carving out parody and news coverage. At the state level, over 20 states have passed deepfake laws specifically for elections. For example, Florida and California forbid distributing falsified audio/visual media of candidates with intent to deceive voters. Some statesdefine “deepfake” in statutes and allow candidates to sue or revoke candidacies of violators. These measures have had mixed success: courts have struck down overly broad provisions that acted as prior restraints. Critically, these state laws raise First Amendment issues: political speech is highly protected, so any restriction must be tightly tailored. Already, Texas and Virginia statutes are under legal review, and Elon Musk’s company has sued under California’s lawas unconstitutional. In practice, most lawsuits have so far centered on defamation or intellectual property, rather than election-focused statutes. Policy Recommendations: Balancing Integrity and Speech Given the rapidly evolving technology, experts recommend a multi-pronged approach. Most stress transparency and disclosure as core principles. For example, the Brennan Center urges requiring any political communication that uses AI-synthesized images or voice to include a clear label. This could be a digital watermark or a visible disclaimer. Transparency has two advantages: it forces campaigns and platforms to “own” the use of AI, and it alerts audiences to treat the content with skepticism. Outright bans on all deepfakes would likely violate free speech, but targeted bans on specific harmsmay be defensible. Indeed, Florida already penalizes misuse of recordings in voter suppression. Another recommendation is limited liability: tying penalties to demonstrable intent to mislead, not to the mere act of content creation. Both U.S. federal proposals and EU law generally condition fines on the “appearance of fraud” or deception. Technical solutions can complement laws. Watermarking original mediacould deter the reuse of authentic images in doctored fakes. Open tools for deepfake detection – some supported by government research grants – should be deployed by fact-checkers and social platforms. Making detection datasets publicly availablehelps improve AI models to spot fakes. International cooperation is also urged: cross-border agreements on information-sharing could help trace and halt disinformation campaigns. The G7 and APEC have all recently committed to fighting election interference via AI, which may lead to joint norms or rapid response teams. Ultimately, many analysts believe the strongest “cure” is a well-informed public: education campaigns to teach voters to question sensational media, and a robust independent press to debunk falsehoods swiftly. While the law can penalize the worst offenders, awareness and resilience in the electorate are crucial buffers against influence operations. As Georgia Tech’s Sean Parker quipped in 2019, “the real question is not if deepfakes will influence elections, but who will be empowered by the first effective one.” Thus policies should aim to deter malicious use without unduly chilling innovation or satire. References: /. /. . . . . . . . /. . . /. /. . The post The Legal Accountability of AI-Generated Deepfakes in Election Misinformation appeared first on MarkTechPost. #legal #accountability #aigenerated #deepfakes #election
    WWW.MARKTECHPOST.COM
    The Legal Accountability of AI-Generated Deepfakes in Election Misinformation
    How Deepfakes Are Created Generative AI models enable the creation of highly realistic fake media. Most deepfakes today are produced by training deep neural networks on real images, video or audio of a target person. The two predominant AI architectures are generative adversarial networks (GANs) and autoencoders. A GAN consists of a generator network that produces synthetic images and a discriminator network that tries to distinguish fakes from real data. Through iterative training, the generator learns to produce outputs that increasingly fool the discriminator¹. Autoencoder-based tools similarly learn to encode a target face and then decode it onto a source video. In practice, deepfake creators use accessible software: open-source tools like DeepFaceLab and FaceSwap dominate video face-swapping (one estimate suggests DeepFaceLab was used for over 95% of known deepfake videos)². Voice-cloning tools (often built on similar AI principles) can mimic a person’s speech from minutes of audio. Commercial platforms like Synthesia allow text-to-video avatars (turning typed scripts into lifelike “spokespeople”), which have already been misused in disinformation campaigns³. Even mobile apps (e.g. FaceApp, Zao) let users do basic face swaps in minutes⁴. In short, advances in GANs and related models make deepfakes cheaper and easier to generate than ever. Diagram of a generative adversarial network (GAN): A generator network creates fake images from random input and a discriminator network distinguishes fakes from real examples. Over time the generator improves until its outputs “fool” the discriminator⁵ During creation, a deepfake algorithm is typically trained on a large dataset of real images or audio from the target. The more varied and high-quality the training data, the more realistic the deepfake. The output often then undergoes post-processing (color adjustments, lip-syncing refinements) to enhance believability¹. Technical defenses focus on two fronts: detection and authentication. Detection uses AI models to spot inconsistencies (blinking irregularities, audio artifacts or metadata mismatches) that betray a synthetic origin⁵. Authentication embeds markers before dissemination – for example, invisible watermarks or cryptographically signed metadata indicating authenticity⁶. The EU AI Act will soon mandate that major AI content providers embed machine-readable “watermark” signals in synthetic media⁷. However, as GAO notes, detection is an arms race – even a marked deepfake can sometimes evade notice – and labels alone don’t stop false narratives from spreading⁸⁹. Deepfakes in Recent Elections: Examples Deepfakes and AI-generated imagery already have made headlines in election cycles around the world. In the 2024 U.S. primary season, a digitally-altered audio robocall mimicked President Biden’s voice urging Democrats not to vote in the New Hampshire primary. The caller (“Susan Anderson”) was later fined $6 million by the FCC and indicted under existing telemarketing laws¹⁰¹¹. (Importantly, FCC rules on robocalls applied regardless of AI: the perpetrator could have used a voice actor or recording instead.) Also in 2024, former President Trump posted on social media a collage implying that pop singer Taylor Swift endorsed his campaign, using AI-generated images of Swift in “Swifties for Trump” shirts¹². The posts sparked media uproar, though analysts noted the same effect could have been achieved without AI (e.g., by photoshopping text on real images)¹². Similarly, Elon Musk’s X platform carried AI-generated clips, including a parody “Ad” depicting Vice-President Harris’s voice via an AI clone¹³. Beyond the U.S., deepfake-like content has appeared globally. In Indonesia’s 2024 presidential election, a video surfaced on social media in which a convincingly generated image of the late President Suharto appeared to endorse the candidate of the Golkar Party. Days later, the endorsed candidate (who is Suharto’s son-in-law) won the presidency¹⁴. In Bangladesh, a viral deepfake video superimposed the face of opposition leader Rumeen Farhana onto a bikini-clad body – an incendiary fabrication designed to discredit her in the conservative Muslim-majority society¹⁵. Moldova’s pro-Western President Maia Sandu has been repeatedly targeted by AI-driven disinformation; one deepfake video falsely showed her resigning and endorsing a Russian-friendly party, apparently to sow distrust in the electoral process¹⁶. Even in Taiwan (amidst tensions with China), a TikTok clip circulated that synthetically portrayed a U.S. politician making foreign-policy statements – stoking confusion ahead of Taiwanese elections¹⁷. In Slovakia’s recent campaign, AI-generated audio mimicking the liberal party leader suggested he plotted vote-rigging and beer-price hikes – instantly spreading on social media just days before the election¹⁸. These examples show that deepfakes have touched diverse polities (from Bangladesh and Indonesia to Moldova, Slovakia, India and beyond), often aiming to undermine candidates or confuse voters¹⁵¹⁸. Notably, many of the most viral “deepfakes” in 2024 were actually circulated as obvious memes or claims, rather than subtle deceptions. Experts observed that outright undetectable AI deepfakes were relatively rare; more common were AI-generated memes plainly shared by partisans, or cheaply doctored “cheapfakes” made with basic editing tools¹³¹⁹. For instance, social media was awash with memes of Kamala Harris in Soviet garb or of Black Americans holding Trump signs¹³, but these were typically used satirically, not meant to be secretly believed. Nonetheless, even unsophisticated fakes can sway opinion: a U.S. study found that false presidential ads (not necessarily AI-made) did change voter attitudes in swing states. In sum, deepfakes are a real and growing phenomenon in election campaigns²⁰²¹ worldwide – a trend taken seriously by voters and regulators alike. U.S. Legal Framework and Accountability In the U.S., deepfake creators and distributors of election misinformation face a patchwork of tools, but no single comprehensive federal “deepfake law.” Existing laws relevant to disinformation include statutes against impersonating government officials, electioneering (such as the Bipartisan Campaign Reform Act, which requires disclaimers on political ads), and targeted statutes like criminal electioneering communications. In some cases ordinary laws have been stretched: the NH robocall used the Telephone Consumer Protection Act and mail/telemarketing fraud provisions, resulting in the $6M fine and a criminal charge. Similarly, voice impostors can potentially violate laws against “false advertising” or “unlawful corporate communications.” However, these laws were enacted before AI, and litigators have warned they often do not fit neatly. For example, deceptive deepfake claims not tied to a specific victim do not easily fit into defamation or privacy torts. Voter intimidation laws (prohibiting threats or coercion) also leave a gap for non-threatening falsehoods about voting logistics or endorsements. Recognizing these gaps, some courts and agencies are invoking other theories. The U.S. Department of Justice has recently charged individuals under broad fraud statutes (e.g. for a plot to impersonate an aide to swing votes in 2020), and state attorneys general have considered deepfake misinformation as interference with voting rights. Notably, the Federal Election Commission (FEC) is preparing to enforce new rules: in April 2024 it issued an advisory opinion limiting “non-candidate electioneering communications” that use falsified media, effectively requiring that political ads use only real images of the candidate. If finalized, that would make it unlawful for campaigns to pay for ads depicting a candidate saying things they never did. Similarly, the Federal Trade Commission (FTC) and Department of Justice (DOJ) have signaled that purely commercial deepfakes could violate consumer protection or election laws (for example, liability for mass false impersonation or for foreign-funded electioneering). U.S. Legislation and Proposals Federal lawmakers have proposed new statutes. The DEEPFAKES Accountability Act (H.R.5586 in the 118th Congress) would, among other things, impose a disclosure requirement: political ads featuring a manipulated media likeness would need clear disclaimers identifying the content as synthetic. It also increases penalties for producing false election videos or audio intended to influence the vote. While not yet enacted, supporters argue it would provide a uniform rule for all federal and state campaigns. The Brennan Center supports transparency requirements over outright bans, suggesting laws should narrowly target deceptive deepfakes in paid ads or certain categories (e.g. false claims about time/place/manner of voting) while carving out parody and news coverage. At the state level, over 20 states have passed deepfake laws specifically for elections. For example, Florida and California forbid distributing falsified audio/visual media of candidates with intent to deceive voters (though Florida’s law exempts parody). Some states (like Texas) define “deepfake” in statutes and allow candidates to sue or revoke candidacies of violators. These measures have had mixed success: courts have struck down overly broad provisions that acted as prior restraints (e.g. Minnesota’s 2023 law was challenged for threatening injunctions against anyone “reasonably believed” to violate it). Critically, these state laws raise First Amendment issues: political speech is highly protected, so any restriction must be tightly tailored. Already, Texas and Virginia statutes are under legal review, and Elon Musk’s company has sued under California’s law (which requires platforms to label or block deepfakes) as unconstitutional. In practice, most lawsuits have so far centered on defamation or intellectual property (for instance, a celebrity suing over a botched celebrity-deepfake video), rather than election-focused statutes. Policy Recommendations: Balancing Integrity and Speech Given the rapidly evolving technology, experts recommend a multi-pronged approach. Most stress transparency and disclosure as core principles. For example, the Brennan Center urges requiring any political communication that uses AI-synthesized images or voice to include a clear label. This could be a digital watermark or a visible disclaimer. Transparency has two advantages: it forces campaigns and platforms to “own” the use of AI, and it alerts audiences to treat the content with skepticism. Outright bans on all deepfakes would likely violate free speech, but targeted bans on specific harms (e.g. automated phone calls impersonating voters, or videos claiming false polling information) may be defensible. Indeed, Florida already penalizes misuse of recordings in voter suppression. Another recommendation is limited liability: tying penalties to demonstrable intent to mislead, not to the mere act of content creation. Both U.S. federal proposals and EU law generally condition fines on the “appearance of fraud” or deception. Technical solutions can complement laws. Watermarking original media (as encouraged by the EU AI Act) could deter the reuse of authentic images in doctored fakes. Open tools for deepfake detection – some supported by government research grants – should be deployed by fact-checkers and social platforms. Making detection datasets publicly available (e.g. the MIT OpenDATATEST) helps improve AI models to spot fakes. International cooperation is also urged: cross-border agreements on information-sharing could help trace and halt disinformation campaigns. The G7 and APEC have all recently committed to fighting election interference via AI, which may lead to joint norms or rapid response teams. Ultimately, many analysts believe the strongest “cure” is a well-informed public: education campaigns to teach voters to question sensational media, and a robust independent press to debunk falsehoods swiftly. While the law can penalize the worst offenders, awareness and resilience in the electorate are crucial buffers against influence operations. As Georgia Tech’s Sean Parker quipped in 2019, “the real question is not if deepfakes will influence elections, but who will be empowered by the first effective one.” Thus policies should aim to deter malicious use without unduly chilling innovation or satire. References: https://www.security.org/resources/deepfake-statistics/. https://www.wired.com/story/synthesia-ai-deepfakes-it-control-riparbelli/. https://www.gao.gov/products/gao-24-107292. https://technologyquotient.freshfields.com/post/102jb19/eu-ai-act-unpacked-8-new-rules-on-deepfakes. https://knightcolumbia.org/blog/we-looked-at-78-election-deepfakes-political-misinformation-is-not-an-ai-problem. https://www.npr.org/2024/12/21/nx-s1-5220301/deepfakes-memes-artificial-intelligence-elections. https://apnews.com/article/artificial-intelligence-elections-disinformation-chatgpt-bc283e7426402f0b4baa7df280a4c3fd. https://www.lawfaremedia.org/article/new-and-old-tools-to-tackle-deepfakes-and-election-lies-in-2024. https://www.brennancenter.org/our-work/research-reports/regulating-ai-deepfakes-and-synthetic-media-political-arena. https://firstamendment.mtsu.edu/article/political-deepfakes-and-elections/. https://www.ncsl.org/technology-and-communication/deceptive-audio-or-visual-media-deepfakes-2024-legislation. https://law.unh.edu/sites/default/files/media/2022/06/nagumotu_pp113-157.pdf. https://dfrlab.org/2024/10/02/brazil-election-ai-research/. https://dfrlab.org/2024/11/26/brazil-election-ai-deepfakes/. https://freedomhouse.org/article/eu-digital-services-act-win-transparency. The post The Legal Accountability of AI-Generated Deepfakes in Election Misinformation appeared first on MarkTechPost.
    0 Комментарии 0 Поделились 0 предпросмотр
  • Blackmagic Design releases DaVinci Resolve 20.0

    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ";

    A recording of Blackmagic Design’s livestream of its announcements for NAB 2025. You can see the new features in Da Vinci Resolve 20.0 at 2:13:20 in the video.

    Originally posted on 6 April 2025 for the beta, and updated for the stable release.
    Blackmagic Design has updated DaVinci Resolve, its free colour grading, editing and post-production software, and DaVinci Resolve Studio, its commercial edition.
    DaVinci Resolve Studio 20.0 is a major release, adding over 100 tools, including a set of new AI-powered features for video editing and audio production, and is free to all users.
    Below, we’ve rounded up the key features for colorists and effects artists, including a new Chroma Warp tool, a new deep compositing toolset, and full support for multi-layer EXRs.

    The new Chroma Warp tool makes it possible to create looks with intuitive gesture controls.

    Color page: New Chroma Warp, plus updates to the Resolve FX Warper and Magic Mask

    For grading, the Color page‘s Color Warper gets a new Chroma Warp tool.It is designed to create looks intuitively, with users selecting a color in the viewer, and dragging to adjust its hue and saturation simultaneously.
    Among the existing tools, the Resolve FX Warper effect gets a new Curves Warp mode, which creates a custom polygon with spline points for finer control when warping images.
    Magic Mask, DaVinci Resolve’s AI-based feature for generating mattes, has been updated, and now operates in a single mode for both people and objects.
    Workflow is also now more precise, with users now placing points to make selections, then using the paint tools to include or exclude surrounding regions of the image.
    Another key AI-based feature, the Resolve FX Depth Map effect, which automatically generates depth mattes, has been updated to improve speed and accuracy.
    For color management across a pipeline, the software has been updated to ACES 2.0, and OpenColorIO is supported as Resolve FX.

    Effects artists get deep compositing support in the integrated Fusion compositing toolset.

    Fusion: new deep compositing toolset

    For compositing and effects work, the Fusion page gets support for deep compositing.Deep compositing, long supported in more VFX-focused apps like Nuke, makes use of depth data encoded in image formats like OpenEXR to control object visibility.
    It simplifies the process of generating and managing holdouts, and generates fewer visual artifacts, particularly when working with motion blur or environment fog.
    Deep images can now be viewed in the Fusion viewer or the 3D view, and there is a new set of nodes to merge, transform, resize, crop, recolor and generate holdouts.
    It is also possible to render deep images from the 3D environment, and export them as deep EXRs via the Fusion saver node.
    Fusion: new vector warping toolset, plus support for 180 VR and multi-layer workflows

    Other new features in the Fusion page include a new optical-flow-based vector warping toolset, for image patching and cleanup, and for effects like digital makeup.There is also a new 360° Dome Light for environment lighting, and support for 180 VR, with a number of key tools updated to support 180° workflows.
    Pipeline improvements include full multi-layer workflows, with all of Fusion’s nodes now able to access each layer within multi-layer EXR or PSD files.
    Fusion also now natively supports Cryptomatte ID matte data in EXR files.
    You can read about the new features on the Fusion Page in our story on Fusion Studio 20.0, the latest version of Blackmagic Design’s standalone compositing app, in which they also feature.

    IntelliScript automatically generates an edit timeline matching a user-provided script.

    Other toolsets: lots of new AI features for video editing and audio production

    DaVinci Resolve Studio 20.0 also features a lot of new AI features powered by the software’s Neural Engine, although primarily in the video editing and audio production toolsets.The Cut and Edit pages get new AI tools for automatically creating edit timelines matching a user-provided script; generating animated subtitles; editing or extending music to match clip length; and matching tone, level and reverberance for dialogue.
    There are also new tools for recording new voiceovers during editing to match an edit.
    Workflow improvements include a dedicated curve view for keyframe editing; plus a new MultiText tool and updates to the Text+ tool for better control of the layout of on-screen text.
    For audio post work, the Fairlight page gets new AI features for removing silences from raw footage, and automatically balancing an audio mix.
    We don’t cover video or audio editing on CG Channel, but you can find a complete list of changes via the links at the foot of the story.
    Codec and format support

    Other key changes include native support for ProRes encoding on Windows and Linux systems as well as macOS.MV-HEVC encoding is now supported on systems with NVIDIA GPUs, and H.265 4:2:2 encoding and decoding are GPU-accelerated on NVIDIA’s new Blackwell GPUs.
    Again, you can find a full list of changes to codec and platform support via the links at the foot of the story.

    Upcoming features include generative AI-based background extension.

    Future updates: new toolsets for immersive video and AI background generation

    Blackmagic Design also announced two upcoming features not present in the initial release.Artists creating mixed reality content will get a new toolset for ingesting, editing and delivering immersive video for Apple’s Vision Pro headset.
    There will also be a new generative AI feature, Resolve FX AI Set Extender, available via Blackmagic Cloud.
    More details will be announced later this year, but Blackmagic says that it will enable users to generate new backgrounds for shots by entering simple text prompts.
    The video above shows a range of use cases, including extending or adding objects to existing footage, and generating a complete new background behind a foreground object.
    Price, system requirements and release date

    DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0 are for Windows 10+, Rocky Linux 8.6, and macOS 14.0+. The updates are free to existing users.New perpetual licenses of the base edition are also free.
    The Studio edition, which adds AI features, stereoscopic 3D tools, and collaboration features, costs following a temporary increase in the US following the introduction of new tariffs.
    Read a full list of new features in DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0

    Have your say on this story by following CG Channel on Facebook, Instagram and X. As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects.
    #blackmagic #design #releases #davinci #resolve
    Blackmagic Design releases DaVinci Resolve 20.0
    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "; A recording of Blackmagic Design’s livestream of its announcements for NAB 2025. You can see the new features in Da Vinci Resolve 20.0 at 2:13:20 in the video. Originally posted on 6 April 2025 for the beta, and updated for the stable release. Blackmagic Design has updated DaVinci Resolve, its free colour grading, editing and post-production software, and DaVinci Resolve Studio, its commercial edition. DaVinci Resolve Studio 20.0 is a major release, adding over 100 tools, including a set of new AI-powered features for video editing and audio production, and is free to all users. Below, we’ve rounded up the key features for colorists and effects artists, including a new Chroma Warp tool, a new deep compositing toolset, and full support for multi-layer EXRs. The new Chroma Warp tool makes it possible to create looks with intuitive gesture controls. Color page: New Chroma Warp, plus updates to the Resolve FX Warper and Magic Mask For grading, the Color page‘s Color Warper gets a new Chroma Warp tool.It is designed to create looks intuitively, with users selecting a color in the viewer, and dragging to adjust its hue and saturation simultaneously. Among the existing tools, the Resolve FX Warper effect gets a new Curves Warp mode, which creates a custom polygon with spline points for finer control when warping images. Magic Mask, DaVinci Resolve’s AI-based feature for generating mattes, has been updated, and now operates in a single mode for both people and objects. Workflow is also now more precise, with users now placing points to make selections, then using the paint tools to include or exclude surrounding regions of the image. Another key AI-based feature, the Resolve FX Depth Map effect, which automatically generates depth mattes, has been updated to improve speed and accuracy. For color management across a pipeline, the software has been updated to ACES 2.0, and OpenColorIO is supported as Resolve FX. Effects artists get deep compositing support in the integrated Fusion compositing toolset. Fusion: new deep compositing toolset For compositing and effects work, the Fusion page gets support for deep compositing.Deep compositing, long supported in more VFX-focused apps like Nuke, makes use of depth data encoded in image formats like OpenEXR to control object visibility. It simplifies the process of generating and managing holdouts, and generates fewer visual artifacts, particularly when working with motion blur or environment fog. Deep images can now be viewed in the Fusion viewer or the 3D view, and there is a new set of nodes to merge, transform, resize, crop, recolor and generate holdouts. It is also possible to render deep images from the 3D environment, and export them as deep EXRs via the Fusion saver node. Fusion: new vector warping toolset, plus support for 180 VR and multi-layer workflows Other new features in the Fusion page include a new optical-flow-based vector warping toolset, for image patching and cleanup, and for effects like digital makeup.There is also a new 360° Dome Light for environment lighting, and support for 180 VR, with a number of key tools updated to support 180° workflows. Pipeline improvements include full multi-layer workflows, with all of Fusion’s nodes now able to access each layer within multi-layer EXR or PSD files. Fusion also now natively supports Cryptomatte ID matte data in EXR files. You can read about the new features on the Fusion Page in our story on Fusion Studio 20.0, the latest version of Blackmagic Design’s standalone compositing app, in which they also feature. IntelliScript automatically generates an edit timeline matching a user-provided script. Other toolsets: lots of new AI features for video editing and audio production DaVinci Resolve Studio 20.0 also features a lot of new AI features powered by the software’s Neural Engine, although primarily in the video editing and audio production toolsets.The Cut and Edit pages get new AI tools for automatically creating edit timelines matching a user-provided script; generating animated subtitles; editing or extending music to match clip length; and matching tone, level and reverberance for dialogue. There are also new tools for recording new voiceovers during editing to match an edit. Workflow improvements include a dedicated curve view for keyframe editing; plus a new MultiText tool and updates to the Text+ tool for better control of the layout of on-screen text. For audio post work, the Fairlight page gets new AI features for removing silences from raw footage, and automatically balancing an audio mix. We don’t cover video or audio editing on CG Channel, but you can find a complete list of changes via the links at the foot of the story. Codec and format support Other key changes include native support for ProRes encoding on Windows and Linux systems as well as macOS.MV-HEVC encoding is now supported on systems with NVIDIA GPUs, and H.265 4:2:2 encoding and decoding are GPU-accelerated on NVIDIA’s new Blackwell GPUs. Again, you can find a full list of changes to codec and platform support via the links at the foot of the story. Upcoming features include generative AI-based background extension. Future updates: new toolsets for immersive video and AI background generation Blackmagic Design also announced two upcoming features not present in the initial release.Artists creating mixed reality content will get a new toolset for ingesting, editing and delivering immersive video for Apple’s Vision Pro headset. There will also be a new generative AI feature, Resolve FX AI Set Extender, available via Blackmagic Cloud. More details will be announced later this year, but Blackmagic says that it will enable users to generate new backgrounds for shots by entering simple text prompts. The video above shows a range of use cases, including extending or adding objects to existing footage, and generating a complete new background behind a foreground object. Price, system requirements and release date DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0 are for Windows 10+, Rocky Linux 8.6, and macOS 14.0+. The updates are free to existing users.New perpetual licenses of the base edition are also free. The Studio edition, which adds AI features, stereoscopic 3D tools, and collaboration features, costs following a temporary increase in the US following the introduction of new tariffs. Read a full list of new features in DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0 Have your say on this story by following CG Channel on Facebook, Instagram and X. As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects. #blackmagic #design #releases #davinci #resolve
    WWW.CGCHANNEL.COM
    Blackmagic Design releases DaVinci Resolve 20.0
    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd" A recording of Blackmagic Design’s livestream of its announcements for NAB 2025. You can see the new features in Da Vinci Resolve 20.0 at 2:13:20 in the video. Originally posted on 6 April 2025 for the beta, and updated for the stable release. Blackmagic Design has updated DaVinci Resolve, its free colour grading, editing and post-production software, and DaVinci Resolve Studio, its $295 commercial edition. DaVinci Resolve Studio 20.0 is a major release, adding over 100 tools, including a set of new AI-powered features for video editing and audio production, and is free to all users. Below, we’ve rounded up the key features for colorists and effects artists, including a new Chroma Warp tool, a new deep compositing toolset, and full support for multi-layer EXRs. The new Chroma Warp tool makes it possible to create looks with intuitive gesture controls. Color page: New Chroma Warp, plus updates to the Resolve FX Warper and Magic Mask For grading, the Color page‘s Color Warper gets a new Chroma Warp tool.It is designed to create looks intuitively, with users selecting a color in the viewer, and dragging to adjust its hue and saturation simultaneously. Among the existing tools, the Resolve FX Warper effect gets a new Curves Warp mode, which creates a custom polygon with spline points for finer control when warping images. Magic Mask, DaVinci Resolve’s AI-based feature for generating mattes, has been updated, and now operates in a single mode for both people and objects. Workflow is also now more precise, with users now placing points to make selections, then using the paint tools to include or exclude surrounding regions of the image. Another key AI-based feature, the Resolve FX Depth Map effect, which automatically generates depth mattes, has been updated to improve speed and accuracy. For color management across a pipeline, the software has been updated to ACES 2.0, and OpenColorIO is supported as Resolve FX. Effects artists get deep compositing support in the integrated Fusion compositing toolset. Fusion: new deep compositing toolset For compositing and effects work, the Fusion page gets support for deep compositing.Deep compositing, long supported in more VFX-focused apps like Nuke, makes use of depth data encoded in image formats like OpenEXR to control object visibility. It simplifies the process of generating and managing holdouts, and generates fewer visual artifacts, particularly when working with motion blur or environment fog. Deep images can now be viewed in the Fusion viewer or the 3D view, and there is a new set of nodes to merge, transform, resize, crop, recolor and generate holdouts. It is also possible to render deep images from the 3D environment, and export them as deep EXRs via the Fusion saver node. Fusion: new vector warping toolset, plus support for 180 VR and multi-layer workflows Other new features in the Fusion page include a new optical-flow-based vector warping toolset, for image patching and cleanup, and for effects like digital makeup.There is also a new 360° Dome Light for environment lighting, and support for 180 VR, with a number of key tools updated to support 180° workflows. Pipeline improvements include full multi-layer workflows, with all of Fusion’s nodes now able to access each layer within multi-layer EXR or PSD files. Fusion also now natively supports Cryptomatte ID matte data in EXR files. You can read about the new features on the Fusion Page in our story on Fusion Studio 20.0, the latest version of Blackmagic Design’s standalone compositing app, in which they also feature. IntelliScript automatically generates an edit timeline matching a user-provided script. Other toolsets: lots of new AI features for video editing and audio production DaVinci Resolve Studio 20.0 also features a lot of new AI features powered by the software’s Neural Engine, although primarily in the video editing and audio production toolsets.The Cut and Edit pages get new AI tools for automatically creating edit timelines matching a user-provided script; generating animated subtitles; editing or extending music to match clip length; and matching tone, level and reverberance for dialogue. There are also new tools for recording new voiceovers during editing to match an edit. Workflow improvements include a dedicated curve view for keyframe editing; plus a new MultiText tool and updates to the Text+ tool for better control of the layout of on-screen text. For audio post work, the Fairlight page gets new AI features for removing silences from raw footage, and automatically balancing an audio mix. We don’t cover video or audio editing on CG Channel, but you can find a complete list of changes via the links at the foot of the story. Codec and format support Other key changes include native support for ProRes encoding on Windows and Linux systems as well as macOS.MV-HEVC encoding is now supported on systems with NVIDIA GPUs, and H.265 4:2:2 encoding and decoding are GPU-accelerated on NVIDIA’s new Blackwell GPUs. Again, you can find a full list of changes to codec and platform support via the links at the foot of the story. Upcoming features include generative AI-based background extension. Future updates: new toolsets for immersive video and AI background generation Blackmagic Design also announced two upcoming features not present in the initial release.Artists creating mixed reality content will get a new toolset for ingesting, editing and delivering immersive video for Apple’s Vision Pro headset. There will also be a new generative AI feature, Resolve FX AI Set Extender, available via Blackmagic Cloud. More details will be announced later this year, but Blackmagic says that it will enable users to generate new backgrounds for shots by entering simple text prompts. The video above shows a range of use cases, including extending or adding objects to existing footage, and generating a complete new background behind a foreground object. Price, system requirements and release date DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0 are for Windows 10+, Rocky Linux 8.6, and macOS 14.0+. The updates are free to existing users.New perpetual licenses of the base edition are also free. The Studio edition, which adds AI features, stereoscopic 3D tools, and collaboration features, costs $295, following a temporary increase in the US following the introduction of new tariffs. Read a full list of new features in DaVinci Resolve 20.0 and DaVinci Resolve Studio 20.0 Have your say on this story by following CG Channel on Facebook, Instagram and X (formerly Twitter). As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects.
    0 Комментарии 0 Поделились 0 предпросмотр
  • No candidates for 43% of seats in RIBA council elections 2025

    Source:&nbsp Shutterstock
    More than 40 per cent of seats on the RIBA council for the upcoming elections have no candidates – and there is zero interest in two entire regions, it has emerged

    A list of candidates for next month’s elections to RIBA council and for the role of vice-president membership, published earlier this month, shows six of 14 seats on the council have no candidates for the vote starting on 16 June.
    That includes two seats for the South and two seats for East, where ‘no valid nominations were received’ for either of the regional places on RIBA council.
    Meanwhile, two seats – Scotland North and Northern Ireland – will see candidates elected unopposed, due to there being no other interest in representing. No valid nominations were received for two associate member seats.Advertisement

    However, six candidates were named for the two student seats on the council. They are: Selen Akalin, Tamunokuro Krukrubo, Rachael Livingstone, AB Mukadam, Kavindu Narayana and Andrew Pizzey.
    Another four candidates are competing for two non-regional council member seats. They are: Daniel Jenkins, Laura Marr, Olga Tarasova and Rebecca Wise.
    The vice-president membership role has attracted eight candidates. They include Jaspal Bhogal, director of Jaspal Bhogal Associates; Sheleendra Fernando, managing director of 24/Three; Thomas Foggin, director and sustainable lead of R H Partnership Architects, and Douglas Hodgson, founding director of New-works.
    The other candidates are Patricia Leo, director of Studio NP; Gareth Maguire, chief architect of Studio MUA; Elliot McCall, architect at Inspire Architects; and Liam Russell, founder and chief executive officer of LRA Retinue.
    RIBA council has 42 members with around a third of the seats rotating every three years.Advertisement

    Successfully elected candidates will serve in their roles for three years, starting 1 September 2025 – the same day Weston Williamson + Partners co-founder Chris Williamson becomes RIBA president.
    Williamson was elected as president-elect last year with 45 per cent of the second-round vote with a total of 4,462 votes cast. However, turnout was just 9.3 per cent.
    Williamson told the AJ: ‘I was pleased with the applications for Membership Secretary but, yes, it’s disappointing that other positions are not contested. I think many architects are concentrating on their work right now.’
    The Just Transition Lobby coalition of campaign groups, which successfully campaigned for Oki to become president in 2022 and has elected half a dozen RIBA members to council in the past two years, has not, as yet, announced any candidates at this election.
    The RIBA has been contacted for comment.

    2025-05-30
    Gino Spocchia

    comment and share
    #candidates #seats #riba #council #elections
    No candidates for 43% of seats in RIBA council elections 2025
    Source:&nbsp Shutterstock More than 40 per cent of seats on the RIBA council for the upcoming elections have no candidates – and there is zero interest in two entire regions, it has emerged A list of candidates for next month’s elections to RIBA council and for the role of vice-president membership, published earlier this month, shows six of 14 seats on the council have no candidates for the vote starting on 16 June. That includes two seats for the South and two seats for East, where ‘no valid nominations were received’ for either of the regional places on RIBA council. Meanwhile, two seats – Scotland North and Northern Ireland – will see candidates elected unopposed, due to there being no other interest in representing. No valid nominations were received for two associate member seats.Advertisement However, six candidates were named for the two student seats on the council. They are: Selen Akalin, Tamunokuro Krukrubo, Rachael Livingstone, AB Mukadam, Kavindu Narayana and Andrew Pizzey. Another four candidates are competing for two non-regional council member seats. They are: Daniel Jenkins, Laura Marr, Olga Tarasova and Rebecca Wise. The vice-president membership role has attracted eight candidates. They include Jaspal Bhogal, director of Jaspal Bhogal Associates; Sheleendra Fernando, managing director of 24/Three; Thomas Foggin, director and sustainable lead of R H Partnership Architects, and Douglas Hodgson, founding director of New-works. The other candidates are Patricia Leo, director of Studio NP; Gareth Maguire, chief architect of Studio MUA; Elliot McCall, architect at Inspire Architects; and Liam Russell, founder and chief executive officer of LRA Retinue. RIBA council has 42 members with around a third of the seats rotating every three years.Advertisement Successfully elected candidates will serve in their roles for three years, starting 1 September 2025 – the same day Weston Williamson + Partners co-founder Chris Williamson becomes RIBA president. Williamson was elected as president-elect last year with 45 per cent of the second-round vote with a total of 4,462 votes cast. However, turnout was just 9.3 per cent. Williamson told the AJ: ‘I was pleased with the applications for Membership Secretary but, yes, it’s disappointing that other positions are not contested. I think many architects are concentrating on their work right now.’ The Just Transition Lobby coalition of campaign groups, which successfully campaigned for Oki to become president in 2022 and has elected half a dozen RIBA members to council in the past two years, has not, as yet, announced any candidates at this election. The RIBA has been contacted for comment. 2025-05-30 Gino Spocchia comment and share #candidates #seats #riba #council #elections
    WWW.ARCHITECTSJOURNAL.CO.UK
    No candidates for 43% of seats in RIBA council elections 2025
    Source:&nbsp Shutterstock More than 40 per cent of seats on the RIBA council for the upcoming elections have no candidates – and there is zero interest in two entire regions, it has emerged A list of candidates for next month’s elections to RIBA council and for the role of vice-president membership, published earlier this month, shows six of 14 seats on the council have no candidates for the vote starting on 16 June. That includes two seats for the South and two seats for East, where ‘no valid nominations were received’ for either of the regional places on RIBA council. Meanwhile, two seats – Scotland North and Northern Ireland – will see candidates elected unopposed, due to there being no other interest in representing. No valid nominations were received for two associate member seats.Advertisement However, six candidates were named for the two student seats on the council. They are: Selen Akalin, Tamunokuro Krukrubo, Rachael Livingstone, AB Mukadam, Kavindu Narayana and Andrew Pizzey. Another four candidates are competing for two non-regional council member seats. They are: Daniel Jenkins, Laura Marr, Olga Tarasova and Rebecca Wise. The vice-president membership role has attracted eight candidates. They include Jaspal Bhogal, director of Jaspal Bhogal Associates; Sheleendra Fernando, managing director of 24/Three; Thomas Foggin, director and sustainable lead of R H Partnership Architects, and Douglas Hodgson, founding director of New-works. The other candidates are Patricia Leo, director of Studio NP; Gareth Maguire, chief architect of Studio MUA; Elliot McCall, architect at Inspire Architects; and Liam Russell, founder and chief executive officer of LRA Retinue. RIBA council has 42 members with around a third of the seats rotating every three years.Advertisement Successfully elected candidates will serve in their roles for three years, starting 1 September 2025 – the same day Weston Williamson + Partners co-founder Chris Williamson becomes RIBA president. Williamson was elected as president-elect last year with 45 per cent of the second-round vote with a total of 4,462 votes cast. However, turnout was just 9.3 per cent (compared with 12.4 per cent for Mace architect Muyiwa Oki when he was elected in 2022). Williamson told the AJ: ‘I was pleased with the applications for Membership Secretary but, yes, it’s disappointing that other positions are not contested. I think many architects are concentrating on their work right now.’ The Just Transition Lobby coalition of campaign groups, which successfully campaigned for Oki to become president in 2022 and has elected half a dozen RIBA members to council in the past two years, has not, as yet, announced any candidates at this election. The RIBA has been contacted for comment. 2025-05-30 Gino Spocchia comment and share
    0 Комментарии 0 Поделились 0 предпросмотр
  • Boris FX releases Silhouette 2025

    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ";

    Boris FX has begun its 2025 updates to Silhouette, its roto and paint software.Silhouette 2025 adds new AI tools for refining mattes, generating depth maps and fixing glitches in video, and a new 3D Scene node for importing scenes with tracked 3D cameras.
    A VFX-industry standard tool for rotoscoping and roto paint work

    First released 20 years ago, and acquired by Boris FX in 2019, Silhouette is a rotoscoping and paint tool.The software is widely used in production for movie and broadcast visual effects, winning both a Scientific and Technical Academy Award and Engineering Emmy Award in 2019.
    As well as the original standalone edition, Silhouette is available as a plugin, making the toolset available inside Adobe software and OFX-compatible apps like Nuke and DaVinci Resolve.
    New AI tools for refining mattes, generating depth maps, and fixing glitches

    Silhouette 2025 introduces new AI-based features for automating common tasks.The 2024 releases added an AI-based matte workflow, with the Mask ML node automatically generating a mask for a significant object – like a person or animal – in a frame of video, and Matte Assist ML propagating it throughout the rest of the footage.
    They are now joined by Matte Refine ML, a new node for processing hard-edge mattes into “natural, detailed selections”, creating better results when isolating hair or fur.
    In addition, new Depth Map ML and Frame Fixer ML tools generate depth maps from footage, and semi-automatically fix artifacts like scratches, camera flashes, or dropped frames.
    You can read more about them in our story on Continuum 2025.5, Silhouette’s sibling tool.
    New 3D Scene node lets users work with tracked 3D cameras

    Other new features in Silhouette 2025 include the new 3D environment.The 3D Scene node makes it possible to load a scene with a tracked 3D camera in FBX or Alembic format, or to perform a 3D track using Mocha Pro or SynthEyes.
    It is then possible to place cards in 3D space and paint directly on them in the viewer, while a new Unproject/Reproject node allows for fuller composites.
    Other new features

    When using a PowerMesh from Silhouette’s Mocha module to track deforming organic surfaces, it is now possible to paint on undistorted frames using a new PowerMesh Morph node.In addition, it is now possible to merge custom node setups into a single Compound node, which can be reused between projects or shared with collaborators.
    Prices up since the previous release

    The price of the software has also risen since Silhouette 2024.5, although the increases aren’t as large as with some of Boris FX’s other recent product updates.For the standalone edition, the price of perpetual licenses rise by to Subscriptions rise by /month, to /month, or by /year, to /year.
    For the plugin edition, the price of perpetual licenses rise by to Subscriptions rise by /month, to /month, or by /year, to /year.
    Price and system requirements

    Silhouette 2025 is available as a standalone tool for Windows 10+, Linux and macOS 12.0+, and as a plugin for Adobe software and OFX-compatible tools like Nuke.Perpetual licences of the standalone cost ; the plugin costs Rental costs /month or /year for the standalone; /month or /year for the plugin.
    Read a list of new features in Silhouette 2025 on Boris FX’s blog

    Have your say on this story by following CG Channel on Facebook, Instagram and X. As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects.
    #boris #releases #silhouette
    Boris FX releases Silhouette 2025
    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "; Boris FX has begun its 2025 updates to Silhouette, its roto and paint software.Silhouette 2025 adds new AI tools for refining mattes, generating depth maps and fixing glitches in video, and a new 3D Scene node for importing scenes with tracked 3D cameras. A VFX-industry standard tool for rotoscoping and roto paint work First released 20 years ago, and acquired by Boris FX in 2019, Silhouette is a rotoscoping and paint tool.The software is widely used in production for movie and broadcast visual effects, winning both a Scientific and Technical Academy Award and Engineering Emmy Award in 2019. As well as the original standalone edition, Silhouette is available as a plugin, making the toolset available inside Adobe software and OFX-compatible apps like Nuke and DaVinci Resolve. New AI tools for refining mattes, generating depth maps, and fixing glitches Silhouette 2025 introduces new AI-based features for automating common tasks.The 2024 releases added an AI-based matte workflow, with the Mask ML node automatically generating a mask for a significant object – like a person or animal – in a frame of video, and Matte Assist ML propagating it throughout the rest of the footage. They are now joined by Matte Refine ML, a new node for processing hard-edge mattes into “natural, detailed selections”, creating better results when isolating hair or fur. In addition, new Depth Map ML and Frame Fixer ML tools generate depth maps from footage, and semi-automatically fix artifacts like scratches, camera flashes, or dropped frames. You can read more about them in our story on Continuum 2025.5, Silhouette’s sibling tool. New 3D Scene node lets users work with tracked 3D cameras Other new features in Silhouette 2025 include the new 3D environment.The 3D Scene node makes it possible to load a scene with a tracked 3D camera in FBX or Alembic format, or to perform a 3D track using Mocha Pro or SynthEyes. It is then possible to place cards in 3D space and paint directly on them in the viewer, while a new Unproject/Reproject node allows for fuller composites. Other new features When using a PowerMesh from Silhouette’s Mocha module to track deforming organic surfaces, it is now possible to paint on undistorted frames using a new PowerMesh Morph node.In addition, it is now possible to merge custom node setups into a single Compound node, which can be reused between projects or shared with collaborators. Prices up since the previous release The price of the software has also risen since Silhouette 2024.5, although the increases aren’t as large as with some of Boris FX’s other recent product updates.For the standalone edition, the price of perpetual licenses rise by to Subscriptions rise by /month, to /month, or by /year, to /year. For the plugin edition, the price of perpetual licenses rise by to Subscriptions rise by /month, to /month, or by /year, to /year. Price and system requirements Silhouette 2025 is available as a standalone tool for Windows 10+, Linux and macOS 12.0+, and as a plugin for Adobe software and OFX-compatible tools like Nuke.Perpetual licences of the standalone cost ; the plugin costs Rental costs /month or /year for the standalone; /month or /year for the plugin. Read a list of new features in Silhouette 2025 on Boris FX’s blog Have your say on this story by following CG Channel on Facebook, Instagram and X. As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects. #boris #releases #silhouette
    Boris FX releases Silhouette 2025
    html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd" Boris FX has begun its 2025 updates to Silhouette, its roto and paint software.Silhouette 2025 adds new AI tools for refining mattes, generating depth maps and fixing glitches in video, and a new 3D Scene node for importing scenes with tracked 3D cameras. A VFX-industry standard tool for rotoscoping and roto paint work First released 20 years ago, and acquired by Boris FX in 2019, Silhouette is a rotoscoping and paint tool.The software is widely used in production for movie and broadcast visual effects, winning both a Scientific and Technical Academy Award and Engineering Emmy Award in 2019. As well as the original standalone edition, Silhouette is available as a plugin, making the toolset available inside Adobe software and OFX-compatible apps like Nuke and DaVinci Resolve. New AI tools for refining mattes, generating depth maps, and fixing glitches Silhouette 2025 introduces new AI-based features for automating common tasks.The 2024 releases added an AI-based matte workflow, with the Mask ML node automatically generating a mask for a significant object – like a person or animal – in a frame of video, and Matte Assist ML propagating it throughout the rest of the footage. They are now joined by Matte Refine ML, a new node for processing hard-edge mattes into “natural, detailed selections”, creating better results when isolating hair or fur. In addition, new Depth Map ML and Frame Fixer ML tools generate depth maps from footage, and semi-automatically fix artifacts like scratches, camera flashes, or dropped frames. You can read more about them in our story on Continuum 2025.5, Silhouette’s sibling tool. New 3D Scene node lets users work with tracked 3D cameras Other new features in Silhouette 2025 include the new 3D environment.The 3D Scene node makes it possible to load a scene with a tracked 3D camera in FBX or Alembic format, or to perform a 3D track using Mocha Pro or SynthEyes. It is then possible to place cards in 3D space and paint directly on them in the viewer, while a new Unproject/Reproject node allows for fuller composites. Other new features When using a PowerMesh from Silhouette’s Mocha module to track deforming organic surfaces, it is now possible to paint on undistorted frames using a new PowerMesh Morph node.In addition, it is now possible to merge custom node setups into a single Compound node, which can be reused between projects or shared with collaborators. Prices up since the previous release The price of the software has also risen since Silhouette 2024.5, although the increases aren’t as large as with some of Boris FX’s other recent product updates.For the standalone edition, the price of perpetual licenses rise by $200, to $2,195. Subscriptions rise by $15/month, to $165/month, or by $80/year, to $875/year. For the plugin edition, the price of perpetual licenses rise by $100, to $1,195. Subscriptions rise by $3/month, to $103/month, or by $50/year, to $545/year. Price and system requirements Silhouette 2025 is available as a standalone tool for Windows 10+, Linux and macOS 12.0+, and as a plugin for Adobe software and OFX-compatible tools like Nuke.Perpetual licences of the standalone cost $2,195; the plugin costs $1,195. Rental costs $165/month or $875/year for the standalone; $103/month or $545/year for the plugin. Read a list of new features in Silhouette 2025 on Boris FX’s blog Have your say on this story by following CG Channel on Facebook, Instagram and X (formerly Twitter). As well as being able to comment on stories, followers of our social media accounts can see videos we don’t post on the site itself, including making-ofs for the latest VFX movies, animations, games cinematics and motion graphics projects.
    0 Комментарии 0 Поделились 0 предпросмотр
  • Excel for Microsoft 365 cheat sheet

    Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel.

    Excel is, of course, part of Microsoft’s Office suite of productivity tools. Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever, or they can purchase a Microsoft 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee.

    When you purchase a perpetual version of the suite — say, Office 2021 or Office 2024 — its applications will never get new features, whereas Microsoft 365 apps are continually updated with new features. For more details, see our in-depth comparison of the two Office models.

    This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years.We’ll periodically update this story as new features roll out.

    In this article

    Use the Ribbon

    Search to get tasks done quickly

    Explore Excel’s advanced chart types

    Collaborate in real time

    Take advantage of linked data

    Make your own custom views of a worksheet

    Create dynamic arrays and charts

    Use AutoSave to provide a safety net as you work

    Review or restore earlier versions of a spreadsheet

    Try out Microsoft 365 Copilot in Excel — but don’t expect too much

    Other new features to check out

    Use keyboard shortcuts

    Use the Ribbon

    The Ribbon interface, which puts commonly used commands in a tabbed toolbar running across the top of the application window, is alive and well in the current version of Excel. Microsoft has tweaked the Ribbon’s looks numerous times over the years, but it still works the same way it always has: just click one of the Ribbon’s tabs to see related commands on the toolbar. For example, click Insert to find buttons for inserting tables, PivotTables, charts, and more.

    Through the years, Excel’s Ribbon has gotten a variety of cosmetic changes, but it still works largely the way it always has.
    Preston Gralla / Foundry

    Just as in previous versions of Excel, if you want the Ribbon commands to go away, press Ctrl-F1 or click the name of the tab you’re currently on.To make the commands reappear, press Ctrl-F1 again or click any tab name.

    You’ve got other options for displaying the Ribbon as well. To get to them, click the Ribbon display options iconon the bottom of the Ribbon at the far right, just below the Share button. A drop-down menu appears with these four options:

    Full-screen mode: This makes Excel take up your entire screen and hides the Ribbon. To get out of full-screen mode, click the three-dot icon at the upper right of the screen.

    Show tabs only: This shows the tabs but hides the commands underneath them. It’s the same as pressing Ctrl-F1. To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display options down arrow and select Always show Ribbon.

    Always show Ribbon: This displays the entire Ribbon, both the tabs and commands underneath them.

    Show/Hide Quick Access toolbar: This displays or hides the Quick Access toolbar, which gives you fast access to Excel commands you want to have available no matter which tab you’re on. When you enable the toolbar, it starts off empty. To populate it, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, choose which features to put on it. If you don’t see a command you want, click More Commands. Find the command you want on the left and click Add.

    You can have the toolbar appear either at the top of the screen, just to the right of the AutoSave button, or just underneath the Ribbon. To move it from one place to another, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, select either Show below the Ribbon or Show above the Ribbon. 

    Microsoft has for many years teased a simplified version of the Ribbon that hides most of the commands to reduce clutter. That simplified Ribbon is available in the Excel web app, but there’s currently no sign that it will appear in the Excel desktop app.

    There’s a useful feature in what Microsoft calls the backstage area that appears when you click the File tab on the Ribbon. If you click Open or a Copy from the menu on the left, you can see the cloud-based services you’ve connected to your Office account, such as SharePoint and OneDrive. Each location displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business. You’ll be able to see at a glance which is which.

    Click the Add a service dropdown to add another cloud storage account.
    Preston Gralla / Foundry

    Search to get tasks done quickly

    Excel has never been the most user-friendly of applications, and it has so many powerful features it can be tough to keep track of them all. That’s where the handy Search feature comes in.

    To use it, click in the Search box — it’s above the Ribbon in the green title area.Then type in a task you want to do. If you want to summarize your spreadsheet data using a PivotTable, for example, type in something like summarize with pivot table. You’ll get a menu showing potential matches for the task. In this instance, the top result is a direct link to the form for summarizing with a PivotTable — select it and you’ll start your task right away, without having to go to the Ribbon’s Insert tab first.

    The search box makes it easy to perform just about any task in Excel.
    Preston Gralla / Foundry

    If you’d like more information about your task, the final items that appear in the menu let you select from related Help topics.

    Even if you consider yourself a spreadsheet jockey, it’s worth your while to try out the enhanced search function. It’s a big time-saver, and far more efficient than hunting through the Ribbon to find a command.

    Also useful is that it remembers the features you’ve previously clicked on in the box, so when you click in it, you first see a list of previous tasks you’ve searched for. That makes sure that tasks that you frequently perform are always within easy reach. And it puts tasks you rarely do within easy reach as well.

    Users of enterprise and education editions of Microsoft 365 can also use the Search box to find people in their organization, SharePoint resources, and other personalized results from within Excel.Explore Excel’s advanced chart types

    Charts are great for visualizing and presenting spreadsheet data, and for gaining insights from it. To that end, Microsoft has introduced a number of advanced chart types over the past several years, including most notably a histogram, a “waterfall” that’s effective at showing running financial totals, and a hierarchical treemap that helps you find patterns in data.

    Note that the new charts are available only if you’re working in an .xlsx document. If you use the older .xls format, you won’t find them.

    To see all the charts, put your cursor in a cell or group of cells that contains data, select Insert > Recommended Charts and click the All Charts tab. You’ll find the newer charts, mixed in with the older ones. Select any to create the chart.Excel includes several advanced chart types, including waterfall.
    Preston Gralla / Foundry

    These are the new chart types:

    Treemap. This chart type creates a hierarchical view of your data, with top-level categoriesshown as rectangles, and with subcategoriesshown as smaller rectangles grouped inside the larger ones. Thus, you can easily compare the sizes of top-level categories and subcategories in a single view. For instance, a bookstore can see at a glance that it brings in more revenue from 1st Readers, a subcategory of Children’s Books, than for the entire Non-fiction top-level category.

    srcset=" 830w, 300w, 768w, 264w, 132w, 753w, 565w, 392w" width="830" height="529" sizes="100vw, 830px">A treemap chart lets you easily compare top-level categories and subcategories in a single view.
    Preston Gralla / Foundry

    Sunburst. This chart type also displays hierarchical data, but in a multi-level pie chart. Each level of the hierarchy is represented by a circle. The innermost circle contains the top-level categories, the next circle out shows subcategories, the circle after that subsubcategories and so on.

    Sunbursts are best for showing the relationships among categories and subcategories, while treemaps are better at showing the relative sizes of categories and subcategories.

    A sunburst chart shows hierarchical data such as book categories and subcategories as a multi-level pie chart.
    Preston Gralla / Foundry

    Waterfall. This chart type is well-suited for visualizing financial statements. It displays a running total of the positive and negative contributions toward a final net value.

    A waterfall chart shows a running total of positive and negative contributions, such as revenue and expenses, toward a final net value.
    Preston Gralla / Foundry

    Histogram. This kind of chart shows frequencies within a data set. It could, for example, show the number of books sold in specific price ranges in a bookstore.

    Histograms are good for showing frequencies, such as number of books sold at various price points.
    Preston Gralla / Foundry

    Pareto. This chart, also known as a sorted histogram, contains bars as well as a line graph. Values are represented in descending order by bars. The cumulative total percentage of each bar is represented by a rising line. In the bookstore example, each bar could show a reason for a book being returned. The chart would show, at a glance, the primary reasons for returns, so a bookstore owner could focus on those issues.

    Note that the Pareto chart does not show up when you select Insert > Recommended Charts > All Charts. To use it, first select the data you want to chart, then select Insert > Insert Statistic Chart, and under Histogram, choose Pareto.

    In a Pareto chart, or sorted histogram, a rising line represents the cumulative total percentage of the items being measured. In this example, it’s easy to see that more than 80% of a bookstore’s returns are attributable to three problems.
    Preston Gralla / Foundry

    Box & Whisker. This chart, like a histogram, shows frequencies within a data set but provides for a deeper analysis than a histogram. For example, in a bookstore it could show the distribution of prices of different genres of books. In the example shown here, each “box” represents the first to third quartile of prices for books in that genre, while the “whiskers”show the upper and lower range of prices. Outliers that are priced outside the whiskers are shown as dots, the median price for each genre is shown with a horizontal line across the box, and the mean price is shown with an x.

    Box & Whisker charts can show details about data ranges such as the first to third quartile in the “boxes,” median and mean inside the boxes, upper and lower range with the “whiskers,” and outliers with dots.Preston Gralla / Foundry

    Funnel. This chart type is useful when you want to display values at multiple stages in a process. A funnel chart can show the number of sales prospects at every stage of a sales process, for example, with prospects at the top for the first stage, qualified prospects underneath it for the second stage, and so on, until you get to the final stage, closed sales. Generally, the values in funnel charts decrease with each stage, so the bars in the chart look like a funnel.

    Funnel charts let you display values at multiple stages in a process.
    Preston Gralla / Foundry

    When creating the data for a funnel chart, use one column for the stages in the process you’re charting, and a second column for the values for each stage. Once you’ve done that, to create the chart, select the data, then select Insert > Recommended Charts > All Charts > Funnel.

    Map. Map charts do exactly what you think they should: They let you compare data across different geographical regions, such as countries, regions, states, counties, or postal codes. Excel will automatically recognize the regions and create a map that visualizes the data.

    You can compare data across different locations with a map chart.
    Preston Gralla / Foundry

    To create a map chart, select the data you want to chart, then select Insert > Maps, then select the map chart. Note that in some instances, Excel might have a problem creating the map — for example, if there are multiple locations with the same name as one that you’re mapping. If that occurs, you’ll have to add one or more columns with details about the locations. If, say, you’re charting towns in the United Kingdom, you would have to include columns for the county and country each town is located in.

    Collaborate in real time

    For those who frequently collaborate with others, a welcome feature in Excel for Microsoft 365 is real-time collaboration that lets people work on spreadsheets together from anywhere in the world with an internet connection. Microsoft calls this “co-authoring.”

    Note that in order to use co-authoring, the spreadsheet must be stored in OneDrive, OneDrive for Business, or SharePoint Online, and you must be logged into your Microsoft 365 account. Also, co-authoring works in Excel only if you have AutoSave turned on. To do it, choose the On option on the AutoSave slider at the top left of the screen.

    To share a spreadsheet so you can collaborate on it with others: first open it, then click the Share button on the upper-right of the Excel screen. The “Send link” window pops up. Here you can send an email with a link where others can access the spreadsheet.

    Use the “Send link” pane to share a document and the “Link settings” pane to fine-tune its access permissions.
    Preston Gralla / Foundry

    Enter the email address of the person with whom you want to share in the text box. Enter multiple addresses, separated by commas, if you want to share the workbook with multiple people.

    One feature I found particularly useful when adding email addresses: As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input. Click the address you want to add. This not only saves you a bit of time but helps make sure you don’t incorrectly type in addresses.

    Next, decide whether anyone with the link can access the file, or only those whose email addresses you enter. If you see the text “Anyone with the link can edit” near the top of the pane, you can change that by clicking it, then choosing Specific people on the screen that appears. Similarly, if “Specific people” appears above the email addresses, you can change that by clicking it, then choosing Anyone with the link can edit from the screen that appears.On this second screen you can also set the document to read-only for everybody, or allow everybody to edit it. In the “Other settings” section, click the down arrow and choose either Can edit, which allows full editing, or Can view, which is read-only. If you want to give certain people editing privileges and others view-only privileges, you can send two separate invitations with different rights selected.

    On this screen you can also set an expiration date after which people won’t be able to access the file, and you can set a password so that only people who have the password can access it. When you’ve made your selections, click Apply.

    Back in the main “Send link” screen, you can send a message along with the link by typing it into the Message box. Then click Send. An email is sent to all the recipients with a link they can click to open the document.

    Your collaborators will get an email like this when you share a spreadsheet.
    Preston Gralla / FoundryThere’s another way to share a file stored in a personal OneDrive for collaboration: In the “Copy link” area at the bottom of the “Send link” pane, click Copy. When you do that, you can copy the link and send it to someone yourself via email. Note that you have the same options for setting access and editing permissions as you do if you have Excel send the link directly for you. Just click Anyone with the link can edit or Specific people below “Copy link,” and follow the instructions above.

    To begin collaborating: When your recipients receive the email and click to open the spreadsheet, they’ll open it in the web version of Excel in a browser, not in the desktop version of Excel. If you’ve granted them edit permissions, they can begin editing immediately in the browser or else click Editing > Open in Desktop App on the upper right of the screen to work in the Excel desktop client. Excel for the web is less powerful and polished than the desktop client, but it works well enough for real-time collaboration.

    As soon as any collaborators open the file, you’ll see a colored cursor that indicates their presence in the file. Each person collaborating gets a different color. Hover your cursor over a colored cell that indicates someone’s presence, and you’ll see their name. Once they begin editing the workbook, such as entering data or a formula into a cell, creating a chart, and so on, you see the changes they make in real time. Your cursor also shows up on their screen as a color, and they see the changes you make.

    You can easily see where collaborators are working in a shared worksheet.
    Preston Gralla / Foundry

    Collaboration includes the ability to make comments in a file, inside individual cells, without actually changing the contents of the cell. To do it, right-click a cell, select New Comment and type in your comment. Everyone collaborating can see that a cell has a comment in it — it’s indicated by a small colored notch appearing in the upper right of the cell. The color matches the person’s collaboration color.

    To see someone’s comment in a cell, hover your cursor over the cell or put your cursor in the cell and you’ll see the comment, the name of the person who made the comment, and a Reply box you can use to send a reply. You can also click the Comments button on the upper right of the screen to open the Comments pane, which lists every comment by every person. Click any comment to jump to the cell it’s in. You can also reply when you click a comment in the pane.

    You can make see comments that other people make, and make comments yourself.
    Preston Gralla / Foundry

    Take advantage of linked data

    Excel for Microsoft 365 has a feature that Microsoft calls “linked data types.” Essentially, they’re cells that are connected to an online sourcethat automatically updates their information — for example, a company’s current stock price. As I write this, there are nearly approximately 100 linked data types, including not just obvious data types such as stocks, geography, and currencies, but many others, including chemistry, cities, anatomy, food, yoga, and more.

    To use them, type the items you want to track into cells in a single column. For stocks, for example, you can type in a series of stock ticker symbols, company names, fund names, etc. After that, select the cells, then on the Ribbon’s Data tab, select Stocks in the Data Types section in the middle.Excel automatically converts the text in each cell into the matching data source — in our example, into the company name and stock ticker.

    Excel also adds a small icon to the left edge of each cell identifying it as a linked cell. Click any icon and a data card will pop up showing all sorts of information about the kind of information you’ve typed in.  For instance, a stock data card shows stock-related information such as current price, today’s high and low, and 52-week high and low, as well as general company information including industry and number of employees. A location card shows the location’s population, capital, GDP, and so on.

    You can build out a table using data from the data card. To do so, select the cells again, and an Insert Data button appears. Click the button, then select the information you want to appear, such as Price for the current stock price, or Population for the population of a geographic region.

    srcset=" 620w, 300w, 172w, 86w, 491w, 368w, 256w" width="620" height="606" sizes="100vw, 620px">Linked data types let you insert information, such as a company’s high and low stock prices, that is continually updated.
    Preston Gralla / Foundry

    Excel will automatically add a column to the right populated with the latest information for each item you’re tracking, and will keep it updated. You can click the Insert Data button multiple times to keep adding columns to the right for different types of data from the item’s data card.  It’s helpful to add column headers so you know what each column is showing.

    Make your own custom views of a worksheet

    Sheet Views let you make a copy of a sheet and then apply filtered or sorted views of the data to the new sheet. It’s useful when you’re working with other people on a spreadsheet, and someone wants to create a customized view without altering the original sheet. You can all create multiple custom-filtered/sorted views for a sheet. Once you’ve saved a sheet view, anyone with access to the spreadsheet can see it.

    Note: To use this feature, your spreadsheet must be stored in OneDrive.

    Sheet views work best when your data is in table format. Select the data, then go to the Ribbon toolbar and click the Insert tab. Near the left end of the Insert toolbar, click the Table button and then OK.

    To create a new sheet view, click the Ribbon’s View tab, then click the New button in the Sheet View area at the far left. The row numbers and column letters at the left and top of your spreadsheet turn black to let you know you’re in a new sheet view. In the Sheet View area of the Ribbon, it says Temporary View, the default name given to a new sheet view before you’ve saved it.

    Here’s a sheet view with data sorted from highest to lowest costs.
    Preston Gralla / Foundry

    Now apply whatever sorting and filtering you like to the data.To save this view, click the Keep button in the Sheet View area of the Ribbon. When you do that, it is saved as “View1” by default. You can click View1 and type in a more meaningful name for the view. When you click Exit on this toolbar, you return to your spreadsheet, and the row numbers and columns on the left and top of the spreadsheet are no longer black.

    To switch from one sheet view to another, click the View tab. At the left of the Ribbon toolbar, click the down arrow next to the name of the current viewto open a dropdown list of the sheet views created for the spreadsheet. Click the name of a sheet view to switch to it. Whenever you’re looking at a sheet view, the row numbers and column letters framing your spreadsheet remain black to indicate that you’re in a sheet view, not the original spreadsheet.

    Create dynamic arrays and charts

    Dynamic arrays let you write formulas that return multiple values based on your data. When data on the spreadsheet is updated, the dynamic arrays automatically update and resize themselves.

    To create a dynamic array, first create a table as outlined in the previous tip. Make sure to include a column that lists categories. Also put in at least one column to its right that lists corresponding values. Put a header at the top of each column.

    So, for example, if you’re creating a spreadsheet for a business trip budget, Column A might list expenses, such as plane tickets, meals, hotel, etc., and Column B could list each item’s cost on the same row.

    Once you’ve set up the table, use a dynamic array function on it, such as FILTER, SORT, or UNIQUE to create a dynamic array next to the table. Here’s an example of a formula for using the FILTER function:

    =FILTERThis tells Excel to show only the items that cost less than in the array.

    The FILTER function created a data array showing only the items with costs below Preston Gralla / Foundry

    Now, whenever the data in your source table changes, the dynamic array updates and resizes itself to accommodate the changes. That means the dynamic array is always up to date. So in our example, if you add new items with values under to the table, the dynamic array will enlarge itself and include those new items.

    In the same way, you can use the SORT function to sort data and the UNIQUE function to remove duplicate data.You create a dynamic chart from the dynamic array in the same way you do any other Excel chart. Select the cells from the dynamic array that you want to chart, then select the Insert tab and select the type of chart you want to add. When the source data changes in a way that affects the dynamic array that the chart is based on, both the dynamic array and the chart will be updated.

    Use AutoSave to provide a safety net as you work

    If you’re worried that you’ll lose your work on a worksheet because you don’t constantly save it, you’ll welcome the AutoSave feature. It automatically saves your files for you, so you won’t have to worry about system crashes, power outages, Excel crashes and similar problems. It only works only on documents stored in OneDrive, OneDrive for Business, or SharePoint Online. It won’t work with files saved in the older .xls format or files you save to your hard drive.

    AutoSave is a vast improvement over the previous AutoRecover feature built into Excel. AutoRecover doesn’t save your files in real time; instead, every several minutes it saves an AutoRecover file that you can try to recover after a crash. It doesn’t always work, though — for example, if you don’t properly open Excel after the crash, or if the crash doesn’t meet Microsoft’s definition of a crash. In addition, Microsoft notes, “AutoRecover is only effective for unplanned disruptions, such as a power outage or a crash. AutoRecover files are not designed to be saved when a logoff is scheduled or an orderly shutdown occurs.” And the files aren’t saved in real time, so you’ll likely lose several minutes of work even if all goes as planned.

    AutoSave is turned on by default in Excel for Microsoft 365 .xlsx workbooks stored in OneDrive, OneDrive for Business, or SharePoint Online. To turn it offfor a workbook, use the AutoSave slider on the top left of the screen. If you want AutoSave to be off for all files by default, select File > Options > and uncheck the box marked AutoSave files stored in the Cloud by default on Excel.

    Using AutoSave may require some rethinking of your workflow. Many people are used to creating new worksheets based on existing ones by opening the existing file, making changes to it, and then using As to save the new version under a different name, leaving the original file intact. Be warned that doing this with AutoSave enabled will save your changes in the original file. Instead, Microsoft suggests opening the original file and immediately selecting File > a Copyto create a new version.

    If AutoSave does save unwanted changes to a file, you can always use the Version History feature described below to roll back to an earlier version.

    Review or restore earlier versions of a spreadsheet

    There’s an extremely useful feature hiding in the title bar in Excel for Microsoft 365: You can use Version History to go back to previous versions of a file, review them, compare them side-by-side with your existing version, and copy and paste from an older file to your existing one. You can also restore an entire old version.

    To do it, click the file name at the top of the screen in an open file. A drop-down menu appears. Click Version History, and the Version History pane appears on the right side of the screen with a list of the previous versions of the file, including the time and date they were saved.Use Version History to see all previous versions of a spreadsheet, copy and paste from an older file to your existing one, or restore an entire old version.
    Preston Gralla / Foundry

    In the Version History pane, click Open version under any older version, and that version appears as a read-only version in a new window. Scroll through the version and copy any content you want, then paste it into the latest version of the file. To restore the old version, overwriting the current one, click the Restore button.

    Try out Microsoft 365 Copilot in Excel — but don’t expect too much

    For an additional subscription fee, business users of Excel can use Microsoft’s genAI add-in, Microsoft 365 Copilot. You can have Copilot suggest and create charts, create formulas, mine spreadsheets for data insights you might have missed, and more. If you have a Microsoft 365 Personal or Family subscription, many of those features are now bundled with your core subscription.

    To start using Copilot in Excel, open a spreadsheet and click the Copilot button at the right of the Ribbon’s Home tab. The Copilot panel will appear on the right, offering suggestions for actions it can perform, such as summarizing your data with a chart, adding formulas to the spreadsheet, or applying conditional formatting to the sheet. You can also chat with Copilot in the panel, asking questions about your data or how to perform an action yourself.

    Note that these suggestions are generic and won’t always make sense. For example, when you start with a blank worksheet and click the Copilot button, its suggestions include summarizing data using pivot tables or charts, even though there’s no data to chart or put into a table.

    Microsoft 365 Copilot can help you in multiple ways in Excel, including creating formulas and charts, mining spreadsheets for insights, and more.
    Preston Gralla / Foundry

    In my testing, I found that Copilot wasn’t particularly helpful. For example, when I asked it to summarize data using a PivotTable or chart, several times it responded, “Something went wrong. Please try again in a moment.” Then it said that I first needed to reformat parts of my spreadsheet by using the Transformfunction, and gave confusing advice on how I could do it — it wouldn’t do the task itself.When I asked it to suggest conditional formatting for my spreadsheet, which would highlight important data, it told me which data I should highlight but didn’t explain why the data was important. It also didn’t do the highlighting for me or tell me how to do it.

    I gave it one more try and asked it to perform an advanced analysis, which it would use Python to do. It certainly did something, although it was unclear what it was. It overwrote my original spreadsheet and added a section that claimed to show annual growth rates for revenue streams. But the data seemed to be incorrect.

    Perhaps advanced spreadsheet jockeys might be able to make sense of what Copilot is up to whenever they ask it for help. But mere mortal businesspeople may find it of no help at all.

    In my testing, I found Copilot not at all helpful, although spreadsheet jockeys may be able to make some sense of what it does.
    Preston Gralla / Foundry

    What’s more, Microsoft’s focus on Copilot in M365 has reduced the usefulness of Excel in some ways. For example, there used to be a handy feature called Smart Lookup that let you conduct targeted web searches from inside Excel. But at the beginning of 2025, Microsoft removed Smart Lookup from Excel, saying that the feature has been deprecated.

    Now the only way to search the web from inside Excel is via Copilot, which lacks some features of Smart Lookup — notably the ability to highlight words or phrases in a document and trigger an automatic web search. And M365 Copilot isn’t available to business customers unless they pay the additional subscription fee.

    Other features to check out

    Spreadsheet pros will be pleased with several other features and tools that have been added to Excel for Microsoft 365 over the past few years, from a quick data analysis tool to an advanced 3D mapping platform.

    Get an instant data analysis

    If you’re looking to analyze data in a spreadsheet, the Quick Analysis tool will help. Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. A small icon of a spreadsheet with a lightning bolt on it appears. Click it and you’ll get a variety of tools for performing instant analysis of your data. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly.

    The Quick Analysis feature gives you a variety of tools for analyzing your data instantly.
    Preston Gralla / Foundry

    Translate text

    You can translate text from right within Excel. Highlight the cell whose text you want translated, then select Review > Translate. A Translator pane opens on the right. Excel will detect the words’ language at the top of the pane; you then select the language you want it translated to below. If Excel can’t detect the language of the text you chose or detects it incorrectly, you can override it.

    Easily find worksheets that have been shared with you

    It’s easy to forget which worksheets others have shared with you. In Excel for Microsoft 365 there’s an easy way to find them: Select File > Open > Shared with Me to see a list of them all. Note that this only works with OneDriveand SharePoint Online. You’ll also need to be signed into you Microsoft or work or school account.

    Predict the future with Forecast Sheet

    Using the Forecast Sheet function, you can generate forecasts built on historical data. If, for example, you have a worksheet showing past book sales by date, Forecast Sheet can predict future sales based on past ones.

    To use the feature, you must be working in a worksheet that has time-based historical data. Put your cursor in one of the data cells, go to the Data tab on the Ribbon and select Forecast Sheet from the Forecast group toward the right. On the screen that appears, you can select various options such as whether to create a line or bar chart and what date the forecast should end. Click the Create button, and a new worksheet will appear showing your historical and predicted data and the forecast chart.The Forecast Sheet feature can predict future results based on historical data.
    Preston Gralla / Foundry

    Manage data for analysis with Get & Transform

    This feature is not entirely new to Excel. Formerly known as Power Query, it was made available as a free add-in to Excel 2013 and worked only with the PowerPivot features in Excel Professional Plus. Microsoft’s Power BI business intelligence software offers similar functionality.

    Now called Get & Transform, it’s a business intelligence tool that lets you pull in, combine, and shape data from wide variety of local and cloud sources. These include Excel workbooks, CSV files, SQL Server and other databases, Azure, Active Directory, and many others. You can also use data from public sources including Wikipedia.

    Get & Transform helps you pull in and shape data from a wide variety of sources.
    Preston Gralla / Foundry

    You’ll find the Get & Transform tools together in a group on the Data tab in the Ribbon. For more about using these tools, see Microsoft’s “Getting Started with Get & Transform in Excel.”

    Make a 3D map

    Before Excel 2016, Power Map was a popular free 3D geospatial visualization add-in for Excel. Now it’s free, built into Excel for Microsoft 365, and has been renamed 3D Maps. With it, you can plot geographic and other information on a 3D globe or map. You’ll need to first have data suitable for mapping, and then prepare that data for 3D Maps.

    Those steps are beyond the scope of this article, but here’s advice from Microsoft about how to get and prepare data for 3D Maps. Once you have properly prepared data, open the spreadsheet and select Insert > 3D Map > Open 3D Maps. Then click Enable from the box that appears. That turns on the 3D Maps feature. For details on how to work with your data and customize your map, head to the Microsoft tutorial “Get started with 3D Maps.”

    If you don’t have data for mapping but just want to see firsthand what a 3D map is like, you can download sample data created by Microsoft. The screenshot shown here is from Microsoft’s Dallas Utilities Seasonal Electricity Consumption Simulation demo. When you’ve downloaded the workbook, open it up, select Insert > 3D Map > Open 3D Maps and click the map to launch it.

    With 3D Maps you can plot geospatial data in an interactive 3D map.
    Preston Gralla / Foundry

    Automate tasks

    If you have OneDrive for Business and use Excel with a commercial or educational Microsoft 365 license, you can automate tasks with the Automate tab. You’ll be able to create and edit scripts with the Code Editor, run automated tasks with a button click, and share the script with co-workers. See Microsoft’s “Office Scripts in Excel” documentation for details.

    Insert data from a picture into Excel

    There are times you may find data inside an image file that you’d like to get into Excel. Typically, you’ll have to input the data from it manually. There’s now a way to have Excel convert the information on the image into data for a worksheet.

    In the Get & Transform Data group on the Data tab, click the From Picture dropdown and select Picture From File to choose the image you want to grab data from, or Picture from Clipboard to take a screenshot of an image on your PC and then import the data. For more details, see Microsoft’s “Insert data from picture” support page.  

    Use keyboard shortcuts

    Here’s one last productivity tip: If you memorize a handful of keyboard shortcuts for common tasks in Excel, you can save a great deal of time over hunting for the right command to click on. See “Handy Excel keyboard shortcuts for Windows and Mac” for our favorites.

    This article was originally published in August 2019 and most recently updated in May 2025.

    More Excel tutorials:

    Excel basics: Get started with tables

    Excel basics: Get started with charts and sparklines

    How to use PivotTables and PivotCharts in Excel

    How to use slicers in Excel

    How to use Excel formulas and functions

    Howto use conditional formatting in Excel

    How to use Excel macros to save time and automate your work
    #excel #microsoft #cheat #sheet
    Excel for Microsoft 365 cheat sheet
    Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, part of Microsoft’s Office suite of productivity tools. Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever, or they can purchase a Microsoft 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee. When you purchase a perpetual version of the suite — say, Office 2021 or Office 2024 — its applications will never get new features, whereas Microsoft 365 apps are continually updated with new features. For more details, see our in-depth comparison of the two Office models. This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years.We’ll periodically update this story as new features roll out. In this article Use the Ribbon Search to get tasks done quickly Explore Excel’s advanced chart types Collaborate in real time Take advantage of linked data Make your own custom views of a worksheet Create dynamic arrays and charts Use AutoSave to provide a safety net as you work Review or restore earlier versions of a spreadsheet Try out Microsoft 365 Copilot in Excel — but don’t expect too much Other new features to check out Use keyboard shortcuts Use the Ribbon The Ribbon interface, which puts commonly used commands in a tabbed toolbar running across the top of the application window, is alive and well in the current version of Excel. Microsoft has tweaked the Ribbon’s looks numerous times over the years, but it still works the same way it always has: just click one of the Ribbon’s tabs to see related commands on the toolbar. For example, click Insert to find buttons for inserting tables, PivotTables, charts, and more. Through the years, Excel’s Ribbon has gotten a variety of cosmetic changes, but it still works largely the way it always has. Preston Gralla / Foundry Just as in previous versions of Excel, if you want the Ribbon commands to go away, press Ctrl-F1 or click the name of the tab you’re currently on.To make the commands reappear, press Ctrl-F1 again or click any tab name. You’ve got other options for displaying the Ribbon as well. To get to them, click the Ribbon display options iconon the bottom of the Ribbon at the far right, just below the Share button. A drop-down menu appears with these four options: Full-screen mode: This makes Excel take up your entire screen and hides the Ribbon. To get out of full-screen mode, click the three-dot icon at the upper right of the screen. Show tabs only: This shows the tabs but hides the commands underneath them. It’s the same as pressing Ctrl-F1. To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display options down arrow and select Always show Ribbon. Always show Ribbon: This displays the entire Ribbon, both the tabs and commands underneath them. Show/Hide Quick Access toolbar: This displays or hides the Quick Access toolbar, which gives you fast access to Excel commands you want to have available no matter which tab you’re on. When you enable the toolbar, it starts off empty. To populate it, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, choose which features to put on it. If you don’t see a command you want, click More Commands. Find the command you want on the left and click Add. You can have the toolbar appear either at the top of the screen, just to the right of the AutoSave button, or just underneath the Ribbon. To move it from one place to another, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, select either Show below the Ribbon or Show above the Ribbon.  Microsoft has for many years teased a simplified version of the Ribbon that hides most of the commands to reduce clutter. That simplified Ribbon is available in the Excel web app, but there’s currently no sign that it will appear in the Excel desktop app. There’s a useful feature in what Microsoft calls the backstage area that appears when you click the File tab on the Ribbon. If you click Open or a Copy from the menu on the left, you can see the cloud-based services you’ve connected to your Office account, such as SharePoint and OneDrive. Each location displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business. You’ll be able to see at a glance which is which. Click the Add a service dropdown to add another cloud storage account. Preston Gralla / Foundry Search to get tasks done quickly Excel has never been the most user-friendly of applications, and it has so many powerful features it can be tough to keep track of them all. That’s where the handy Search feature comes in. To use it, click in the Search box — it’s above the Ribbon in the green title area.Then type in a task you want to do. If you want to summarize your spreadsheet data using a PivotTable, for example, type in something like summarize with pivot table. You’ll get a menu showing potential matches for the task. In this instance, the top result is a direct link to the form for summarizing with a PivotTable — select it and you’ll start your task right away, without having to go to the Ribbon’s Insert tab first. The search box makes it easy to perform just about any task in Excel. Preston Gralla / Foundry If you’d like more information about your task, the final items that appear in the menu let you select from related Help topics. Even if you consider yourself a spreadsheet jockey, it’s worth your while to try out the enhanced search function. It’s a big time-saver, and far more efficient than hunting through the Ribbon to find a command. Also useful is that it remembers the features you’ve previously clicked on in the box, so when you click in it, you first see a list of previous tasks you’ve searched for. That makes sure that tasks that you frequently perform are always within easy reach. And it puts tasks you rarely do within easy reach as well. Users of enterprise and education editions of Microsoft 365 can also use the Search box to find people in their organization, SharePoint resources, and other personalized results from within Excel.Explore Excel’s advanced chart types Charts are great for visualizing and presenting spreadsheet data, and for gaining insights from it. To that end, Microsoft has introduced a number of advanced chart types over the past several years, including most notably a histogram, a “waterfall” that’s effective at showing running financial totals, and a hierarchical treemap that helps you find patterns in data. Note that the new charts are available only if you’re working in an .xlsx document. If you use the older .xls format, you won’t find them. To see all the charts, put your cursor in a cell or group of cells that contains data, select Insert > Recommended Charts and click the All Charts tab. You’ll find the newer charts, mixed in with the older ones. Select any to create the chart.Excel includes several advanced chart types, including waterfall. Preston Gralla / Foundry These are the new chart types: Treemap. This chart type creates a hierarchical view of your data, with top-level categoriesshown as rectangles, and with subcategoriesshown as smaller rectangles grouped inside the larger ones. Thus, you can easily compare the sizes of top-level categories and subcategories in a single view. For instance, a bookstore can see at a glance that it brings in more revenue from 1st Readers, a subcategory of Children’s Books, than for the entire Non-fiction top-level category. srcset=" 830w, 300w, 768w, 264w, 132w, 753w, 565w, 392w" width="830" height="529" sizes="100vw, 830px">A treemap chart lets you easily compare top-level categories and subcategories in a single view. Preston Gralla / Foundry Sunburst. This chart type also displays hierarchical data, but in a multi-level pie chart. Each level of the hierarchy is represented by a circle. The innermost circle contains the top-level categories, the next circle out shows subcategories, the circle after that subsubcategories and so on. Sunbursts are best for showing the relationships among categories and subcategories, while treemaps are better at showing the relative sizes of categories and subcategories. A sunburst chart shows hierarchical data such as book categories and subcategories as a multi-level pie chart. Preston Gralla / Foundry Waterfall. This chart type is well-suited for visualizing financial statements. It displays a running total of the positive and negative contributions toward a final net value. A waterfall chart shows a running total of positive and negative contributions, such as revenue and expenses, toward a final net value. Preston Gralla / Foundry Histogram. This kind of chart shows frequencies within a data set. It could, for example, show the number of books sold in specific price ranges in a bookstore. Histograms are good for showing frequencies, such as number of books sold at various price points. Preston Gralla / Foundry Pareto. This chart, also known as a sorted histogram, contains bars as well as a line graph. Values are represented in descending order by bars. The cumulative total percentage of each bar is represented by a rising line. In the bookstore example, each bar could show a reason for a book being returned. The chart would show, at a glance, the primary reasons for returns, so a bookstore owner could focus on those issues. Note that the Pareto chart does not show up when you select Insert > Recommended Charts > All Charts. To use it, first select the data you want to chart, then select Insert > Insert Statistic Chart, and under Histogram, choose Pareto. In a Pareto chart, or sorted histogram, a rising line represents the cumulative total percentage of the items being measured. In this example, it’s easy to see that more than 80% of a bookstore’s returns are attributable to three problems. Preston Gralla / Foundry Box & Whisker. This chart, like a histogram, shows frequencies within a data set but provides for a deeper analysis than a histogram. For example, in a bookstore it could show the distribution of prices of different genres of books. In the example shown here, each “box” represents the first to third quartile of prices for books in that genre, while the “whiskers”show the upper and lower range of prices. Outliers that are priced outside the whiskers are shown as dots, the median price for each genre is shown with a horizontal line across the box, and the mean price is shown with an x. Box & Whisker charts can show details about data ranges such as the first to third quartile in the “boxes,” median and mean inside the boxes, upper and lower range with the “whiskers,” and outliers with dots.Preston Gralla / Foundry Funnel. This chart type is useful when you want to display values at multiple stages in a process. A funnel chart can show the number of sales prospects at every stage of a sales process, for example, with prospects at the top for the first stage, qualified prospects underneath it for the second stage, and so on, until you get to the final stage, closed sales. Generally, the values in funnel charts decrease with each stage, so the bars in the chart look like a funnel. Funnel charts let you display values at multiple stages in a process. Preston Gralla / Foundry When creating the data for a funnel chart, use one column for the stages in the process you’re charting, and a second column for the values for each stage. Once you’ve done that, to create the chart, select the data, then select Insert > Recommended Charts > All Charts > Funnel. Map. Map charts do exactly what you think they should: They let you compare data across different geographical regions, such as countries, regions, states, counties, or postal codes. Excel will automatically recognize the regions and create a map that visualizes the data. You can compare data across different locations with a map chart. Preston Gralla / Foundry To create a map chart, select the data you want to chart, then select Insert > Maps, then select the map chart. Note that in some instances, Excel might have a problem creating the map — for example, if there are multiple locations with the same name as one that you’re mapping. If that occurs, you’ll have to add one or more columns with details about the locations. If, say, you’re charting towns in the United Kingdom, you would have to include columns for the county and country each town is located in. Collaborate in real time For those who frequently collaborate with others, a welcome feature in Excel for Microsoft 365 is real-time collaboration that lets people work on spreadsheets together from anywhere in the world with an internet connection. Microsoft calls this “co-authoring.” Note that in order to use co-authoring, the spreadsheet must be stored in OneDrive, OneDrive for Business, or SharePoint Online, and you must be logged into your Microsoft 365 account. Also, co-authoring works in Excel only if you have AutoSave turned on. To do it, choose the On option on the AutoSave slider at the top left of the screen. To share a spreadsheet so you can collaborate on it with others: first open it, then click the Share button on the upper-right of the Excel screen. The “Send link” window pops up. Here you can send an email with a link where others can access the spreadsheet. Use the “Send link” pane to share a document and the “Link settings” pane to fine-tune its access permissions. Preston Gralla / Foundry Enter the email address of the person with whom you want to share in the text box. Enter multiple addresses, separated by commas, if you want to share the workbook with multiple people. One feature I found particularly useful when adding email addresses: As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input. Click the address you want to add. This not only saves you a bit of time but helps make sure you don’t incorrectly type in addresses. Next, decide whether anyone with the link can access the file, or only those whose email addresses you enter. If you see the text “Anyone with the link can edit” near the top of the pane, you can change that by clicking it, then choosing Specific people on the screen that appears. Similarly, if “Specific people” appears above the email addresses, you can change that by clicking it, then choosing Anyone with the link can edit from the screen that appears.On this second screen you can also set the document to read-only for everybody, or allow everybody to edit it. In the “Other settings” section, click the down arrow and choose either Can edit, which allows full editing, or Can view, which is read-only. If you want to give certain people editing privileges and others view-only privileges, you can send two separate invitations with different rights selected. On this screen you can also set an expiration date after which people won’t be able to access the file, and you can set a password so that only people who have the password can access it. When you’ve made your selections, click Apply. Back in the main “Send link” screen, you can send a message along with the link by typing it into the Message box. Then click Send. An email is sent to all the recipients with a link they can click to open the document. Your collaborators will get an email like this when you share a spreadsheet. Preston Gralla / FoundryThere’s another way to share a file stored in a personal OneDrive for collaboration: In the “Copy link” area at the bottom of the “Send link” pane, click Copy. When you do that, you can copy the link and send it to someone yourself via email. Note that you have the same options for setting access and editing permissions as you do if you have Excel send the link directly for you. Just click Anyone with the link can edit or Specific people below “Copy link,” and follow the instructions above. To begin collaborating: When your recipients receive the email and click to open the spreadsheet, they’ll open it in the web version of Excel in a browser, not in the desktop version of Excel. If you’ve granted them edit permissions, they can begin editing immediately in the browser or else click Editing > Open in Desktop App on the upper right of the screen to work in the Excel desktop client. Excel for the web is less powerful and polished than the desktop client, but it works well enough for real-time collaboration. As soon as any collaborators open the file, you’ll see a colored cursor that indicates their presence in the file. Each person collaborating gets a different color. Hover your cursor over a colored cell that indicates someone’s presence, and you’ll see their name. Once they begin editing the workbook, such as entering data or a formula into a cell, creating a chart, and so on, you see the changes they make in real time. Your cursor also shows up on their screen as a color, and they see the changes you make. You can easily see where collaborators are working in a shared worksheet. Preston Gralla / Foundry Collaboration includes the ability to make comments in a file, inside individual cells, without actually changing the contents of the cell. To do it, right-click a cell, select New Comment and type in your comment. Everyone collaborating can see that a cell has a comment in it — it’s indicated by a small colored notch appearing in the upper right of the cell. The color matches the person’s collaboration color. To see someone’s comment in a cell, hover your cursor over the cell or put your cursor in the cell and you’ll see the comment, the name of the person who made the comment, and a Reply box you can use to send a reply. You can also click the Comments button on the upper right of the screen to open the Comments pane, which lists every comment by every person. Click any comment to jump to the cell it’s in. You can also reply when you click a comment in the pane. You can make see comments that other people make, and make comments yourself. Preston Gralla / Foundry Take advantage of linked data Excel for Microsoft 365 has a feature that Microsoft calls “linked data types.” Essentially, they’re cells that are connected to an online sourcethat automatically updates their information — for example, a company’s current stock price. As I write this, there are nearly approximately 100 linked data types, including not just obvious data types such as stocks, geography, and currencies, but many others, including chemistry, cities, anatomy, food, yoga, and more. To use them, type the items you want to track into cells in a single column. For stocks, for example, you can type in a series of stock ticker symbols, company names, fund names, etc. After that, select the cells, then on the Ribbon’s Data tab, select Stocks in the Data Types section in the middle.Excel automatically converts the text in each cell into the matching data source — in our example, into the company name and stock ticker. Excel also adds a small icon to the left edge of each cell identifying it as a linked cell. Click any icon and a data card will pop up showing all sorts of information about the kind of information you’ve typed in.  For instance, a stock data card shows stock-related information such as current price, today’s high and low, and 52-week high and low, as well as general company information including industry and number of employees. A location card shows the location’s population, capital, GDP, and so on. You can build out a table using data from the data card. To do so, select the cells again, and an Insert Data button appears. Click the button, then select the information you want to appear, such as Price for the current stock price, or Population for the population of a geographic region. srcset=" 620w, 300w, 172w, 86w, 491w, 368w, 256w" width="620" height="606" sizes="100vw, 620px">Linked data types let you insert information, such as a company’s high and low stock prices, that is continually updated. Preston Gralla / Foundry Excel will automatically add a column to the right populated with the latest information for each item you’re tracking, and will keep it updated. You can click the Insert Data button multiple times to keep adding columns to the right for different types of data from the item’s data card.  It’s helpful to add column headers so you know what each column is showing. Make your own custom views of a worksheet Sheet Views let you make a copy of a sheet and then apply filtered or sorted views of the data to the new sheet. It’s useful when you’re working with other people on a spreadsheet, and someone wants to create a customized view without altering the original sheet. You can all create multiple custom-filtered/sorted views for a sheet. Once you’ve saved a sheet view, anyone with access to the spreadsheet can see it. Note: To use this feature, your spreadsheet must be stored in OneDrive. Sheet views work best when your data is in table format. Select the data, then go to the Ribbon toolbar and click the Insert tab. Near the left end of the Insert toolbar, click the Table button and then OK. To create a new sheet view, click the Ribbon’s View tab, then click the New button in the Sheet View area at the far left. The row numbers and column letters at the left and top of your spreadsheet turn black to let you know you’re in a new sheet view. In the Sheet View area of the Ribbon, it says Temporary View, the default name given to a new sheet view before you’ve saved it. Here’s a sheet view with data sorted from highest to lowest costs. Preston Gralla / Foundry Now apply whatever sorting and filtering you like to the data.To save this view, click the Keep button in the Sheet View area of the Ribbon. When you do that, it is saved as “View1” by default. You can click View1 and type in a more meaningful name for the view. When you click Exit on this toolbar, you return to your spreadsheet, and the row numbers and columns on the left and top of the spreadsheet are no longer black. To switch from one sheet view to another, click the View tab. At the left of the Ribbon toolbar, click the down arrow next to the name of the current viewto open a dropdown list of the sheet views created for the spreadsheet. Click the name of a sheet view to switch to it. Whenever you’re looking at a sheet view, the row numbers and column letters framing your spreadsheet remain black to indicate that you’re in a sheet view, not the original spreadsheet. Create dynamic arrays and charts Dynamic arrays let you write formulas that return multiple values based on your data. When data on the spreadsheet is updated, the dynamic arrays automatically update and resize themselves. To create a dynamic array, first create a table as outlined in the previous tip. Make sure to include a column that lists categories. Also put in at least one column to its right that lists corresponding values. Put a header at the top of each column. So, for example, if you’re creating a spreadsheet for a business trip budget, Column A might list expenses, such as plane tickets, meals, hotel, etc., and Column B could list each item’s cost on the same row. Once you’ve set up the table, use a dynamic array function on it, such as FILTER, SORT, or UNIQUE to create a dynamic array next to the table. Here’s an example of a formula for using the FILTER function: =FILTERThis tells Excel to show only the items that cost less than in the array. The FILTER function created a data array showing only the items with costs below Preston Gralla / Foundry Now, whenever the data in your source table changes, the dynamic array updates and resizes itself to accommodate the changes. That means the dynamic array is always up to date. So in our example, if you add new items with values under to the table, the dynamic array will enlarge itself and include those new items. In the same way, you can use the SORT function to sort data and the UNIQUE function to remove duplicate data.You create a dynamic chart from the dynamic array in the same way you do any other Excel chart. Select the cells from the dynamic array that you want to chart, then select the Insert tab and select the type of chart you want to add. When the source data changes in a way that affects the dynamic array that the chart is based on, both the dynamic array and the chart will be updated. Use AutoSave to provide a safety net as you work If you’re worried that you’ll lose your work on a worksheet because you don’t constantly save it, you’ll welcome the AutoSave feature. It automatically saves your files for you, so you won’t have to worry about system crashes, power outages, Excel crashes and similar problems. It only works only on documents stored in OneDrive, OneDrive for Business, or SharePoint Online. It won’t work with files saved in the older .xls format or files you save to your hard drive. AutoSave is a vast improvement over the previous AutoRecover feature built into Excel. AutoRecover doesn’t save your files in real time; instead, every several minutes it saves an AutoRecover file that you can try to recover after a crash. It doesn’t always work, though — for example, if you don’t properly open Excel after the crash, or if the crash doesn’t meet Microsoft’s definition of a crash. In addition, Microsoft notes, “AutoRecover is only effective for unplanned disruptions, such as a power outage or a crash. AutoRecover files are not designed to be saved when a logoff is scheduled or an orderly shutdown occurs.” And the files aren’t saved in real time, so you’ll likely lose several minutes of work even if all goes as planned. AutoSave is turned on by default in Excel for Microsoft 365 .xlsx workbooks stored in OneDrive, OneDrive for Business, or SharePoint Online. To turn it offfor a workbook, use the AutoSave slider on the top left of the screen. If you want AutoSave to be off for all files by default, select File > Options > and uncheck the box marked AutoSave files stored in the Cloud by default on Excel. Using AutoSave may require some rethinking of your workflow. Many people are used to creating new worksheets based on existing ones by opening the existing file, making changes to it, and then using As to save the new version under a different name, leaving the original file intact. Be warned that doing this with AutoSave enabled will save your changes in the original file. Instead, Microsoft suggests opening the original file and immediately selecting File > a Copyto create a new version. If AutoSave does save unwanted changes to a file, you can always use the Version History feature described below to roll back to an earlier version. Review or restore earlier versions of a spreadsheet There’s an extremely useful feature hiding in the title bar in Excel for Microsoft 365: You can use Version History to go back to previous versions of a file, review them, compare them side-by-side with your existing version, and copy and paste from an older file to your existing one. You can also restore an entire old version. To do it, click the file name at the top of the screen in an open file. A drop-down menu appears. Click Version History, and the Version History pane appears on the right side of the screen with a list of the previous versions of the file, including the time and date they were saved.Use Version History to see all previous versions of a spreadsheet, copy and paste from an older file to your existing one, or restore an entire old version. Preston Gralla / Foundry In the Version History pane, click Open version under any older version, and that version appears as a read-only version in a new window. Scroll through the version and copy any content you want, then paste it into the latest version of the file. To restore the old version, overwriting the current one, click the Restore button. Try out Microsoft 365 Copilot in Excel — but don’t expect too much For an additional subscription fee, business users of Excel can use Microsoft’s genAI add-in, Microsoft 365 Copilot. You can have Copilot suggest and create charts, create formulas, mine spreadsheets for data insights you might have missed, and more. If you have a Microsoft 365 Personal or Family subscription, many of those features are now bundled with your core subscription. To start using Copilot in Excel, open a spreadsheet and click the Copilot button at the right of the Ribbon’s Home tab. The Copilot panel will appear on the right, offering suggestions for actions it can perform, such as summarizing your data with a chart, adding formulas to the spreadsheet, or applying conditional formatting to the sheet. You can also chat with Copilot in the panel, asking questions about your data or how to perform an action yourself. Note that these suggestions are generic and won’t always make sense. For example, when you start with a blank worksheet and click the Copilot button, its suggestions include summarizing data using pivot tables or charts, even though there’s no data to chart or put into a table. Microsoft 365 Copilot can help you in multiple ways in Excel, including creating formulas and charts, mining spreadsheets for insights, and more. Preston Gralla / Foundry In my testing, I found that Copilot wasn’t particularly helpful. For example, when I asked it to summarize data using a PivotTable or chart, several times it responded, “Something went wrong. Please try again in a moment.” Then it said that I first needed to reformat parts of my spreadsheet by using the Transformfunction, and gave confusing advice on how I could do it — it wouldn’t do the task itself.When I asked it to suggest conditional formatting for my spreadsheet, which would highlight important data, it told me which data I should highlight but didn’t explain why the data was important. It also didn’t do the highlighting for me or tell me how to do it. I gave it one more try and asked it to perform an advanced analysis, which it would use Python to do. It certainly did something, although it was unclear what it was. It overwrote my original spreadsheet and added a section that claimed to show annual growth rates for revenue streams. But the data seemed to be incorrect. Perhaps advanced spreadsheet jockeys might be able to make sense of what Copilot is up to whenever they ask it for help. But mere mortal businesspeople may find it of no help at all. In my testing, I found Copilot not at all helpful, although spreadsheet jockeys may be able to make some sense of what it does. Preston Gralla / Foundry What’s more, Microsoft’s focus on Copilot in M365 has reduced the usefulness of Excel in some ways. For example, there used to be a handy feature called Smart Lookup that let you conduct targeted web searches from inside Excel. But at the beginning of 2025, Microsoft removed Smart Lookup from Excel, saying that the feature has been deprecated. Now the only way to search the web from inside Excel is via Copilot, which lacks some features of Smart Lookup — notably the ability to highlight words or phrases in a document and trigger an automatic web search. And M365 Copilot isn’t available to business customers unless they pay the additional subscription fee. Other features to check out Spreadsheet pros will be pleased with several other features and tools that have been added to Excel for Microsoft 365 over the past few years, from a quick data analysis tool to an advanced 3D mapping platform. Get an instant data analysis If you’re looking to analyze data in a spreadsheet, the Quick Analysis tool will help. Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. A small icon of a spreadsheet with a lightning bolt on it appears. Click it and you’ll get a variety of tools for performing instant analysis of your data. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly. The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. Preston Gralla / Foundry Translate text You can translate text from right within Excel. Highlight the cell whose text you want translated, then select Review > Translate. A Translator pane opens on the right. Excel will detect the words’ language at the top of the pane; you then select the language you want it translated to below. If Excel can’t detect the language of the text you chose or detects it incorrectly, you can override it. Easily find worksheets that have been shared with you It’s easy to forget which worksheets others have shared with you. In Excel for Microsoft 365 there’s an easy way to find them: Select File > Open > Shared with Me to see a list of them all. Note that this only works with OneDriveand SharePoint Online. You’ll also need to be signed into you Microsoft or work or school account. Predict the future with Forecast Sheet Using the Forecast Sheet function, you can generate forecasts built on historical data. If, for example, you have a worksheet showing past book sales by date, Forecast Sheet can predict future sales based on past ones. To use the feature, you must be working in a worksheet that has time-based historical data. Put your cursor in one of the data cells, go to the Data tab on the Ribbon and select Forecast Sheet from the Forecast group toward the right. On the screen that appears, you can select various options such as whether to create a line or bar chart and what date the forecast should end. Click the Create button, and a new worksheet will appear showing your historical and predicted data and the forecast chart.The Forecast Sheet feature can predict future results based on historical data. Preston Gralla / Foundry Manage data for analysis with Get & Transform This feature is not entirely new to Excel. Formerly known as Power Query, it was made available as a free add-in to Excel 2013 and worked only with the PowerPivot features in Excel Professional Plus. Microsoft’s Power BI business intelligence software offers similar functionality. Now called Get & Transform, it’s a business intelligence tool that lets you pull in, combine, and shape data from wide variety of local and cloud sources. These include Excel workbooks, CSV files, SQL Server and other databases, Azure, Active Directory, and many others. You can also use data from public sources including Wikipedia. Get & Transform helps you pull in and shape data from a wide variety of sources. Preston Gralla / Foundry You’ll find the Get & Transform tools together in a group on the Data tab in the Ribbon. For more about using these tools, see Microsoft’s “Getting Started with Get & Transform in Excel.” Make a 3D map Before Excel 2016, Power Map was a popular free 3D geospatial visualization add-in for Excel. Now it’s free, built into Excel for Microsoft 365, and has been renamed 3D Maps. With it, you can plot geographic and other information on a 3D globe or map. You’ll need to first have data suitable for mapping, and then prepare that data for 3D Maps. Those steps are beyond the scope of this article, but here’s advice from Microsoft about how to get and prepare data for 3D Maps. Once you have properly prepared data, open the spreadsheet and select Insert > 3D Map > Open 3D Maps. Then click Enable from the box that appears. That turns on the 3D Maps feature. For details on how to work with your data and customize your map, head to the Microsoft tutorial “Get started with 3D Maps.” If you don’t have data for mapping but just want to see firsthand what a 3D map is like, you can download sample data created by Microsoft. The screenshot shown here is from Microsoft’s Dallas Utilities Seasonal Electricity Consumption Simulation demo. When you’ve downloaded the workbook, open it up, select Insert > 3D Map > Open 3D Maps and click the map to launch it. With 3D Maps you can plot geospatial data in an interactive 3D map. Preston Gralla / Foundry Automate tasks If you have OneDrive for Business and use Excel with a commercial or educational Microsoft 365 license, you can automate tasks with the Automate tab. You’ll be able to create and edit scripts with the Code Editor, run automated tasks with a button click, and share the script with co-workers. See Microsoft’s “Office Scripts in Excel” documentation for details. Insert data from a picture into Excel There are times you may find data inside an image file that you’d like to get into Excel. Typically, you’ll have to input the data from it manually. There’s now a way to have Excel convert the information on the image into data for a worksheet. In the Get & Transform Data group on the Data tab, click the From Picture dropdown and select Picture From File to choose the image you want to grab data from, or Picture from Clipboard to take a screenshot of an image on your PC and then import the data. For more details, see Microsoft’s “Insert data from picture” support page.   Use keyboard shortcuts Here’s one last productivity tip: If you memorize a handful of keyboard shortcuts for common tasks in Excel, you can save a great deal of time over hunting for the right command to click on. See “Handy Excel keyboard shortcuts for Windows and Mac” for our favorites. This article was originally published in August 2019 and most recently updated in May 2025. More Excel tutorials: Excel basics: Get started with tables Excel basics: Get started with charts and sparklines How to use PivotTables and PivotCharts in Excel How to use slicers in Excel How to use Excel formulas and functions Howto use conditional formatting in Excel How to use Excel macros to save time and automate your work #excel #microsoft #cheat #sheet
    WWW.COMPUTERWORLD.COM
    Excel for Microsoft 365 cheat sheet
    Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, part of Microsoft’s Office suite of productivity tools. Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever (what the company calls the “perpetual” version of the suite), or they can purchase a Microsoft 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee. When you purchase a perpetual version of the suite — say, Office 2021 or Office 2024 — its applications will never get new features, whereas Microsoft 365 apps are continually updated with new features. For more details, see our in-depth comparison of the two Office models. This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years. (If you’re looking for Excel tips for the perpetual-license Office suite, see our Office 2021 and 2024 cheat sheet.) We’ll periodically update this story as new features roll out. In this article Use the Ribbon Search to get tasks done quickly Explore Excel’s advanced chart types Collaborate in real time Take advantage of linked data Make your own custom views of a worksheet Create dynamic arrays and charts Use AutoSave to provide a safety net as you work Review or restore earlier versions of a spreadsheet Try out Microsoft 365 Copilot in Excel — but don’t expect too much Other new features to check out Use keyboard shortcuts Use the Ribbon The Ribbon interface, which puts commonly used commands in a tabbed toolbar running across the top of the application window, is alive and well in the current version of Excel. Microsoft has tweaked the Ribbon’s looks numerous times over the years, but it still works the same way it always has: just click one of the Ribbon’s tabs to see related commands on the toolbar. For example, click Insert to find buttons for inserting tables, PivotTables, charts, and more. Through the years, Excel’s Ribbon has gotten a variety of cosmetic changes, but it still works largely the way it always has. Preston Gralla / Foundry Just as in previous versions of Excel, if you want the Ribbon commands to go away, press Ctrl-F1 or click the name of the tab you’re currently on. (The tabs above the Ribbon — File, Home, Insert, and so on — stay visible.) To make the commands reappear, press Ctrl-F1 again or click any tab name. You’ve got other options for displaying the Ribbon as well. To get to them, click the Ribbon display options icon (a down arrow) on the bottom of the Ribbon at the far right, just below the Share button. A drop-down menu appears with these four options: Full-screen mode: This makes Excel take up your entire screen and hides the Ribbon. To get out of full-screen mode, click the three-dot icon at the upper right of the screen. Show tabs only: This shows the tabs but hides the commands underneath them. It’s the same as pressing Ctrl-F1. To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display options down arrow and select Always show Ribbon. Always show Ribbon: This displays the entire Ribbon, both the tabs and commands underneath them. Show/Hide Quick Access toolbar: This displays or hides the Quick Access toolbar, which gives you fast access to Excel commands you want to have available no matter which tab you’re on. When you enable the toolbar, it starts off empty. To populate it, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, choose which features to put on it. If you don’t see a command you want, click More Commands. Find the command you want on the left and click Add. You can have the toolbar appear either at the top of the screen, just to the right of the AutoSave button, or just underneath the Ribbon. To move it from one place to another, click a small down arrow that appears at the right of the toolbar and from the drop-down menu that appears, select either Show below the Ribbon or Show above the Ribbon.  Microsoft has for many years teased a simplified version of the Ribbon that hides most of the commands to reduce clutter. That simplified Ribbon is available in the Excel web app, but there’s currently no sign that it will appear in the Excel desktop app. There’s a useful feature in what Microsoft calls the backstage area that appears when you click the File tab on the Ribbon. If you click Open or Save a Copy from the menu on the left, you can see the cloud-based services you’ve connected to your Office account, such as SharePoint and OneDrive. Each location displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business. You’ll be able to see at a glance which is which. Click the Add a service dropdown to add another cloud storage account. Preston Gralla / Foundry Search to get tasks done quickly Excel has never been the most user-friendly of applications, and it has so many powerful features it can be tough to keep track of them all. That’s where the handy Search feature comes in. To use it, click in the Search box — it’s above the Ribbon in the green title area. (Keyboard fans can instead press Alt-Q.) Then type in a task you want to do. If you want to summarize your spreadsheet data using a PivotTable, for example, type in something like summarize with pivot table. You’ll get a menu showing potential matches for the task. In this instance, the top result is a direct link to the form for summarizing with a PivotTable — select it and you’ll start your task right away, without having to go to the Ribbon’s Insert tab first. The search box makes it easy to perform just about any task in Excel. Preston Gralla / Foundry If you’d like more information about your task, the final items that appear in the menu let you select from related Help topics. Even if you consider yourself a spreadsheet jockey, it’s worth your while to try out the enhanced search function. It’s a big time-saver, and far more efficient than hunting through the Ribbon to find a command. Also useful is that it remembers the features you’ve previously clicked on in the box, so when you click in it, you first see a list of previous tasks you’ve searched for. That makes sure that tasks that you frequently perform are always within easy reach. And it puts tasks you rarely do within easy reach as well. Users of enterprise and education editions of Microsoft 365 can also use the Search box to find people in their organization, SharePoint resources, and other personalized results from within Excel. (See the Microsoft Search support page for more details about all it can do.) Explore Excel’s advanced chart types Charts are great for visualizing and presenting spreadsheet data, and for gaining insights from it. To that end, Microsoft has introduced a number of advanced chart types over the past several years, including most notably a histogram (frequently used in statistics), a “waterfall” that’s effective at showing running financial totals, and a hierarchical treemap that helps you find patterns in data. Note that the new charts are available only if you’re working in an .xlsx document. If you use the older .xls format, you won’t find them. To see all the charts, put your cursor in a cell or group of cells that contains data, select Insert > Recommended Charts and click the All Charts tab. You’ll find the newer charts, mixed in with the older ones. Select any to create the chart. (For help using charts, see our guide to charts and sparklines in Excel.) Excel includes several advanced chart types, including waterfall. Preston Gralla / Foundry These are the new chart types: Treemap. This chart type creates a hierarchical view of your data, with top-level categories (or tree branches) shown as rectangles, and with subcategories (or sub-branches) shown as smaller rectangles grouped inside the larger ones. Thus, you can easily compare the sizes of top-level categories and subcategories in a single view. For instance, a bookstore can see at a glance that it brings in more revenue from 1st Readers, a subcategory of Children’s Books, than for the entire Non-fiction top-level category. srcset="https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?quality=50&strip=all 830w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=300%2C191&quality=50&strip=all 300w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=768%2C489&quality=50&strip=all 768w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=264%2C168&quality=50&strip=all 264w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=132%2C84&quality=50&strip=all 132w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=753%2C480&quality=50&strip=all 753w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=565%2C360&quality=50&strip=all 565w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel2016_chart_treemap.jpg?resize=392%2C250&quality=50&strip=all 392w" width="830" height="529" sizes="(max-width: 830px) 100vw, 830px">A treemap chart lets you easily compare top-level categories and subcategories in a single view. Preston Gralla / Foundry Sunburst. This chart type also displays hierarchical data, but in a multi-level pie chart. Each level of the hierarchy is represented by a circle. The innermost circle contains the top-level categories, the next circle out shows subcategories, the circle after that subsubcategories and so on. Sunbursts are best for showing the relationships among categories and subcategories, while treemaps are better at showing the relative sizes of categories and subcategories. A sunburst chart shows hierarchical data such as book categories and subcategories as a multi-level pie chart. Preston Gralla / Foundry Waterfall. This chart type is well-suited for visualizing financial statements. It displays a running total of the positive and negative contributions toward a final net value. A waterfall chart shows a running total of positive and negative contributions, such as revenue and expenses, toward a final net value. Preston Gralla / Foundry Histogram. This kind of chart shows frequencies within a data set. It could, for example, show the number of books sold in specific price ranges in a bookstore. Histograms are good for showing frequencies, such as number of books sold at various price points. Preston Gralla / Foundry Pareto. This chart, also known as a sorted histogram, contains bars as well as a line graph. Values are represented in descending order by bars. The cumulative total percentage of each bar is represented by a rising line. In the bookstore example, each bar could show a reason for a book being returned (defective, priced incorrectly, and so on). The chart would show, at a glance, the primary reasons for returns, so a bookstore owner could focus on those issues. Note that the Pareto chart does not show up when you select Insert > Recommended Charts > All Charts. To use it, first select the data you want to chart, then select Insert > Insert Statistic Chart, and under Histogram, choose Pareto. In a Pareto chart, or sorted histogram, a rising line represents the cumulative total percentage of the items being measured. In this example, it’s easy to see that more than 80% of a bookstore’s returns are attributable to three problems. Preston Gralla / Foundry Box & Whisker. This chart, like a histogram, shows frequencies within a data set but provides for a deeper analysis than a histogram. For example, in a bookstore it could show the distribution of prices of different genres of books. In the example shown here, each “box” represents the first to third quartile of prices for books in that genre, while the “whiskers” (the lines extending up and down from the box) show the upper and lower range of prices. Outliers that are priced outside the whiskers are shown as dots, the median price for each genre is shown with a horizontal line across the box, and the mean price is shown with an x. Box & Whisker charts can show details about data ranges such as the first to third quartile in the “boxes,” median and mean inside the boxes, upper and lower range with the “whiskers,” and outliers with dots.Preston Gralla / Foundry Funnel. This chart type is useful when you want to display values at multiple stages in a process. A funnel chart can show the number of sales prospects at every stage of a sales process, for example, with prospects at the top for the first stage, qualified prospects underneath it for the second stage, and so on, until you get to the final stage, closed sales. Generally, the values in funnel charts decrease with each stage, so the bars in the chart look like a funnel. Funnel charts let you display values at multiple stages in a process. Preston Gralla / Foundry When creating the data for a funnel chart, use one column for the stages in the process you’re charting, and a second column for the values for each stage. Once you’ve done that, to create the chart, select the data, then select Insert > Recommended Charts > All Charts > Funnel. Map. Map charts do exactly what you think they should: They let you compare data across different geographical regions, such as countries, regions, states, counties, or postal codes. Excel will automatically recognize the regions and create a map that visualizes the data. You can compare data across different locations with a map chart. Preston Gralla / Foundry To create a map chart, select the data you want to chart, then select Insert > Maps, then select the map chart. Note that in some instances, Excel might have a problem creating the map — for example, if there are multiple locations with the same name as one that you’re mapping. If that occurs, you’ll have to add one or more columns with details about the locations. If, say, you’re charting towns in the United Kingdom, you would have to include columns for the county and country each town is located in. Collaborate in real time For those who frequently collaborate with others, a welcome feature in Excel for Microsoft 365 is real-time collaboration that lets people work on spreadsheets together from anywhere in the world with an internet connection. Microsoft calls this “co-authoring.” Note that in order to use co-authoring, the spreadsheet must be stored in OneDrive, OneDrive for Business, or SharePoint Online, and you must be logged into your Microsoft 365 account. Also, co-authoring works in Excel only if you have AutoSave turned on. To do it, choose the On option on the AutoSave slider at the top left of the screen. To share a spreadsheet so you can collaborate on it with others: first open it, then click the Share button on the upper-right of the Excel screen. The “Send link” window pops up. Here you can send an email with a link where others can access the spreadsheet. Use the “Send link” pane to share a document and the “Link settings” pane to fine-tune its access permissions. Preston Gralla / Foundry Enter the email address of the person with whom you want to share in the text box. Enter multiple addresses, separated by commas, if you want to share the workbook with multiple people. One feature I found particularly useful when adding email addresses: As you type, Excel looks through your corporate or personal address book and lists the names and addresses of contacts who match the text you’ve input. Click the address you want to add. This not only saves you a bit of time but helps make sure you don’t incorrectly type in addresses. Next, decide whether anyone with the link can access the file, or only those whose email addresses you enter. If you see the text “Anyone with the link can edit” near the top of the pane, you can change that by clicking it, then choosing Specific people on the screen that appears. Similarly, if “Specific people” appears above the email addresses, you can change that by clicking it, then choosing Anyone with the link can edit from the screen that appears. (If you use a business, enterprise, or education edition of Office, your IT department may have set up different sharing permissions on these two screens, such as an option to allow anyone within your organization to edit the document. You may also need to click a Link settings button — a gear icon — to access the “Link settings” pane.) On this second screen you can also set the document to read-only for everybody, or allow everybody to edit it. In the “Other settings” section, click the down arrow and choose either Can edit, which allows full editing, or Can view, which is read-only. If you want to give certain people editing privileges and others view-only privileges, you can send two separate invitations with different rights selected. On this screen you can also set an expiration date after which people won’t be able to access the file, and you can set a password so that only people who have the password can access it. When you’ve made your selections, click Apply. Back in the main “Send link” screen, you can send a message along with the link by typing it into the Message box. Then click Send. An email is sent to all the recipients with a link they can click to open the document. Your collaborators will get an email like this when you share a spreadsheet. Preston Gralla / Foundry (If you’d rather send recipients a copy of the file as an Excel file instead of a link, and thus not allow real-time collaboration, click Send a copy at the bottom of the “Send link” screen.) There’s another way to share a file stored in a personal OneDrive for collaboration: In the “Copy link” area at the bottom of the “Send link” pane, click Copy. When you do that, you can copy the link and send it to someone yourself via email. Note that you have the same options for setting access and editing permissions as you do if you have Excel send the link directly for you. Just click Anyone with the link can edit or Specific people below “Copy link,” and follow the instructions above. To begin collaborating: When your recipients receive the email and click to open the spreadsheet, they’ll open it in the web version of Excel in a browser, not in the desktop version of Excel. If you’ve granted them edit permissions, they can begin editing immediately in the browser or else click Editing > Open in Desktop App on the upper right of the screen to work in the Excel desktop client. Excel for the web is less powerful and polished than the desktop client, but it works well enough for real-time collaboration. As soon as any collaborators open the file, you’ll see a colored cursor that indicates their presence in the file. Each person collaborating gets a different color. Hover your cursor over a colored cell that indicates someone’s presence, and you’ll see their name. Once they begin editing the workbook, such as entering data or a formula into a cell, creating a chart, and so on, you see the changes they make in real time. Your cursor also shows up on their screen as a color, and they see the changes you make. You can easily see where collaborators are working in a shared worksheet. Preston Gralla / Foundry Collaboration includes the ability to make comments in a file, inside individual cells, without actually changing the contents of the cell. To do it, right-click a cell, select New Comment and type in your comment. Everyone collaborating can see that a cell has a comment in it — it’s indicated by a small colored notch appearing in the upper right of the cell. The color matches the person’s collaboration color. To see someone’s comment in a cell, hover your cursor over the cell or put your cursor in the cell and you’ll see the comment, the name of the person who made the comment, and a Reply box you can use to send a reply. You can also click the Comments button on the upper right of the screen to open the Comments pane, which lists every comment by every person. Click any comment to jump to the cell it’s in. You can also reply when you click a comment in the pane. You can make see comments that other people make, and make comments yourself. Preston Gralla / Foundry Take advantage of linked data Excel for Microsoft 365 has a feature that Microsoft calls “linked data types.” Essentially, they’re cells that are connected to an online source (Bing) that automatically updates their information — for example, a company’s current stock price. As I write this, there are nearly approximately 100 linked data types, including not just obvious data types such as stocks, geography, and currencies, but many others, including chemistry, cities, anatomy, food, yoga, and more. To use them, type the items you want to track into cells in a single column. For stocks, for example, you can type in a series of stock ticker symbols, company names, fund names, etc. After that, select the cells, then on the Ribbon’s Data tab, select Stocks in the Data Types section in the middle. (If you had typed in geographic names such as countries, states, or cities, you would instead select Geography.) Excel automatically converts the text in each cell into the matching data source — in our example, into the company name and stock ticker. Excel also adds a small icon to the left edge of each cell identifying it as a linked cell. Click any icon and a data card will pop up showing all sorts of information about the kind of information you’ve typed in.  For instance, a stock data card shows stock-related information such as current price, today’s high and low, and 52-week high and low, as well as general company information including industry and number of employees. A location card shows the location’s population, capital, GDP, and so on. You can build out a table using data from the data card. To do so, select the cells again, and an Insert Data button appears. Click the button, then select the information you want to appear, such as Price for the current stock price, or Population for the population of a geographic region. srcset="https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?quality=50&strip=all 620w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=300%2C293&quality=50&strip=all 300w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=172%2C168&quality=50&strip=all 172w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=86%2C84&quality=50&strip=all 86w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=491%2C480&quality=50&strip=all 491w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=368%2C360&quality=50&strip=all 368w, https://b2b-contenthub.com/wp-content/uploads/2025/05/excel-microsoft365-15-linked-data-2023.jpg?resize=256%2C250&quality=50&strip=all 256w" width="620" height="606" sizes="(max-width: 620px) 100vw, 620px">Linked data types let you insert information, such as a company’s high and low stock prices, that is continually updated. Preston Gralla / Foundry Excel will automatically add a column to the right populated with the latest information for each item you’re tracking, and will keep it updated. You can click the Insert Data button multiple times to keep adding columns to the right for different types of data from the item’s data card.  It’s helpful to add column headers so you know what each column is showing. Make your own custom views of a worksheet Sheet Views let you make a copy of a sheet and then apply filtered or sorted views of the data to the new sheet. It’s useful when you’re working with other people on a spreadsheet, and someone wants to create a customized view without altering the original sheet. You can all create multiple custom-filtered/sorted views for a sheet. Once you’ve saved a sheet view, anyone with access to the spreadsheet can see it. Note: To use this feature, your spreadsheet must be stored in OneDrive. Sheet views work best when your data is in table format. Select the data, then go to the Ribbon toolbar and click the Insert tab. Near the left end of the Insert toolbar, click the Table button and then OK. To create a new sheet view, click the Ribbon’s View tab, then click the New button in the Sheet View area at the far left. The row numbers and column letters at the left and top of your spreadsheet turn black to let you know you’re in a new sheet view. In the Sheet View area of the Ribbon, it says Temporary View, the default name given to a new sheet view before you’ve saved it. Here’s a sheet view with data sorted from highest to lowest costs. Preston Gralla / Foundry Now apply whatever sorting and filtering you like to the data. (If you need help, see the “How to sort and filter data” section of our Excel tables guide.) To save this view, click the Keep button in the Sheet View area of the Ribbon. When you do that, it is saved as “View1” by default. You can click View1 and type in a more meaningful name for the view. When you click Exit on this toolbar, you return to your spreadsheet, and the row numbers and columns on the left and top of the spreadsheet are no longer black. To switch from one sheet view to another, click the View tab. At the left of the Ribbon toolbar, click the down arrow next to the name of the current view (it will say Default if you’re viewing the spreadsheet without a sheet view applied) to open a dropdown list of the sheet views created for the spreadsheet. Click the name of a sheet view to switch to it. Whenever you’re looking at a sheet view, the row numbers and column letters framing your spreadsheet remain black to indicate that you’re in a sheet view, not the original spreadsheet. Create dynamic arrays and charts Dynamic arrays let you write formulas that return multiple values based on your data. When data on the spreadsheet is updated, the dynamic arrays automatically update and resize themselves. To create a dynamic array, first create a table as outlined in the previous tip. Make sure to include a column that lists categories. Also put in at least one column to its right that lists corresponding values. Put a header at the top of each column. So, for example, if you’re creating a spreadsheet for a business trip budget, Column A might list expenses, such as plane tickets, meals, hotel, etc., and Column B could list each item’s cost on the same row. Once you’ve set up the table, use a dynamic array function on it, such as FILTER, SORT, or UNIQUE to create a dynamic array next to the table. Here’s an example of a formula for using the FILTER function: =FILTER(A2:B9, B2:B9 < 2000) This tells Excel to show only the items that cost less than $2,000 in the array. The FILTER function created a data array showing only the items with costs below $2,000. Preston Gralla / Foundry Now, whenever the data in your source table changes, the dynamic array updates and resizes itself to accommodate the changes. That means the dynamic array is always up to date. So in our example, if you add new items with values under $2,000 to the table, the dynamic array will enlarge itself and include those new items. In the same way, you can use the SORT function to sort data and the UNIQUE function to remove duplicate data. (Read about more ways to use the FILTER, SORT, and UNIQUE functions from Microsoft support.) You create a dynamic chart from the dynamic array in the same way you do any other Excel chart. Select the cells from the dynamic array that you want to chart, then select the Insert tab and select the type of chart you want to add. When the source data changes in a way that affects the dynamic array that the chart is based on, both the dynamic array and the chart will be updated. Use AutoSave to provide a safety net as you work If you’re worried that you’ll lose your work on a worksheet because you don’t constantly save it, you’ll welcome the AutoSave feature. It automatically saves your files for you, so you won’t have to worry about system crashes, power outages, Excel crashes and similar problems. It only works only on documents stored in OneDrive, OneDrive for Business, or SharePoint Online. It won’t work with files saved in the older .xls format or files you save to your hard drive. AutoSave is a vast improvement over the previous AutoRecover feature built into Excel. AutoRecover doesn’t save your files in real time; instead, every several minutes it saves an AutoRecover file that you can try to recover after a crash. It doesn’t always work, though — for example, if you don’t properly open Excel after the crash, or if the crash doesn’t meet Microsoft’s definition of a crash. In addition, Microsoft notes, “AutoRecover is only effective for unplanned disruptions, such as a power outage or a crash. AutoRecover files are not designed to be saved when a logoff is scheduled or an orderly shutdown occurs.” And the files aren’t saved in real time, so you’ll likely lose several minutes of work even if all goes as planned. AutoSave is turned on by default in Excel for Microsoft 365 .xlsx workbooks stored in OneDrive, OneDrive for Business, or SharePoint Online. To turn it off (or back on again) for a workbook, use the AutoSave slider on the top left of the screen. If you want AutoSave to be off for all files by default, select File > Options > Save and uncheck the box marked AutoSave files stored in the Cloud by default on Excel. Using AutoSave may require some rethinking of your workflow. Many people are used to creating new worksheets based on existing ones by opening the existing file, making changes to it, and then using Save As to save the new version under a different name, leaving the original file intact. Be warned that doing this with AutoSave enabled will save your changes in the original file. Instead, Microsoft suggests opening the original file and immediately selecting File > Save a Copy (which replaces Save As when AutoSave is enabled) to create a new version. If AutoSave does save unwanted changes to a file, you can always use the Version History feature described below to roll back to an earlier version. Review or restore earlier versions of a spreadsheet There’s an extremely useful feature hiding in the title bar in Excel for Microsoft 365: You can use Version History to go back to previous versions of a file, review them, compare them side-by-side with your existing version, and copy and paste from an older file to your existing one. You can also restore an entire old version. To do it, click the file name at the top of the screen in an open file. A drop-down menu appears. Click Version History, and the Version History pane appears on the right side of the screen with a list of the previous versions of the file, including the time and date they were saved. (Alternatively, you can select the File tab on the Ribbon, click Info from the menu on the left, and then click the Version History button.) Use Version History to see all previous versions of a spreadsheet, copy and paste from an older file to your existing one, or restore an entire old version. Preston Gralla / Foundry In the Version History pane, click Open version under any older version, and that version appears as a read-only version in a new window. Scroll through the version and copy any content you want, then paste it into the latest version of the file. To restore the old version, overwriting the current one, click the Restore button. Try out Microsoft 365 Copilot in Excel — but don’t expect too much For an additional subscription fee, business users of Excel can use Microsoft’s genAI add-in, Microsoft 365 Copilot. You can have Copilot suggest and create charts, create formulas, mine spreadsheets for data insights you might have missed, and more. If you have a Microsoft 365 Personal or Family subscription, many of those features are now bundled with your core subscription. To start using Copilot in Excel, open a spreadsheet and click the Copilot button at the right of the Ribbon’s Home tab. The Copilot panel will appear on the right, offering suggestions for actions it can perform, such as summarizing your data with a chart, adding formulas to the spreadsheet, or applying conditional formatting to the sheet. You can also chat with Copilot in the panel, asking questions about your data or how to perform an action yourself. Note that these suggestions are generic and won’t always make sense. For example, when you start with a blank worksheet and click the Copilot button, its suggestions include summarizing data using pivot tables or charts, even though there’s no data to chart or put into a table. Microsoft 365 Copilot can help you in multiple ways in Excel, including creating formulas and charts, mining spreadsheets for insights, and more. Preston Gralla / Foundry In my testing, I found that Copilot wasn’t particularly helpful. For example, when I asked it to summarize data using a PivotTable or chart, several times it responded, “Something went wrong. Please try again in a moment.” Then it said that I first needed to reformat parts of my spreadsheet by using the Transform() function, and gave confusing advice on how I could do it — it wouldn’t do the task itself. (Eventually, I gave up.) When I asked it to suggest conditional formatting for my spreadsheet, which would highlight important data, it told me which data I should highlight but didn’t explain why the data was important. It also didn’t do the highlighting for me or tell me how to do it. I gave it one more try and asked it to perform an advanced analysis, which it would use Python to do. It certainly did something, although it was unclear what it was. It overwrote my original spreadsheet and added a section that claimed to show annual growth rates for revenue streams. But the data seemed to be incorrect. Perhaps advanced spreadsheet jockeys might be able to make sense of what Copilot is up to whenever they ask it for help. But mere mortal businesspeople may find it of no help at all. In my testing, I found Copilot not at all helpful, although spreadsheet jockeys may be able to make some sense of what it does. Preston Gralla / Foundry What’s more, Microsoft’s focus on Copilot in M365 has reduced the usefulness of Excel in some ways. For example, there used to be a handy feature called Smart Lookup that let you conduct targeted web searches from inside Excel. But at the beginning of 2025, Microsoft removed Smart Lookup from Excel, saying that the feature has been deprecated. Now the only way to search the web from inside Excel is via Copilot, which lacks some features of Smart Lookup — notably the ability to highlight words or phrases in a document and trigger an automatic web search. And M365 Copilot isn’t available to business customers unless they pay the additional subscription fee. Other features to check out Spreadsheet pros will be pleased with several other features and tools that have been added to Excel for Microsoft 365 over the past few years, from a quick data analysis tool to an advanced 3D mapping platform. Get an instant data analysis If you’re looking to analyze data in a spreadsheet, the Quick Analysis tool will help. Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. A small icon of a spreadsheet with a lightning bolt on it appears. Click it and you’ll get a variety of tools for performing instant analysis of your data. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly. The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. Preston Gralla / Foundry Translate text You can translate text from right within Excel. Highlight the cell whose text you want translated, then select Review > Translate. A Translator pane opens on the right. Excel will detect the words’ language at the top of the pane; you then select the language you want it translated to below. If Excel can’t detect the language of the text you chose or detects it incorrectly, you can override it. Easily find worksheets that have been shared with you It’s easy to forget which worksheets others have shared with you. In Excel for Microsoft 365 there’s an easy way to find them: Select File > Open > Shared with Me to see a list of them all. Note that this only works with OneDrive (both Personal and Business) and SharePoint Online. You’ll also need to be signed into you Microsoft or work or school account. Predict the future with Forecast Sheet Using the Forecast Sheet function, you can generate forecasts built on historical data. If, for example, you have a worksheet showing past book sales by date, Forecast Sheet can predict future sales based on past ones. To use the feature, you must be working in a worksheet that has time-based historical data. Put your cursor in one of the data cells, go to the Data tab on the Ribbon and select Forecast Sheet from the Forecast group toward the right. On the screen that appears, you can select various options such as whether to create a line or bar chart and what date the forecast should end. Click the Create button, and a new worksheet will appear showing your historical and predicted data and the forecast chart. (Your original worksheet will be unchanged.) The Forecast Sheet feature can predict future results based on historical data. Preston Gralla / Foundry Manage data for analysis with Get & Transform This feature is not entirely new to Excel. Formerly known as Power Query, it was made available as a free add-in to Excel 2013 and worked only with the PowerPivot features in Excel Professional Plus. Microsoft’s Power BI business intelligence software offers similar functionality. Now called Get & Transform, it’s a business intelligence tool that lets you pull in, combine, and shape data from wide variety of local and cloud sources. These include Excel workbooks, CSV files, SQL Server and other databases, Azure, Active Directory, and many others. You can also use data from public sources including Wikipedia. Get & Transform helps you pull in and shape data from a wide variety of sources. Preston Gralla / Foundry You’ll find the Get & Transform tools together in a group on the Data tab in the Ribbon. For more about using these tools, see Microsoft’s “Getting Started with Get & Transform in Excel.” Make a 3D map Before Excel 2016, Power Map was a popular free 3D geospatial visualization add-in for Excel. Now it’s free, built into Excel for Microsoft 365, and has been renamed 3D Maps. With it, you can plot geographic and other information on a 3D globe or map. You’ll need to first have data suitable for mapping, and then prepare that data for 3D Maps. Those steps are beyond the scope of this article, but here’s advice from Microsoft about how to get and prepare data for 3D Maps. Once you have properly prepared data, open the spreadsheet and select Insert > 3D Map > Open 3D Maps. Then click Enable from the box that appears. That turns on the 3D Maps feature. For details on how to work with your data and customize your map, head to the Microsoft tutorial “Get started with 3D Maps.” If you don’t have data for mapping but just want to see firsthand what a 3D map is like, you can download sample data created by Microsoft. The screenshot shown here is from Microsoft’s Dallas Utilities Seasonal Electricity Consumption Simulation demo. When you’ve downloaded the workbook, open it up, select Insert > 3D Map > Open 3D Maps and click the map to launch it. With 3D Maps you can plot geospatial data in an interactive 3D map. Preston Gralla / Foundry Automate tasks If you have OneDrive for Business and use Excel with a commercial or educational Microsoft 365 license, you can automate tasks with the Automate tab. You’ll be able to create and edit scripts with the Code Editor, run automated tasks with a button click, and share the script with co-workers. See Microsoft’s “Office Scripts in Excel” documentation for details. Insert data from a picture into Excel There are times you may find data inside an image file that you’d like to get into Excel. Typically, you’ll have to input the data from it manually. There’s now a way to have Excel convert the information on the image into data for a worksheet. In the Get & Transform Data group on the Data tab, click the From Picture dropdown and select Picture From File to choose the image you want to grab data from, or Picture from Clipboard to take a screenshot of an image on your PC and then import the data. For more details, see Microsoft’s “Insert data from picture” support page.   Use keyboard shortcuts Here’s one last productivity tip: If you memorize a handful of keyboard shortcuts for common tasks in Excel, you can save a great deal of time over hunting for the right command to click on. See “Handy Excel keyboard shortcuts for Windows and Mac” for our favorites. This article was originally published in August 2019 and most recently updated in May 2025. More Excel tutorials: Excel basics: Get started with tables Excel basics: Get started with charts and sparklines How to use PivotTables and PivotCharts in Excel How to use slicers in Excel How to use Excel formulas and functions How (and why) to use conditional formatting in Excel How to use Excel macros to save time and automate your work
    0 Комментарии 0 Поделились 0 предпросмотр
CGShares https://cgshares.com