Excel and More

Learn more about excel!

Gantt Chart Auto Fill By Matt Smart Simple Gantt Chart with Auto fill for ChartGet this Gantt Chart at http://www.exceltemplates.us/

Start 2021 with a new estimating workbook.

2021 Estimating Workbook Get this updated Excel Workbook that you can price out you project. Fill in the Labor, Equipment, Material list and any Sub trades you have. Then start estimating.  

Set up a online store to sell you digital products.
Here is a video to help you get started!

https://youtu.be/cy-4_-nKSXQ

Sellfy Product This video show you how to set up you one digital products on Sellfy.

What is the next step after you create your eCommerce store. Help get additional Customer loyalty by setting up a points program.

https://www.exceltemplates.us/smile-io

Learn how to set up your first online store!

https://www.exceltemplates.us/set-up-online-store

Learn how to sell your digital products online. 7 years ago our first online store was created using Sellfy.

Do you create music, enjoy photography, write books, create work out video's, have a favorite food recipe to share! These are just a few of of the many idea's you may sell on Sellfy

https://www.exceltemplates.us/sellfy-review

Do you need help bidding residential electrical projects. Well go no further!

One of the ways to save a bit of time when putting in data into you excel sheet is using the drag down function of excel.

This can be used to: copy, fill in a series, fill in formatting, and fill in with out formatting.

This can be completed by simply moving you courser over the right small squire dot in the right bottom of the cell. Right or left clicking then dragging down to the number of cells provided.

Click on the formatting square that pop up and you can choose one of the functions you choose.

This is a handy tool that I use all the time. Named Ranges are super helpful. We can use the named ranges to find data very quickly and use them in different formulas. In the below example the vlookup formula is used to use to find the name of the person by the persons number. To make a named range just simply select the range of cells, then in the Name box put in the name of the range you would like to use.

I hope everyone is having a this week.

Here is a great tip to help you save time, a lot of time.

Saving your excel files while you work if excel crashes it a big deal. Make it happen so you don't loose out on hours of work.

Ctrl+S - Save while you work

Auto save - Open your setting (Options) and go to the save tab. Make sure you have AutoRecover set up and how often you would like to save. Every 3 minutes is a good place to start.

Happy

Hey everyone Happy New Years!

I was thinking about what would be a great tip to start the year off!

There are 2 formulas the I us together all the time. They are used when you want to separate numbers or words.

Find(find_text,within_text,[start_num])
mid(text,start_num,num_char)

In the example below we want to get the staff number from the middle of the cell.

Dates are important! In excel there are a few ways to use a few formulas to help you get the most out of your dates.

TODAY - Gives you today's date
MONTH - Gives you the current month
DAY - Gives you the current day
YEAR - Gives you the current year

These are great to use to filter data.