Skip to content

Archive

Category: What’s New

If there is one single most important thing that you need to know in excel, that would be ‘Excel binary format‘.

When you save workbooks in binary format, your data will be compressed and the size will reduce drastically. This would prevent possible crashes due to file size. ( see figure 1)

Excel bynary format

 

 

 

 

 

 

Another notable feature is its compatibility, in case if you were to write & run some Macros in your workbook then the ‘binary’ format is your ideal option.

In fact, I did some comparison to prove it factually correct, the results are mind-blowing.

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

#ITCourses #NorthernIreland

What will you learn:

  • How Social Media works
  • The most appropriate Social Media channels for your business
  • A working knowledge of Facebook, Twitter, Instagram, LinkedIn and Pinterest
  • How to manage your social media profiles more efficiently
  • How to plan content in advance
  • How to report on the most meaningful Social Media results
  • How to kick-start your Social Media activity with an easy to action campaign
  • Click here for more detailed course content: https://www.mullantraining.com/Social_Media_Introduction_Course_in_Belfast_Northern_Ireland_
  • Call, Email or Chat Live with an Account Manager now:

T: +442890322228

E: info@mullantraining.com

W: www.mullantraining.com

Social-Media Images

 

 

 

 

 

 

 

 

 

 

 

 

 

• COURSE CONTENT
• Excel Objects
• Variables
• Using Visual Basic Functions
• Building Formulae Control Structures
• Event Handling
• Running Code
• Storing Information…
• Follow link for detailed course content: https://www.mullantraining.com/Excel_VBA_-_Adv
• Price: £ 225+ 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

vba-macro-training

• Prerequisites
A very good looking knowledge in SQL, or our introduction SQL Language course
• Click here for more detailed course content: https://www.mullantraining.com/Microsoft_SQL_Query_Language…
• Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

1433419835

 

 

 

• This course takes Pivot Tables to the next level. You will learn how to use PowerPivot to access data sources, create relationships, PowerPivot DAX Expressions and Format reports; enabling deeper business insight and shorter decision making cycles.
• Follow link for detailed course content: https://www.mullantraining.com/PowerPivots_-_Level_1
• Price: £ 215 + 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

 

 

PowerPivot Relationships

F2 Key:

Using “F2” Key, you edit the contents of a cell in excel. If you select a cell that is filled with some value and then press “F2” Key, then it will allow you to insert at the end of the current content in the cell. However, if you press “F2” for an empty cell then it simply allows you to type in the empty cell.

If editing directly in cells is disabled in your workbook, then by pressing “F2” you can edit the contents in Formula Bar. In case you are unaware that if direct editing is disabled or not then just follow below steps:

  • Click on “File Menu”.
  • Select “Options” and then select “Advanced”.
  • In the “Advanced Option” for Excel, verify if the check-box against “Allow editing directly in cells” is ticked or not as shown in below image.

F2 Key

 

 

 

 

 

 

 

 

 

 

 

 

Alt + F2:

By holding “Alt + F2” keys together the “Save As” dialog box opens for saving the excel workbook. 

Ctrl + F2:
To open Print options you can just hold “Ctrl + F2” keys together. It opens the same printing options as shown in below image which could also be opened by clicking on “File menu” and then by selecting “Print Option”.

F2 Key.png 1

 

 

 

 

 

 

 

 

 

 

 

 

 

Shift + F2:
Insert comments in a cell by just holding “Shift and F2” Keys together. You can also edit the existing comments in the selected cell using “Shift + F2” keys.

Alt + Shift + F2:
This set of keys “Alt + Shift + F2” when pressed together save the workbook. It is same as “Ctrl + S” keys.

Ctrl + Shift + F2:
“Ctrl + Shift + F2” Keys don’t provide any output.

Alt + Ctrl + F2:
This set of keys “Alt + Ctrl + F2”, when pressed together, opens the “File Open Dialog Box”. It is same as “Ctrl + O” function.

Alt + Ctrl + Shift + F2:
“Alt + Ctrl + Shift + F2” keys open the print option in excel, same as “Ctrl + F2” keys.

 

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

  • This 2-day course is suitable for advanced users of Microsoft Access 2010, Microsoft Access 2013 or Microsoft 365; responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.
  • Click here for more detailed course content: https://www.mullantraining.com/Access_VBA
  • Call, Email or Chat Live with an Account Manager now:
  • T: +442890322228
  • E: info@mullantraining.com
  • W: www.mullantraining.com

Access-VBA-with-logo

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • The goal of this course is to provide you with the knowledge to use the more advanced tools of Microsoft SharePoint Online where Edit permissions or higher are required. Users of this level are commonly referred to as “Power Users” or “Super-Users” and are often empowered with some responsibilities associated with “Site Owners”. The course emphasizes hands-on experience, with a series of self-guided exercises integrated into the training.  It does not cover the installation and initial set up of SharePoint.
  • Follow link for detailed course content: https://www.mullantraining.com/SharePoint_
    • Price: £ 215 + 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

Sharepoint-Logo-Puzzle-Feature_1290x688_KL

  • 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

Cravatte

• 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.
• Click here for more detailed course content: https://www.mullantraining.com/Sage_Accounts_-_Report_Writi…
• Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

cust-soft-banner