Cart  Purchase History
Skip to content
Excel Effects

Excel Effects

Excel charts, dashboards, templates, tools, and games

  • Home
  • Software
  • Education
  • Games
  • About
  • Contact

Excel

Add an average line to a column chart – Quick tip

Posted on October 27, 2020October 27, 2020 by Excel Effects

Add an average line to a column chart – Quick tip This quick video tip shows you how to add an average line to a column chart. Related content Present your data in a column chart Online courses Home

Learn More
Education Excel Quick tips Video

Add or remove items from the quick access toolbar

Posted on October 26, 2020October 26, 2020 by Excel Effects

So, this super quick tip shows you how to add or remove items from the quick access toolbar (or QAT). All in all, this lesson applies to versions of Office that have a QAT. Overall, the QAT allows us to access commands that we use frequently. It is located either above or below the ribbon. […]

Learn More
Education Excel Quick tips

Assign a macro to a command button in Excel

Posted on October 24, 2020October 25, 2020 by Excel Effects

This lesson shows you how to assign a macro to a command button in Excel. A button is a great way to show the user a clickable item on your sheet. Furthermore, it helps you automate tasks in a user friendly manner. Right-click note In part of this lesson, you may see the term right-click. […]

Learn More
Education Excel Quick tips

Assign a macro to a shape in Excel – Quick tip

Posted on October 25, 2020October 25, 2020 by Excel Effects

Certainly, you knew you can assign a macro to a shape in Excel? If not, then this lesson will show you how to do that. Anytime you are able to custom something, it leaves the door open to new ideas. In this case, you can design dashboards, games, and even automate tasks. And, having control […]

Learn More
Education Excel Quick tips

Create a shape link to a cell in Excel – Quick tip

Posted on October 20, 2020October 24, 2020 by Excel Effects

In Excel, we will create a shape link to a cell. Meaning, we will put the value of a cell inside a shape. And, when you update that cell, the value within that shape is updated. After you establish a link, that ordinary shape turns into a dynamic floating shape. Good stuff, huh! For the […]

Learn More
Education Excel Quick tips

Creating a navigation bar in Excel – Quick tip

Posted on November 12, 2020November 12, 2020 by Excel Effects

When creating a navigation bar in any program, it greatly enhances the user experience. And, it is even better if you do it in Excel. You see, if your app is easy to navigate, then that makes it more efficient. In the end, that is what you want. Therefore, this quick tip focuses on creating […]

Learn More
Education Excel Quick tips

How to create a multi-line shape link to a cell in Excel

Posted on October 27, 2020October 27, 2020 by Excel Effects

How to create a multi-line shape link to a cell in Excel This quick tip video shows you how to create a multi-line shape link to a cell in Excel. Overall, it is a great way to introduce floating elements to create a dashboard. And, although we like the camera tool, a shape link uses […]

Learn More
Education Excel Quick tips Video

How to show or hide an object in Excel with a button click

Posted on November 3, 2020November 8, 2020 by Excel Effects

This quick tip shows you how to show or hide an object in Excel with a button click. So, you guessed it! Once you learn how to do this, just think about all of the possibilities. For example, design your own game or a dashboard in Excel, like Jeopardy or a financial tool. Of course, […]

Learn More
Education Excel Quick tips Video

Open the Visual Basic for Applications editor in Excel

Posted on October 24, 2020October 24, 2020 by Excel Effects

This super quick tip shows you how to open the Visual Basic for Applications (VBA) editor in Excel. Overall, the VBA editor allows you to do some amazing stuff with code. Again, we just show you how to open the editor here. However, we will go more in depth with VBA in a later lesson. […]

Learn More
Education Excel Quick tips

Record a basic macro in Excel – Quick tip

Posted on October 23, 2020October 24, 2020 by Excel Effects

This quick tip shows you how to record a basic macro in Excel. On the whole, a macro lets you perform a set of tasks automatically. For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible. Steps to record a basic macro in Excel Follow the steps below to […]

Learn More
Education Excel Quick tips

Posts navigation

Older Posts
Excel Effects Home Return to Top

Development Category (English)300x250

Artplotty Grid


  • Home
  • Software
  • Education
  • Games
  • About
  • Contact
Software

Online apps

Chart library

Real data charts

Dashboards

Templates

Vintage

All software

Education

All education

Games

Bubble Dip Match

Wingding Match

All games

The social stuff

 

Designed and programmed by: Excel Effects

© Copyright 2020. All rights reserved. Privacy policy  Software agreement