Category Archives for "Excel"

KPIs, Metrics, Validation Metrics, and Learning Loops

Excel

To improve any business, you have to measure and manage using Key Performance Indicators (KPIs) and metrics. But, to meet your strategic objectives you may also need validation metrics and learning loops. KPIs measure change in your strategic objectives. You should choose other metrics to help you,Cross-check for cheatingAid process improvementAid troubleshootingThis example of KPIs, metrics, […]

Read More

19 Top Tips on Excel Advanced Filter and Excel AutoFilter

Excel

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

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

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

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

Get Max Productivity from these Windows 10 Tricks

Excel , Professional Skills

My son goes to a technology high school where they build robots, do experiments with DNA, and play with stuff that was science fiction when I was in school. He is part of a cabal that trades tips on how to use Windows 10 to its max. His fingers fly across his Windows 10 laptop, […]

Read More

Use an Excel-Based Decision Matrix for Critical Decisions

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

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

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

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
1 2 3 15