Profile cover photo
Profile photo
Michael Rempel
164 followers
164 followers
About
Communities and Collections
Posts

Post has attachment
This is an update to a previous post on setting a dynamic print area, but addresses the issue of determining the height of the print area based on several columns, not just a single column of data.
Add a comment...

Post has attachment
Let's say you have a large amount of data and want to be able to "scroll" through it without having to page down dozens of times. Maybe you also want a chart that dynamically adjusts as you scroll through the data. Excel can do that!
Add a comment...

Post has attachment
In this tutorial we are going to see how we can locate a value within a data range
Add a comment...

Post has attachment
In this tutorial we are going to see how we can locate a value within a data range
Add a comment...

Post has attachment
In this tutorial we are going to look at the Auto Complete option in Excel, and a very useful and time-saving feature that Excel offers.
Add a comment...

Post has attachment
In this tutorial we are going to look at the Logarithmic Scale option for formatting charts.
Add a comment...

Post has attachment
In this tutorial we will review how different time formats will change the view of the results when you are adding a list of cells with time, and could give you what appears to be incorrect answers.
Add a comment...

Post has attachment
In this tutorial we are going to write a formula that allows us to increase the dates in a column by one every time a block of unique values repeats.
Add a comment...

Post has attachment
In this tutorial we are going to look at two ways to convert dates that are formatted in odd ways, for example using commas or periods to separate the month, day, and year, to a format that uses the forward slash, which is more traditionally used in Excel.
Add a comment...

Post has attachment
In this tutorial we are going to use Conditional Formatting to show two ways that we can draw a line in a table at each change in the list of a specific column of that table. One method will draw a thin line, the other will make that line much bolder.
Add a comment...
Wait while more posts are being loaded