Category Archives: Excel

Most Common Mac Shortcut Keys


Apple T is = F4 on a PC key stroke for Applying Absolute Cell Referencing when using Microsoft Excel. Mac Shortcut keys. Continue reading

Advertisements
Posted in Excel | Tagged | Leave a comment

How To Name Microsoft Excel Sheets


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.
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)”. Computer Courses available in Sydney – Australia.
http://www.azsolutions.com.au
Continue reading

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

How To Create A Vlookup Function In Excel


Use the Vlookup function in Excel to return data from a table. Type an Invoice no watch the description and amount get entered for you.
Face to Face Excel Training Courses available in Sydney – Australia
http://www.azsolutions.com.au Continue reading

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

Are You New To The Computer World. Confused Where Do I 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

How To Create Basic Formulas In Microsoft 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 , , | Leave a comment

Apply Multiple Formatting Using Format Painter Found In Microsoft Excel, PowerPoint, Word and Outlook


Need to apply the same formatting multiple times, use the Format Painter by clicking it twice not once.Press Esc to cance.
Computer Training Courses available in Sydney Australia.
http://www.azsolutions.com.au Continue reading

Posted in Excel, Outlook, Power Point, Word | Tagged , | Leave a 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 | Tagged , , | Leave a comment

Free Excel 60 Min Virtual Classroom


Virtual Classroom for Microsoft Excel using Google Hangouts. All you need is a Google account (gmail). Continue reading

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

Pay my bill


A freaky thing happened to me today I was watching sunrise and they were talking about fairy Bill away for people to give you a gift in the form of paying off one of your bills so I thought id … Continue reading

Posted in Excel | Leave a comment