Author Archives: Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au

Setting “Sections” in a PowerPoint Presentation


Sections in PowerPoint are great when multiple people share responsibility for the construction of the presentation. Sections are found under the Home Tab. Continue reading

Advertisements
Posted in Power Point | Leave a comment

Confused where to start?


How to get help when setting up a new computer. What do you need? What will you be using it for? These questions and more answered. http://www.azsolutions.com.au Continue reading

Posted in Excel | Tagged | Leave a comment

Using Microsoft Excel to Split Data into Separate Cells


In Microsoft Excel you can split data by using going to the Data tab then select Text to Column, Select Delimited by eg: Commas try “Do Not import columns (skip)”. 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 | Leave a comment

Name Sheets in Excel


To name sheets using Microsoft Excel you will need to Double click on the name of the sheet or Right Mouse Click and Select Rename Sheet. 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 | Leave a comment

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

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 | Tagged , , , | Leave a comment

Windows Calculator more than the Standard


Click the 3 bars on the Windows Calculator to see the Scientific Calculator, Volume, Length, Weight, Currency and more. Offering Customized Computer Training Courses in Sydney – Australia “We come to you”.

Servicing Our Customers since 1999 – Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.

Free Tutorials | YouTube Channel – Analir Pisani

Visit website reviews Continue reading

Posted in Windows operating systems | Tagged | 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 | Tagged , , , , , | Leave a comment