Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Close
eBook Download

If you would like to receive our FREE eBook, please enter your email address below and click Send eBook.



Send eBook


Video Tutorials - Formatting in Excel Resources
Video Tutorials - Formatting in Excel Resources
 

Video Tutorials - Formatting in Excel

Content produced for your benefit: use, modify and share as you wish

Dates Need to Be Formatted!

When using spreadsheets created by different people, you may notice they use different formats for data in the cells. Differing date formats tend to be the most common and correcting these so they are uniform, can be a real pain, particularly if people are...
The Need for Formatting... or Re-formatting

When you are working with dates, currency and numbers in Excel, it is important to present data in an attractive and uniform way. And we all have our own preferences.

But when you work on a spreadsheet that has been created by someone els...
Sometimes multiple format changes are required in Excel on various locations and sheets within a Workbook, this can be time consuming and ineffective.  Excel can provide a more efficient way of doing this for you.

Format Painter is a very powerful and efficient method of copying for...
Excel will often wrap text onto multiple lines within a cell when a column is too narrow. This is fine in most situations but can be annoying if you are trying to format a spreadsheet and ensure that your data fits how you want it to in the columns.

Let’s look at an example below:

...
When working with Excel it could be useful to select data from a drop down list of options and have that selection further filter information available from another drop down list.

E.g. you could select the application name such as Excel and a second drop down list would only show th...
Formatting data is important in Excel as it allows you to apply emphasis to information as well as clearly mark any headings and totals.

The useful ones for your data are things like Control + B for Bold, Control + I for italic. Control + U for Underline. Alignment shortcuts don’t ...
It can be useful to turn Gridlines off and on to create better looking spreadsheets and forms.

Click on the View Ribbon and turn off the Gridlines by unchecking the gridlines box. You can apply your own formats to the data as needed and press Save to keep your changes.

It may help ...

Stay in touch
          TrustPilot
CPD
ILM
ISO9001


Back to top
HOME
QUICK COURSE FINDER
Microsoft Courses
Business Skills Courses
Personal Development Courses
Where Courses Take Place
How to Contact Us
Information & Resources
Assertiveness
Time Management
Communication Skills
Likeability
Online Training FAQ
TRY BEFORE YOU BUY
VIDEO: How to Use It
Assertiveness
Time Management
Communication Skills
Building Relationships
Anger Management
Managing Your Stress
Free Microsoft Office Course
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Management Skills
Performance Management
Supervision & Teams
Training & Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
HR and Recruitment
Train the Trainer
Sales
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Telephone Skills
Touch Typing
Customer Service
Receptionist Skills
Assertiveness
Time Management
Communication Skills
Building Relationships
London Victoria (SW1) NEW
London Victoria Street (SW1)
Tower Bridge (E1)
Bristol (BS5) NEW
Milton Keynes (MK9) NEW
Reading (RG1)
Slough (SL1)
Birmingham (B4)
Nottingham (NG1)
Manchester Piccadilly (M1) NEW
Leeds West One (LS1) NEW
Leeds Oxford Row (LS1)
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this