Category Archives for "Excel"

19 Top Tips on Excel Advanced Filter and Excel AutoFilter

Excel , List and Table , Reporting , Top Tips

Excel AutoFilter is a simple Excel feature for filtering lists. But, the Excel advanced filter has far more powerful filtering and extracting capability you will want to use with To Do Lists, Contact Lists, Project Task Lists, Inventory Lists, and more. These tips begin with the simple AutoFilter in Excel and go on to show […]

Read More

18 Top Tips for Creating Excel Lists or Excel Tables

Excel , List and Table , Reporting , Top Tips

People love putting their To Do List, Contact List, and Project Task List in Excel. These tips will show you how to make your lists even more friendly and useful by converting them into an Excel Table. Click here to learn how to use Excel AutoFilter or Excel advanced filter with your lists or Excel […]

Read More

10 Top Tips for Creating an Excel Budget or Excel Budget Template

Excel , Reporting

Excel is the world’s most used tool for creating, aggregating, and analyzing budgets. Distributing an Excel budget template will reduce work and make sure everyone is aligned. Starting your budgeting process with an Excel budget template and a list of guidelines will reduce work and keep your managers aligned. Budget tips include how to prevent […]

Read More

19 Top Tips on Excel’s IF Functions and Formulas

Excel , Functions , Top Tips

Excel’s IF function makes If…Then… decisions in your workbook formulas. The IF function and its variations are a must if you want to build powerful worksheets that go beyond simple math or financial calculations. If you already consider yourself an IF function expert, you might want to check Tips 7, 9, 13, 14, and 19 […]

Read More

Use an Excel-Based Decision Matrix for Critical Decisions

Decision Making , Excel

Prioritizing, justifying, and documenting decisions are easier when you use an Excel-based decision matrix. However, there are a few rules that will make this work better for you. For clarity, this description and the downloadable Excel sheet show a set of prioritized projects. You can use this method to prioritizing or deciding between many types […]

Read More

Top 26 Best Excel Conditional Formatting Tips and Tutorial

Excel , Formatting , Top Tips

Conditional formatting in Excel applies formatting to cells when the cell’s content meets specific conditions, such as the content being greater than a number you specify. These top 26 best tips on Excel conditional formatting begin with the basics tips and progress to advanced tips, like using conditional formatting to find errors, using wildcard matches […]

Read More

Top 16 Best Excel Function and Formula Tips Every Excel User Should Know

Excel , Formulas , Functions , Top Tips

These are the top 16 Excel function and formula tips every Excel user at any level of experience should know. Even “experts” can learn new tricks or combine old tricks to work faster and more efficiently. As you scan these tips keep a “beginner’s mind.” A beginner’s mind helps you see new opportunities and insights. […]

Read More

Top 23 Excel Formatting Tips

Excel , Formatting , Top Tips

These are the top 23 best tips on Excel formatting taken from research on top-ranked Excel websites and judged by 30 years of using Excel (back when it came on about 14 diskettes). Even if you consider yourself an Excel expert, you should keep a “beginner’s mind” as you scan this list of 23 Excel […]

Read More

Top 21 VLOOKUP Tips and Tricks

Excel , Formulas , Functions , Top Tips

Use VLOOKUP to find and retrieve data from an Excel list. This list of the top 21 best VLOOKUP tips will take you from novice to master in retrieving data from Excel lists. You can use VLOOKUP to, Look up prices, names, or regions from a list Use one item to find related items in […]

Read More

Show or Hide Data and Charts with Dynamic Excel Reports

Excel , Reporting , VBA

With a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected sales regions or to expand a table to show […]

Read More
1 2 3 15