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.

access_2010awordpress_a

pscs5_a

Brendan Moran

Word – Templates, Styles and VBA Macros

Microsoft Word 2016

I have setup numerous Word systems for clients including:

  • Full automatic implementation of house style guide
  • Multiple Word Templates
  • Full Word Menu Customisation
  • VBA / Macro driven routines and menus
  • Forms to collect and automatically populate Word templates
  • Automation of bookmarks, signatories and attachments
  • VBA Macro driven printing routines
  • Customised Ribbons
  • Implemented Shortcut keys
  • Attached Styles to customised menus
  • Attached VBA Table of Contents TOC and Schedules to menus allowing instant creation of advanced Word features
  • Full customisation of normal.dotm using VBA and XML

Call now for a Free Consultation on your specific Microsoft Word needs – 086 859 6701

 

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 !!!!!!

 

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

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.

 

Database Training – Microsoft Access 2010, 2013 and 2016

Access 2013Among the top­ics that I cover in my Microsoft Access 2010 / Access 2013 / Access 2016 training are the following:

  • Rela­tional Databases
  • Nor­m­al­ised Tables
  • Tables
  • Quer­ies
  • Forms and sub forms
  • Reports and sub reports
  • Mac­ros
  • VBA Pro­gram­ming for Access
  • Secur­ity
  • Net­work­ing Front End and Back End Data
  • Recover Data from cor­rupt Access Databases
  • JAWS com­pat­ible data­bases for com­puter users whose vis­ion loss pre­vents them from see­ing screen content

Older posts «