Excel and More

03/14/2021

Learn more about excel!

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

02/16/2021

Start 2021 with a new 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.  

05/23/2020

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

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

05/18/2020

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

05/09/2020

Learn how to set up your first online store!

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

04/24/2020

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

04/12/2020

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

03/25/2020

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.

03/03/2020

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.

02/05/2020

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

01/12/2020

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.

12/23/2019

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.