Posted inPower of Microsoft Office
Count a Weekday between Two Dates in Excel
Building a custom function in Excel's Advanced Formula Environment to count a specific weekday between two dates.
Posted inPower of Microsoft Office
Excel Tip: Convert Numbers to Dates with Text to Columns
Using Text to Columns in Excel to convert a date represented in numbers into a formatted date.
Posted inPower of Microsoft Office
Excel Tip: Custom Cell Formatting
Using Custom Cell Formatting in Excel to make a numeric value more informative by attaching text to numeric cells.
Posted inPower of Microsoft Office
Excel Tip: Fill Blank Cells Using “Go To” Wizard
Use the "Go To" wizard in Excel to fill blank cells regardless of their count.
Posted inPower of Microsoft Office Six Sigma
Creating Pareto Chart in Microsoft Office Excel
During the Define step of a Six Sigma project the project team needs to identify the problem or the opportunity that the project is intended to solve. Usually, there would…
Posted inPower of Microsoft Office
Calculate Loan Terms using Goal Seek in Microsoft Excel
Goal Seek feature in Microsoft Office Excel is used to find out the correct input value to a formula in order to get a desired formula result. This video shows…
Posted inPower of Microsoft Office
Summarize your data with PivotTables
A PivotTable report is an interactive way to quickly summarize large amounts of data. In this video I will show you how to create a summary report using PivotTable in Microsoft…
Posted inPower of Microsoft Office
Best practice to VLookup values in Excel
Vlookup is a function that helps you search for a value in a range of cells and return the same or a different value from that range on the same…
Posted inPower of Microsoft Office
Customize Excel Ribbon and make your macros default commands
I believe that efficient use of Microsoft Office Excel has a tremendous effect on office work efficiency. With this blog I start a series of powerful tips and tricks that…