Category Archives: Excel

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

Advertisements
Posted in Excel | Tagged | 2 Comments

How to create basic formulas in Excel


How to create basic formulas in Excel and understand the BODMAS rule – Order of operations. 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

How to capture dialog boxes using any Microsoft Office Software


Alt print screen to capture dialog boxes. 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

Do you still like your Classic View in Pivot Tables in Microsoft Excel?


Using Microsoft Excel you can change Pivot Table Classic View by going to Options/ Display un-tick classic Pivot Table Layout.
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

Making Lists using Excel. The Key is “Data Validation Lists”


Create pre populated lists in Excel for efficient data entry purposes. Continue reading

Posted in Excel | 1 Comment

Custom view greyed out in Microsoft Excel, how do I fix this problem?


How to fix custom view being greyed out in Excel. Could be you have sheets grouped or you have Format as table activated. Custom view greyed out and i have no tables. Copy paste problem sheet to a new workbook. 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

Hide a formula from being seen in the Formula bar of Microsoft Excel.


Even if you click in the formula bar, you do not want to disclose the formula. Continue reading

Posted in Excel | Leave a comment

Share Excel Files


use onedrive to share files. Changes are seen instantly. Continue reading

Posted in Excel | Leave a comment

How to create a simple Pivot Table in Microsoft Excel


Creating Microsoft Excel Pivot Tables isn’t as hard as you might think here is how, prepare you data correctly then go to the Insert tab and Select Pivot Table. Customized Face to Face computer courses available in Sydney – Australia. http://www.azsolutions.com.au Continue reading

Posted in Excel | Tagged | Leave a comment

How to remove duplicates in Excel


Removing duplicated data in excel is made easy with Remove Duplicate button found in the Data Tab. Continue reading

Posted in Excel | Leave a comment