Sage City Community
Sage City Community
  • Product Support
    • Africa & Middle East
    • Canada
    • France
    • Portugal
    • Spain
    • United Kingdom & Ireland
    • United States
    • Global Solutions
  • Community Help
  • Cancel
  • User
  • Site
  • Search
  • User

Community Help
Community Help
Community Help
Excel Tips & Tricks
  • Support Resources
  • Sage City VIPs
  • More
  • Cancel
  • Subscribe by email
  • More
  • Cancel
  • Tags
  • Subscribe by email
  • More
  • Cancel
  • How to easily insert multiple rows to expand a table in Excel

    How to easily insert multiple rows to expand a table in Excel

    melentha
    melentha
    Inserting multiple rows in a table can be very time consuming.  In this Excel tip, rows will be inserted based on the specified number in a column. This…
    • 19 Aug 2020
  • 3 easy ways to convert text to numbers

    3 easy ways to convert text to numbers

    melentha
    melentha
    Sometimes when importing data from another program into Microsoft® Excel®, the numbers are stored as text which causes havoc in your report. In some instances…
    • 22 Jul 2020
  • How to change the fill colour in multiple cells

    How to change the fill colour in multiple cells

    Mathew Love
    Mathew Love
    Sometimes when working in Excel, you may want to change the colour in multiple cells without having to do each one separately. For our example below, we…
    • 31 May 2020
  • How to change the order of your chart legend

    How to change the order of your chart legend

    Mathew Love
    Mathew Love
    In an Excel chart, the series is in a particular order, and the legend entries are listed in their own particular order based on certain criteria.  Sometimes…
    • 28 Apr 2020
  • How to custom sort a slicer in Excel

    How to custom sort a slicer in Excel

    Mathew Love
    Mathew Love
    It's not always possible to get a slicer to display in the order that you need it to. In our example, the sample displays in an alphabetical order…
    • 23 Mar 2020
  • How to add bullet points to a field in Excel

    How to add bullet points to a field in Excel

    melentha
    melentha
    Using Excel, have you tried to add a bullet point within a field to stack numbers, sentences or phrases?  Adding a bullet point helps the reader to see…
    • 17 Feb 2020
  • How to quickly and easily combine text from multiple columns in Excel

    How to quickly and easily combine text from multiple columns in Excel

    melentha
    melentha
    You don’t have to create complicated formulas to combine text from multiple columns to a single column. In this Excel tip, we will show you how to quickly…
    • 14 Jan 2020
  • eBook: 6 Tips and Tricks on Excel Charts

    eBook: 6 Tips and Tricks on Excel Charts

    melentha
    melentha
    We've created this handy eBook which contains 6 tips and tricks that will help you make the most of Microsoft® Excel® charts. Download Now…
    • 16 Dec 2019
  • How to Create Dynamic Chart Titles in Excel

    How to Create Dynamic Chart Titles in Excel

    melentha
    melentha
    Have you ever wanted to personalize your chart headings to further enhance the user’s report experience?  In this tip we will show you how to customize…
    • 18 Nov 2019
  • How to Create Row Groups Using Excel to Hide Account Detail

    How to Create Row Groups Using Excel to Hide Account Detail

    melentha
    melentha
    Most people who view financial reports prefer to look at the highest account level first then open the detail when needed.  In this tip, we will show you…
    • 17 Oct 2019
  • How to highlight data points in an Excel chart using Form Controls

    How to highlight data points in an Excel chart using Form Controls

    melentha
    melentha
    It is sometimes not always easy to trace which data point relates to which series in a chart, especially when it comes to a line chart.  To overcome this…
    • 17 Sep 2019
  • How to Extract a List of Named Ranges in Excel

    How to Extract a List of Named Ranges in Excel

    melentha
    melentha
    Named ranges are an essential feature in Microsoft® Excel®.  They are easy to use in formulas and can be used anywhere in a workbook. The trick…
    • 16 Aug 2019
  • How to create a simple financial dashboard in Excel

    How to create a simple financial dashboard in Excel

    melentha
    melentha
    When viewing numerical data in Excel, you may at some point want to represent this data visually. This gives you the ability to easily analyze large amounts…
    • 17 Jul 2019
  • How to create a multi column data validation list in Excel

    How to create a multi column data validation list in Excel

    melentha
    melentha
    When using a data validation list, only one column of data is displayed, but sometimes there is a requirement for additional columns to be displayed simultaneously…
    • 27 Jun 2019
  • How to stop your Excel charts from disappearing

    Glynnis
    Glynnis
    Have you ever experienced your Excel charts disappearing when you hide the columns showing the data? By default, Microsoft  Excel  shows only visible data…
    • 16 May 2019
  • How to automatically highlight specific data using a bar chart in Excel

    Glynnis
    Glynnis
    This Microsoft  Excel  tip will come in handy when you want to create a chart that will populate your data and highlight only specific parts of that data…
    • 14 Apr 2019
  • How to create a step chart in Excel

    Glynnis
    Glynnis
     A step chart shows changes that occur over irregular intervals. For example, it can show stock movement changes, interest rates, etc. A step chart  is the…
    • 12 Mar 2019
  • How to format a chart in Excel to dynamically show its maximum value

    Peter Scully
    Peter Scully
    Data visualisation is fast becoming the norm for effective business intelligence. Having visuals that tell the right story at a glance go a long way in…
    • 14 Feb 2019
  • Our Top 5 Excel tips of 2018

    Melentha M
    Melentha M
    These Microsoft   Excel   tips and tricks are the top performing tips of 2018, and have raked up a combined viewership of over 200 000. Without further ado…
    • 10 Jan 2019
  • Learn how to identify duplicate rows in your data

    Peter Scully
    Peter Scully
    In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function.   You can find it here.   At…
    • 28 Aug 2018
  • How to create a linked dashboard (or landing page) for your Excel workbook

    David Bryant
    David Bryant
    Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently…
    • 21 Aug 2018
  • How to add a variance and running total in a Pivot Table

    Glynnis
    Glynnis
    In our example workbook, we're working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per…
    • 31 Jul 2018
  • Using Wildcards to make finding or replacing data in Excel quicker and easier

    Sage Business Intelligence Blog team
    Sage Business Intelligence Blog team
    This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the…
    • 26 Jul 2018
  • Sorting data in a PivotTable with Microsoft Excel

    Sandra Smith
    Sandra Smith
    Sorting data in alphabetical order or numerical order is helpful when you have large amounts of data in the PivotTable you created. Sorting lets you organize…
    • 16 Jul 2018
  • How to insert icons into a spreadsheet

    nigelnaicker
    nigelnaicker
    This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It's lead by a repository of every icon…
    • 5 Jul 2018
>
Sage
Africa & Middle East Australia Canada France Portugal Spain United Kingdom & Ireland United States Global Solutions
  • facebook
  • instagram
  • linkedin
  • youtube
COMMUNITY
  • Community Help
  • Site help
  • Site map
COMPANY
  • Overview
  • About us
  • Careers
  • News
  • Sage events
  • Investors
  • Sage Foundation
PARTNERS
  • Sage Partner Program
  • Partner Hub
  • Developers & ISVs
  • Sage Marketplace
SUPPORT & TRAINING
  • Contact Support
  • Sage Knowledgebase
  • Sage University
  • Sage Advice Blog
  • © Sage Group plc 2022
  • Privacy
  • Cookies
  • Community guidelines
  • General data protection regulation