#computertutoring

How to Manage Notifications in Microsoft Teams? 

Office 365 User Training - Pick and Mix!

https://www.computertutoring.co.uk/online-training/power-bi-classes-online/#powerbiexamples

Power Automate Training

Live online and face to face training available.

If you've not heard of or used Microsoft Power Automate before, then think of it as a little assistant that can do pretty much anything within the Microsoft Office 365 environment. 

So what's covered?

      What is Power Automate?

    How to get Power Automate

    Finding your Way Around Microsoft Power Automate

    OneDrive and Power Automate

    SharePoint

    Using Excel with Power Automate

    Power Automate with MS Teams

    Outlook & Power Automate

    Creating basic flow:

    Receive a notification when an Excel Spreadsheet has been updated

    Automatically update a SharePoint document when you received an email

         Variables and when to use them in Microsoft Power Automate

    What are Compose Statements?

    Uploading  an Image as a SharePoint File

    Deleting Image Files

    Uploading an Image to a SharePoint List

    What is an Approval

    Manually Triggering

    Adding  Approval to a Flow

    Tracking the Approver Decisions

    Adding Conditional Logic

Spring is on its way.  We’ve had the snow and poetically appearing on the tails of the snow came the snow drops! Flowers and slighter longer days are what we all need to lift our spirits.

New starts often accompany the spring. To help Micro and Small Businesses make a new start with their accounts (please don’t tune out yet…accounts can be gloriously simple and very rewarding to keep on top of) Computer Tutoring have published a series of videos designed to help anyone setting up accounts for the first time.  Actually, if you already are in charge of keeping accounts and you want to give them a Spring Clean – then you’ll enjoy this Super Easy Accounts Series.

The Excel Accounts Template are available for download so you can follow along!

Questions that we are often asked about using Excel for Accounts include:

What the best way to do my own accounts?

How can I use Excel spreadsheets to do monthly accounts?

How do I work out my profit in Excel?

‘Super Easy Accounts’ is just that. No more glum weekends shrouded in accounts and VAT.

Keep in Simple – Keep it Smart!

How to do Super Easy Accounts in Excel?

Introduction to Basic Excel Terminology

How to Correctly Enter Dates in Excel?

Changing Numbers into Currency

How to Enter and Add up Expenses?

How to Enter and Add up Receipts?

How to Work out your Balance?

How to Work out a Running Total?

How to Make Your Accounts Look Good in Excel

Merge and Centre Cells

Change Background Colour

How to Change Font in Excel Sheet

Change Width in Excel for Multiple Columns

Drawing Lines in Excel

How to Freeze Panes in Excel

Excel Format Painter Multiple Cells

How to calculate the VAT in Excel?

How to work out how much VAT to charge

Work Out Gross from Net in Excel

Two more videos will be soon be published in this series. Check in or subscribe to our YouTube channel to be notified.  These will include how to incorporate your VAT into you accounts spreadsheet and how to start to analyze your accounts.

Have you ever tried training Photoshop, Outlook and Excel in the same day? Ever been on those three different courses in a day? Why would I be training these 3 very different programs?

Well, in a nutshell it was Edge Hotel School using up a training day they had already paid for. Anyway as promised in the Video here are the 5 top tips:

Using folders to organise message. For example you can create a to do folder.

Use rules to automate repetitive tasks.

Stop clogging up your inbox by using tasks. (Convert email to task tutorial).

Delay delivery of an email till a more appropriate time. (Free tutorial on how to schedule delivery of an email.)