Category Archives: Excel

Create names to use in Microsoft Excel Functions


In Microsoft Excel you can create names to use instead or cell ranges. Select a range of cells, Click in the Name Box and type a name without any spaces. =sum(totals).I’m offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.
Visit website reviews Continue reading

Advertisements
Posted in Excel | Leave a comment

Filtering data using Microsoft Excel


Use Filters in Excel to refine the data you would like to look at. Use Format as Table to give you Freeze Pane and many more useful features. Continue reading

Posted in Excel | Tagged , , , , , | Leave a comment

Modifying a Range Name in Microsoft Excel


In Microsoft Excel you can create names for cells and then use them in Excel Functions or Formulas. To do this go to the Formulas Tab and Select the Name Manager. I’m offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.
Visit website reviews Continue reading

Posted in Excel | Tagged | Leave a comment

Separating data in Microsoft Excel


In Microsoft Excel versions 2013 and newer you can Extract a part of what you need from one Cell by using Auto Fill Smart Tag then select Flash Fill. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews Continue reading

Posted in Excel | Leave a comment

What is Flash Fill in Excel?


When you want to pull apart text from a cell use Flash Fill as an alternative to Text to Column . Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews Continue reading

Posted in Excel | Leave a comment

New Icons for Office 365


Insert icons, change the colour and covert to Shape. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews Continue reading

Posted in Excel, Power Point, Word | Tagged | 1 Comment

How to show all Formulas in Excel


To reveal all formulas in Excel Press Ctrl ~. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews
Continue reading

Posted in Excel | 1 Comment

Basic Functions using Microsoft Excel


All functions follow a structure, they begin with = followed by the function name and a set of brackets. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews
Continue reading

Posted in Excel | 1 Comment

The Shortcut Key for AutoSum in Microsoft Excel


The shortcut key for AutoSum in Excel is Alt =. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews
Continue reading

Posted in Excel | Leave a comment

Naming cells in Microsoft Excel


Naming cells in Microsoft Excel is such a time saver and makes reading functions easier to understand. If you need further assistance. Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.
Visit website reviews Continue reading

Posted in Excel | Tagged | 2 Comments