Skip to content

Archive

Category: What’s New

•This course is suitable for existing users of Sage who require an in-depth knowledge of customizing existing and using new reports. Knowledge of Sage 50 Accounts is essential.

•Price: £215 + VAT

• Click here for more detailed course content: https://www.mullantraining.com/Sage_Accounts_-_Report_Writing

• Call, Email or Chat Live with an Account Manager now:

T: +442890322228

E: info@mullantraining.com

W: www.mullantraining.com

vector_285_14-01-512

 

 

 

 

 

 

 

 

 

 

 

 

 

 

PREREQUISITES: Some knowledge of bookkeeping is desirable. A working knowledge of Basic IT is required. No experience of SAGE 50 Accounts is required.
• Price: £195 + VAT
• Click here for more detailed course: https://www.mullantraining.com/Getting_Started_with_Sage_50_Accounts_-_Level_1
• Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com
Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart

web-programming-e1444157758517-820x400

 

 

 

 

 

 

 

 

 

PREREQUISITES: You should have a good working knowledge of Excel, and familiarity with Excel Functions like SUMIF and VLOOKUP. People with Database, Programming or other BI experience will be qualified for the course even if they don`t have Excel experience.

SUMMARY: This 2-day course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards. We also cover the use of DAX in Excel and how that can feed data to Power BI and be combined in Dashboards and Visualisations.

  • Price: £390 + VAT
  • Click here for more detailed course: https://www.mullantraining.com/Microsoft_Power_BI_
  • Call, Email or Chat Live with an Account Manager now:
    T: +442890322228
    E: info@mullantraining.com
    W: www.mullantraining.com
    Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
    Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
    • Up To 10 Laptops
    • LCD Projector
    • Projector Screen & Flipchart

image_thumb897

 

 

 

 

 

 

 

 

 

 

Our 1 day Microsoft PowerPoint Advanced course is suitable for those with a working knowledge of PowerPoint Microsoft versions 2010 / 2013 and Microsoft PowerPoint version 2016 / 365.

PREREQUISITES:

A good, basic understanding of PowerPoint or completion of our Introduction to MS PowerPoint course.

Click here for more detailed course content: https://www.mullantraining.com/Powerpoint_-_Adv

Call, Email or Chat Live with an Account Manager now:

T: +442890322228

E: info@mullantraining.com

W: www.mullantraining.com

Good image

 

 

 

 

 

 

 

 

 

 

 

 

Prerequisites:

Delegates must be familiar with the operation of a Sage Payroll. Completion of our Sage Payroll Level 1 Course is recommended.

Click here for more detailed course content: https://www.mullantraining.com/Sage_Payroll_-_Adv

Call, Email or Chat Live with an Account Manager now:

T: +442890322228

E: info@mullantraining.com

W: www.mullantraining.com

Accounting software concept image with technology icons and copyspace

 

 

 

 

 

 

 

 

 

 

 

 

 

The goal of this SQL training course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™.
Course Prerequisites
Before attending this course, delegates are expected to have:
Experience using a Microsoft Windows operating system.
An understanding of basic relational database concepts.
• Follow the link for detailed course content:
https://www.mullantraining.com/Transact_SQL_Query_Language
• Price: £ 330 + VAT
• Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com
Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart

1433419835

 

 

 

 

 

 

 

 

 

 

 

 

 

 

There is no doubt, we use excel filters every day. But, I bet 9 out of 10 will not know quick filter technique.

With the help of quick filter technique, you can filter values from your active cell with the help of right-clicking. You can refer below example on how to filter ‘Central’ region by using right-click.(see image1)

quick filter technique

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For more Tips & Tricks follow the link: https://plus.google.com/b/115305456689183…/collection/YeJ9ME
Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart
Click here for more info: https://www.mullantraining.com/
Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

#ITCourse #NorthernIreland

• Outlook Advanced 2010 / 2013 is for people experienced with email who need to share information, or organize other people.
• Prerequisites: Participants should be competent users of Outlook 2013 and should already be able to:
• Send and read mail messages
• Use the calendar to set appointments and meetings
• Add contact information, tasks, journal entries and notes

• Follow the link for detailed course content: https://www.mullantraining.com/Outlook_Advanced
• Price: £ 160 + VAT
• Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com
Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart

Outlook

 

 

 

 

 

 

 

 

 

 

It’s quite evident that we often write lengthy excel formulas to execute complex logic’s, but as you know it’s very hard to debug in case if you have any errors.

So, the best and easiest way is to break down formulas by each logic by using Alt+Enter in the formula bar. With the help of below example, you can see yourself the benefits breaking formulas.

One of our Commission calculation formulae will look like below before and after using this technique: (see figure 1)

Breakdown lengthy formulas

 

 

 

 

 

 

 

 

I guess by this time you would have understood the relevance of using formula breakdown method.

For a full content or more Tips & Tricks follow the link: https://plus.google.com/collection/YeJ9ME

Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart
Click here for more info: https://www.mullantraining.com/
Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

#ITCourse #NorthernIreland