How to Make Beautiful Excel Spreadsheets Very Quickly
What you'll learn
- How to format cells and tables beautifully and quickly
- How to merge cells
- How to wrap text
- How to copy formats with format painter
- How to do conditional formatting
- How to do data bars
- How to format a table with a few clicks
- How to calculate with percentages
- How to change date formats
- How to sort by date
- How to find the length of time between two dates
Requirements
- Have Excel for Windows installed. If you use a Mac, some of the commands and icons will be different.
- Have at least a basic knowledge of Excel eg how to copy and paste, create new sheets etc
Description
Impress your boss and co-workers with your beautiful and very useful spreadsheets.
I used to be an accountant and financial controller and I made beautiful spreadsheets all day long for many years.
Learn the basics and more advanced techniques such as conditional formatting. This allows you to do some amazing things such as highlighting negative cells as red so that they stand out. I also show you how to add data bars and color scales to your column of numbers which really brings your data alive and makes it much easier to understand the numbers.
Also learn how to format dates many different ways including adding the day of the week to the date.
Who this course is for:
- Beginner Excel users who want to know how to format beautifully and quickly, and use dates
Instructor
![Keith Griggs](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 810 Reviews
- 53,978 Students
- 5 Courses
I an English and live near London. I am a qualified accountant. I worked for many years in industry as a Financial Controller and CFO.
I really love Excel and have been using it pretty much all day every day for over 30 years.
Now my mission is to share my knowledge and passion for Excel so that other people can benefit from it as much as I do.