Worksheets can be linked so that information shared between the two is always identical. This reduces errors and ensures consistency as information only needs to be entered in one place to be available in multiple locations. In our example today, data is gathered and duplicated between employees and departments. One employee compiles a sheet with…
Read More
Have you ever inherited a worksheet that someone else set up or you created and haven’t played in for some time? If you need to update the formulas and functions, but do not know what other calculations will be affected you could quickly make a lot of work for yourself! You might also be hunting…
Read More
Subtotals are dynamic in that they adjust instantly based on filters. They are very useful when reviewing a table, as you can make small adjustments to see different perspectives on the information. Create a Subtotal Determine which column you want to subtotal. Sort the selected column (Column A in this example) so that the like…
Read More
Excel allows you to set certain cells to accept only a certain data format that you specify. You can prompt the user with guidelines about the proper way to enter their data. You can even specify that data must fall in a certain data range if you wish. When data entered does not match your…
Read More
Want a quick way to view and interpret data directly in the tables without resorting to graphs or charts? You can add color bars, icons or graphics that reflect the meaning of the data in each cell to get an “at a glance” view of your data. Conditional formatting means that the formatting applied to…
Read More
After your sparklines have been created, Excel offers several tools for you to control which value points are shown, set options on the vertical axis, and define how empty values are displayed. You can also change colors, apply styles from Office’s pre-loaded style gallery or apply a custom style that you have saved. Change Value…
Read More
A sparkline is a tiny chart in the background of a cell. When you use a sparkline, you can easily see the relationships between it and its underlying data. And, you can copy sparklines to adjacent cells by using the Fill Handle. Sparklines are printed as-is when you print a worksheet that contains them, unlike…
Read More
Do you want to enhance your Excel dashboard, charts or reports with branded colors and elements? Say you are working on a new marketing effort that requires a specific look and feel. These elements include specific color combinations to match your corporate logo and so on. It’s possible that Excel’s built-in document themes are not…
Read More
There are many ways to filter and isolate data in Excel. Using data filters is one of the fastest ways to locate the data you seek under set criteria. Say, you are looking at a list of sales records for a particular time period that includes multiple stores, sales associates, items and other information. You…
Read More
Have you ever been asked to present your data in specific accounting formats? Excel provides a multitude of preset formatting options for customizing numbers, dates and times. You can present data in the way that best expresses your needs and conforms with any government, industry or company standards and styles that might apply to your…
Read More
Excel Tips & Tricks is written by the Microsoft® Excel® experts at Fred Pryor Seminars and CareerTrack. Known for our extensive Excel training, we offer some of the best in the business. Don’t waste precious time trying to figure things out on your own. Attend one of our outstanding Excel courses and gain the knowledge you need to use Excel more effectively and efficiently. Check out an Excel course coming to a location near you when you click here.
Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 9,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
