How to Create Professional Looking Excel Spreadsheets

Spreadsheet design is often overlooked but the process is quite simple. Making professional looking sheets will make YOU look more competent and will impress your boss, colleagues and clients.

Read the full blog post here

Table of Contents:

01:15 - Step #1 Correct Allignment
01:46 - Step #2 Distinguish Headings
02:00 - Step #3 Use Fewer Colors
02:19 - Step #4 Add I Row Above and One Row Left
02:45 - Step #5 Remove Borders
03:13 - Step #6 Use Calibri or Arial Font
03:47 - Step #7 Center Your Title
04:06 - Step #8 Resize Rows and Columns
04:12 - Marker
04:44 - Step #9 Add Graphs, Charts and Tables
05:03 - Step #10 Add Color to Sheet Tabs
05:22 - Step #11 Freeze Header Row
05:51 - Step #12 Add Zebra Stripe
06:14 - Zebra Stripe Formula --------------------------------

👇 SUBSCRIBE TO NATE’S YOUTUBE CHANNEL NOW 👇

🎁Random prizes and giveaways for followers across all of my social channels!🎁

This channel is dedicated to sharing tactical tips on how to make money online. Whether you just want to earn some side money or make enough money to quit your full time job and tell your boss what you think of him/her on the way out, this channel has something for you.

This channel covers:

👉 E-Commerce (Selling on Amazon, Clickfunnels and Shopify)
👉 Internet Marketing and Copy Writing
👉Outsourcing
👉Blogging and Content Creation

★☆★READ NATE’S BLOG★☆★

★☆★RESOURCES★☆★

★☆★ CONNECT WITH NATE ON SOCIAL MEDIA ★☆★

🎁 Random prizes and giveaways for followers across all of my social channels! 🎁

#MakeMoneyOnline #MakeMoney #Marketing #SideHustle

[KeyserTheRedBeard]

really good content EntreResource. I smashed that thumbs up on your video. Always keep up the awesome work.

[phxJohn]

@4:15 - For resizing columns - it you put the cursor on the line between the A and the B in the top of the column headers you will see it turn into a double-sided arrow (<-->). Double click when you see that and the column will autosize to the longest piece of data in that column. If you highlight the entire sheet before doing this it will autosize everything at once.

[phxJohn]

@3:36 Im glad you explained the "swooshes". I would have never guessed that you meant Serif. Arial and Calibri are both Sans Serifs (latin for "without Serifs").

[hughlee]

This video….when Homer Simpson sees that donut 🍩. That’s how I feel

[Jaywesterlow]

How do I enter the custom formula? I can't find the option on the current version of excel

[KaliTakumi]

Good video but the audio levels are all over the place

[judithcoleman]

Good content, but the volume level was not consistent...had to adjust to hear, several times.

[nomanarshad]

Dear, its really Amazing keep it up !

[seank]

*Happy New Year, This helped alot, i need one more help with, i got a google spreadsheet and list of names and email addresses, but in the list there are many names with out the emails, i want to sort one with emails to top and with out emails to bottom, or some way to organize it so i know im only looking at names with emails... can you help me how to do this?*

[peterdallyn]

I would never MERGE cells in Excel, even a title. Worked on so many tables of data that have been dummified by people merging cells.

[Evertbourgeois]

anywhere in a cell, press ctrl+T and it will do most automatically..

[folsterfarms]

1:21 "correct alignment" not "correct allignment" ARGH! and thank you for your helpful video =)