The Excel Essential Skills category groups together posts that cover the essential skills needed to confidently create Excel worksheets that are both professional in look and design.
Let me help you learn how to subtract in Excel.
It's simple when you're shown how, but read to the end to make sure you understand what happens when you multiply and subtract, or divide and subtract in the same formula.
This is a tricky one, so please don’t skip over it!
Need a hand to unhide columns in Excel?
There are different methods or unhiding available to you, depending on the version of Excel you are using.
I'll take you through the method that will work on any version.
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter.
It doesn't matter if I'm delivering a Stage 1 or a Stage 3 Excel training course - when I'm demonstrating to the class I whip around the screen, format, select and modify and update using shortcut keys.
If you share Excel files outside of your organisation you’ll enjoy this post where I share with you how to remove Excel formulas and keep the results so that you can confidently send a file knowing you aren’t disclosing confidential information inside of your formulas.
Learn how to move, copy and paste information in Excel. Once you have mastered Cut, Copy and Paste you will find yourself shifting data around easily and reusing copied data, saving you the need to recreate the same information again.
All Windows applications have access to the Windows Clipboard. This is a special area used for moving and copying information.
The ‘Cut’ command moves a selection to the Clipboard while the ‘Copy’ command copies a selection to the Clipboard.
Continue Reading
Learn how to add colour, borders and alignment settings to your Excel data to give your worksheet a more professional look and to make it easier for others to read. Read more
Formatting lets you change the appearance of data to control exactly how Excel will display the data on a worksheet.
An example of formatting is to add dollar signs, percentage signs and decimal places to Excel data. Continue Reading
Learn how to preview your work before printing and how to print all or part of an Excel worksheet. Continue Reading
Learn how to insert page breaks and scale an Excel worksheet for printing.
Once you have your worksheet created and formatted you may want to print it. Printing can be extremely challenging if you don’t know how to control where page breaks occur and how to fit your worksheet to print on a page so that you avoid having one row or one column printing on a following page.
The Page Setup commands allow you to set the appearance of the printed worksheet. Many Page Setup options apply to every page of the active worksheet. Continue Reading
Learn how to insert, delete and hide rows or columns in Excel.
Once the basic worksheet is completed and tested, it may be expanded by inserting additional columns and rows. Additionally you can easily remove information from view simply by hiding it.
Continue Reading