Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Tips and Tricks for Using Visual Tools in Excel

November 4, 2015 by Tyrone Pernsley

Excel has many visual tools built in to help you effectively display your data. With features like themes, tables, and SmartArt, you can easily make your data viewer-friendly. Check out these tips to help you effectively use Excel Visual Tools.

Excel Visual Long Guide image 1

Themes:

Themes help you make quick adjustments to the entire workbook for consistent colors and fonts. To choose a theme, click on the “Themes” button on the “Page Layout” tab. The themes you can choose from involve different color schemes and formatting that affect your font, cell background colors, and other colors throughout charts and diagrams. Identical themes exist in Work and PowerPoint, so it’s simple to standardize the appearance of different file types for the same project.

Excel Visual Long Guide - image 2

Form Controls:

These help you create interactive worksheets, which allows you to make your data more interesting and user-friendly. To use form controls, go to the “Developer” tab and click on the “Insert” button. From there, you can choose from buttons, combo buttons, check boxes, spin buttons, list boxes, option buttons, and scroll bars. After selecting the one you want to use, click and drag it into your spreadsheet. When it’s in place, right click the control and select “Format Control”. You will then need to choose which cell(s) you want to be associated with that control.

Excel Visual Long Guide image 3

Tables:

Convert your data to tables to make list organization and dynamic charts easier. You can quickly create a table to organize your data by clicking on the “Format as Table” button on the “Home” tab. You’ll be prompted to pick a style and you can choose from different formats and color schemes. In a table, new formulas you enter are automatically copied down the column to make it easier to make calculations.

You can convert data into a table in four different ways:

  • Press “Ctrl” + “t”
  • Press “Ctrl” + “l”
  • On the “Home” tab, click on the “Table” button
  • On the “Insert” tab, click on the “Table” button

Once this chart has been created, any new column you add on the right-side or any row on the bottom of your source data will automatically be added to the chart. If you insert or delete rows in a table, the color scheme adjusts automatically

Sparklines:

This feature allows you to create in-cell charts that give you a quick visual representation of your data. It complements your data well and allows you to display important trend information. You can display trends in a single cell in a few ways: line, column, or win/loss. To insert a sparkline in your spreadsheet, go to the “Insert” tab and click on the “Sparkline” button. From there, indicate where you want your sparkline to go and click “Ok”.

(insert image 3 here)

SmartArt:

SmartArt gives you 200+ options for creating charts, process flow diagrams, Venn diagrams, and more. To use SmartArt, go to the “Insert” tab and click on the “SmartArt” button. From there you will be able to choose which type of graphic you want: list, process, cycle, heriarchy, relationship, matrix, pyramid, or picture. Select which type of graphic you want, then select from the styles in that category.

Display Your Data as an Outline:

When working with a lot of data, you can display your data as an outline so you can quickly expand or collapse the view of the data. To enable this feature, go to the “Data” tab and click on the “Group” button. Select “Auto Outline”. From there you can click on the different outlining levels, which are on the left, above the data, to expand and collapse your data. If you want to hide or display outline number levels, you can do this easily by pressing “Ctrl” + “8”.

 

Kevin – Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In