Notice: The called constructor method for WP_Widget in collapsCatWidget is deprecated since version 4.3.0! Use
__construct()
instead. in /var/www/vhosts/121/242034/webspace/siteapps/WordPress-56954/htdocs/wp-includes/functions.php on line 4718
Brendan Moran - IT Consultant and IT Trainer, Wicklow, Ireland

Brendan Moran — Computer Training & IT Consultant

The pur­pose of this site is to help small to medi­um busi­ness nav­i­gate through the huge sea of infor­ma­tion on com­put­ers. I try to give you more con­trol over the com­put­er side of your busi­ness and help with your inter­net strat­e­gy. Whether it is com­put­er train­ing or data­base devel­op­ment work, I can help you with your spe­cif­ic needs. I also offer a range of tips on Microsoft Word, Access, Excel, Pow­er­Point and Word­Press etc for clients so please vis­it these sec­tions. I am avail­able as a Free­lance Train­er. I am also an Adobe Cer­ti­fied Train­er spe­cial­is­ing in Dreamweaver and Pho­to­shop.

access_2010awordpress_a

pscs5_a

Bren­dan Moran

Word — Templates, Styles and VBA Macros

Microsoft Word 2016

I have set­up numer­ous Word sys­tems for clients includ­ing:

  • Full auto­mat­ic imple­men­ta­tion of house style guide
  • Mul­ti­ple Word Tem­plates
  • Full Word Menu Cus­tomi­sa­tion
  • VBA / Macro dri­ven rou­tines and menus
  • Forms to col­lect and auto­mat­i­cal­ly pop­u­late Word tem­plates
  • Automa­tion of book­marks, sig­na­to­ries and attach­ments
  • VBA Macro dri­ven print­ing rou­tines
  • Cus­tomised Rib­bons
  • Imple­ment­ed Short­cut keys
  • Attached Styles to cus­tomised menus
  • Attached VBA Table of Con­tents TOC and Sched­ules to menus allow­ing instant cre­ation of advanced Word fea­tures
  • Full cus­tomi­sa­tion of normal.dotm using VBA and XML

Call now for a Free Con­sul­ta­tion on your spe­cif­ic Microsoft Word needs — 086 859 6701

 

Excel File and Data Processing

I devel­op rou­tines for organ­i­sa­tions that can quick­ly process your data and files.

The raw data can come from:

  • Excel
  • SAP
  • Ora­cle
  • Oth­er Data­base Sys­tems

The data is then processed to pro­duce the rel­e­vant data for your needs.

This data can then be used in:

  • Mas­ter Excel file
  • Mul­ti­ple Excel files
  • Export­ed out to PDF, Excel or Word.

This is all macro dri­ven using VBA.

Your month­ly rou­tines that might take days can be reduced to sec­onds !!!!!!

 

QuickBooks Online Accounting Software

I pro­vide a wide range of con­sul­tan­cy and train­ing ser­vices in rela­tion to Quick­Books Online account­ing includ­ing:

1. Setup

• Chart of Accounts
• Cus­tomi­sa­tion
• Num­ber­ing
• Lists
• Users

2. Sales / Debtors / Customers Workflow Cycle

• Cus­tomi­sa­tion
• Cred­it Notes and Refund Receipts
• Delayed Cred­its / Delayed Charges
• Online Invoic­es
• Audit His­to­ry
• Trans­ac­tions – Batch, Linked
• Invoice Activ­i­ty
• Attach­ments
• Esti­mates / Quotes / Con­ver­sion to Invoic­es
• Draw Win­dow
• Recur­ring Invoic­es
• Import / Export

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

• Cus­tomi­sa­tion
• Recur­ring Pur­chase Invoic­es
• Audit His­to­ry
• Trans­ac­tions – Batch, Linked
• Invoice Activ­i­ty
• Attach­ments
• Import / Export

4. Banking

Read the rest of this entry »

Excel Dashboards

Excel Dash­boards Train­ing

Excel Dash­boards are reports that allow senior man­age­ment or direc­tors to get high-lev­el overview of the busi­ness or organ­i­sa­tion.

Excel Dashboard

Excel is an excel­lent tool to make pow­er­ful dash­boards that can pro­vide analy­sis, insight and alert man­agers in time­ly man­ner.

You will learn how to explore and analyse your data by cre­at­ing an inter­ac­tive dash­board in Excel using piv­ot tables and Visu­al Basic for Appli­ca­tions. You can cre­ate a dynam­ic tem­plate to gen­er­ate reports for Direc­tors, Senior Man­age­ment or cus­tomers and to bet­ter under­stand your own data. You will learn how to import exter­nal data, design a tem­plate using piv­ot tables, and add slicers, macros, and action but­tons to make the tem­plate more inter­ac­tive. I will also shares some basic prin­ci­ples of visu­al design to guide you in devel­op­ing an easy-to-use and visu­al­ly appeal­ing report.

Top­ics include:

  • Defin­ing your require­ments
  • Prepar­ing Your Data
  • Set­ting up data
  • Adding ref­er­ence tables
  • Design­ing Your Visu­al Lay­out
  • Cre­at­ing hier­ar­chy in the lay­out
  • Choos­ing colour and typog­ra­phy
  • Design­ing the Report
  • Import­ing data
  • Insert­ing slicers
  • Record­ing a macro
  • Advanced slicers
  • Edit­ing VBA code
  • Improv­ing the user expe­ri­ence

Excel — Moving to Excel 2013 / Excel 2016

excel 2013 trainingMov­ing from Excel 2003 to Excel 2016 (or ( Excel 2007, Excel 2010 or Excel 2013 ) can be fraught with dif­fi­cul­ty if not done cor­rect­ly.

Where to find menu-to-rib­bon ref­er­ence guides, train­ing, and oth­er use­ful resources for Excel 2013 / Excel 2016 ?

Where to find things you might be look­ing for, such as the Tools | Options dia­log box ?

How to cus­tomize the Excel 2013 / Excel 2106 rib­bon and Quick Access Tool­bar ?

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

How to enable Solver or oth­er Excel add-ins ?

Where to find com­mands for work­ing with macros, form con­trols, and oth­er advanced fea­tures ?

There can be a lot of incom­pat­i­bil­i­ties and teething trou­bles with for­mu­la from ear­li­er ver­sions like vLookups.

I have a quick, visu­al intro­duc­tion to the rib­bon and oth­er parts of the Excel 2013 / Excel 2016 inter­face.