EasyPC Training in Gladstone, Queensland | Specialty School

EasyPC Training

Locality: Gladstone, Queensland

Phone: +61 1300 631 040

Address: 8/72 Goondoon Street 4680 Gladstone, QLD, Australia

Website: http://www.easypctraining.com.au/

Likes: 379

Add/Update information

Reviews

Tags

• Specialty School
• Computer training school

23.01.2022 Learn how to apply and modify styles to quickly and easily format your document.

22.01.2022 Shortcut of the week... Microsoft Office (all applications) Ctrl + N - Opens a new item:... Excel: new workbook Word: new document Project: new project file Outlook: new email/contact/appointment/note (depending on which area of Outlook you are in) PowerPoint: new presentation Visio: new drawing (same drawing type as current)

21.01.2022 Automated Invoice Reminders in Xero Set automated invoice reminders to get that cash in quicker... Organisation Settings > Invoice Settings > Invoice Reminders... You can set a number of reminders to go out a specified number of days before or after an invoice due date.

19.01.2022 Shortcut of the Week... Microsoft Windows Windows key + Left arrow or right arrow key.... Snaps a Window to the Left or Right half of the screen.

19.01.2022 Xero Global Release Update: February 2020 https://www.xero.com//xero-global-release-update-february/

18.01.2022 Shortcut of the week... Microsoft Excel Ctrl + Shift + End... Selects from the active cell down to the bottom right corner of your data range

15.01.2022 Have you see the new 3D-Models in Microsoft Office? (Excel, Word, PowerPoint and Outlook) Very cool 3D models, allowing you to see objects from all angles! Found on the Insert tab on the ribbon.

14.01.2022 Uploading and Attaching Files in Xero Did you know that you have a dedicated email address in your Xero software to upload files to? 1. Click on your Company name (top left corner)... 2. Select 'Files' You will see the email address in the top right corner. Save that as a contact in your Outlook / phone contacts or photocopier machine and quickly send files to Xero. You can also take pictures on your phone and share to Xero Files if you install the Xero Accounting app on your phone first. Easy! Once you have uploaded the files, you can save them into custom folders or attach them to your transactions including: spend money, receive money, invoices and bills.

13.01.2022 Using Sparklines in Microsoft Excel... Sparklines are used to show trends in data, like a mini chart, either as a line, column or win/loss. 1. Select your data... 2. Go to Insert tab 3. Select Line, Column or Win/Loss from the Sparklines group 4. Select which cell(s) you want to display the sparkline See more

12.01.2022 Friday Funny... Have a great weekend :0)

08.01.2022 Square, Xero enhance integration and point-of-sale features https://www.xero.com//square-xero-enhance-integration-and-

07.01.2022 Friday Funny...

07.01.2022 Xero Product Release Updates Feb 2020 https://www.xero.com//xero-global-release-update-march-20/

06.01.2022 Learn to navigate the Shapes task pane, search for built-in shape stencils and search for specific shapes using the search shapes box. Access the full Microsoft Visio Essentials course at https://www.udemy.com/cou/microsoft-visio-2016-essentials/

05.01.2022 Learn how to connect shapes in Microsoft Visio using a Dynamic Connector. Access the full Microsoft Visio Essentials course at https://www.udemy.com/cou/microsoft-visio-2016-essentials/

04.01.2022 Shortcut of the week... Microsoft Excel Alt + ;... Selects only the cells that are currently visible. If you have hidden rows or columns, applied filters/subtotals etc, this shortcut will only select what you see. 1. Select the cells / worksheet that you want to copy 2. Use Alt + ; then copy the data 3. Paste the data in another cell/worksheet It will NOT paste the hidden data.

03.01.2022 Friday Funny... Have a great weekend folks!

02.01.2022 Learn how to apply condtional formatting to highlight specific data on your worksheet, based on logical rules.

01.01.2022 Using the new IFS function (Microsoft Excel 2016 onwards) The new IFS function replaces the need to nest multiple IF functions. For example: =IF(A1>90,"Grade A",IF(A1>80,"GRADE B",IF(A1>70,"Grade C","Grade D")))... can now be written: =IFS(A2>90,"Grade A",A2>80,"GRADE B",A2>70,"Grade C",TRUE,"Grade D") where TRUE denotes the default value.

01.01.2022 Learn how to sort your data alphabetically and by cell colour

01.01.2022 Create a Map Chart in Excel How cool is this...?! Simply enter country/city/state names in your worksheet, select the names, then go to Data tab > Geography. Then click on the Insert Data icon next to your selected data and choose the data type you would like to populate (e.g. Population, Capital City).... Then go to Insert tab > Map Chart and voila...! See more