by Roy Davis | Jul 27, 2018 | Excel |
Keyboard shortcuts are incredibly useful in any productive work. All to often, people neglect to use them in Excel. This article will cover border keyboard shortcuts so that you may quickly create and manipulate borders. Of course you can use the border menu up near...
by Roy Davis | Jul 6, 2018 | Excel |
Sometimes you want your Excel spreadsheet to display data differently in file than on paper. Effectively what you can do is add custom views to print empty cells. To see a use case, let's take a look at this question from Jack: I have one excel sheet, in that sheet I...
by Roy Davis | Jun 2, 2017 | Excel |
Before we jump into Excel content, it's important to nail down some basic Excel terms so we're all on the same page. After working in IT for many years, I got a chance to help a wide variety of people. You'd be surprised how many people get basic terms wrong. This...
by Roy Davis | Jan 6, 2017 | Excel |
Introducing a non-intimidating, beginner Microsoft Excel course. Learn to solve problems in this beginner Excel crash course. Now available on Udemy. Update: the course link has been removed from this post. I will be publishing this course to YouTube. If you've ever...
by Roy Davis | Jul 17, 2016 | Excel |
I present to you, quick Excel 2016 spreadsheet knowledge in laminated guide goodness. Of course you can make these yourself but they are cheap enough pickup and keep near your workstation. Microsoft Excel 2016 Introduction Reference Card (instructions, tips, and...