How to Make Beautiful Excel Spreadsheets Very Quickly

Focused View

Keith Griggs

35:07

150 View

1. Introduction

1. Welcome to my course.mp4

02:03

2.1 excel formatting and dates.xlsx

2. Downloadable spreadsheet that I created during the course.html

2. Basic formatting

1. Format painter, quick access toolbar, font, font size.mp4

02:29

2. Bold, italics, underline, borders, clear formats.mp4

02:52

3. Fill, color, alignment, fill series.mp4

02:23

4. Word wrap, merge cells.mp4

01:51

5. Currency, percentages.mp4

01:36

3. Advanced formatting and gridlines

1. Conditional formatting, highlighting negative cells, data bars, color scales.mp4

03:54

2. Formatting a table.mp4

02:29

3. Using styles and format dropdown.mp4

03:03

4. How to do strikethrough and superscript.mp4

01:37

5. How to remove gridlines, add them back, and how to print out with them included.mp4

03:03

4. Working with dates

1. Formatting dates and time.mp4

05:29

2. How to sort and calculate dates.mp4

02:18

Description

Master Excel Formatting, Merging, Percentages, Dates, conditional formatting etc

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

Who is this for?

Beginner Excel users who want to know how to format beautifully and quickly, and use dates

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Keith Griggs

Instructor's 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.