Brendan Moran – Computer Training & IT Consultant

The purpose of this site is to help small to medium business navigate through the huge sea of information on computers. I try to give you more control over the computer side of your business and help with your internet strategy. Whether it is computer training or database development work, I can help you with your specific needs. I also offer a range of tips on Microsoft Word, Access, Excel, PowerPoint and WordPress etc for clients so please visit these sections. I am available as a Freelance Trainer. I am also an Adobe Certified Trainer specialising in Dreamweaver and Photoshop.



Brendan Moran

Excel File and Data Processing

I develop routines for organisations that can quickly process your data and files.

The raw data can come from:

  • Excel
  • SAP
  • Oracle
  • Other Database Systems

The data is then processed to produce the relevant data for your needs.

This data can then be used in:

  • Master Excel file
  • Multiple Excel files
  • Exported out to PDF, Excel or Word.

This is all macro driven using VBA.

Your monthly routines that might take days can be reduced to seconds !!!!!!


QuickBooks Online Accounting Software

I provide a wide range of consultancy and training services in relation to QuickBooks Online accounting including:

1. Setup

• Chart of Accounts
• Customisation
• Numbering
• Lists
• Users

2. Sales / Debtors / Customers Workflow Cycle

• Customisation
• Credit Notes and Refund Receipts
• Delayed Credits / Delayed Charges
• Online Invoices
• Audit History
• Transactions – Batch, Linked
• Invoice Activity
• Attachments
• Estimates / Quotes / Conversion to Invoices
• Draw Window
• Recurring Invoices
• Import / Export

3. Purchases / Expense Payments / Creditors / Suppliers Workflow Cycle

• Customisation
• Recurring Purchase Invoices
• Audit History
• Transactions – Batch, Linked
• Invoice Activity
• Attachments
• Import / Export

4. Banking

Read the rest of this entry »

Excel Dashboards

Excel Dashboards Training

Excel Dashboards are reports that allow senior management or directors to get high-level overview of the business or organisation.

Excel Dashboard

Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

You will learn how to explore and analyse your data by creating an interactive dashboard in Excel using pivot tables and Visual Basic for Applications. You can create a dynamic template to generate reports for Directors, Senior Management or customers and to better understand your own data. You will learn how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive. I will also shares some basic principles of visual design to guide you in developing an easy-to-use and visually appealing report.

Topics include:

  • Defining your requirements
  • Preparing Your Data
  • Setting up data
  • Adding reference tables
  • Designing Your Visual Layout
  • Creating hierarchy in the layout
  • Choosing colour and typography
  • Designing the Report
  • Importing data
  • Inserting slicers
  • Recording a macro
  • Advanced slicers
  • Editing VBA code
  • Improving the user experience

Virgin Media Broadband Speed Boost

virgin_mediaVirgin Media (formerly UPC) have upgraded their broadband download speed to 360 Mb in Jan 2016.

The upload speed is still around the 40 Mb mark.

Excel – Moving to Excel 2013 / Excel 2016

excel 2013 trainingMoving from Excel 2003 to Excel 2016 (or ( Excel 2007, Excel 2010 or Excel 2013 ) can be fraught with difficulty if not done correctly.

Where to find menu-to-ribbon reference guides, training, and other useful resources for Excel 2013 / Excel 2016 ?

Where to find things you might be looking for, such as the Tools | Options dialog box ?

How to customize the Excel 2013 / Excel 2106 ribbon and Quick Access Toolbar ?

How to exchange files with people who don’t yet have Excel 2013 or Excel 2016?

How to enable Solver or other Excel add-ins ?

Where to find commands for working with macros, form controls, and other advanced features ?

There can be a lot of incompatibilities and teething troubles with formula from earlier versions like vLookups.

I have a quick, visual introduction to the ribbon and other parts of the Excel 2013 / Excel 2016 interface.


Page 1 of 1212345...10...Last »