Microsoft Word 2016

Word – Templates, Styles and VBA Macros

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 …

View full post
Word – Templates, Styles and VBA Macros

Excel


I have used spread­sheets for over 25 years and I train peo­ple at all lev­els up to Microsoft Excel 2019, from Begin­ner to Advanced and VBA. My own back­ground is accoun­tancy and this gives me a unique financial view of Excel- click here

Access


I train peo­ple to all lev­els of Microsoft Access from Begin­ners to Advanced. I develop data­bases for clients. I spe­cialise in recov­er­ing data from cor­rupt Access databases. Train­ing can be one to one up to large groups. - click here

Word

I have been using Word Pro­cess­ing for over 25 years and I train peo­ple to all lev­els of Microsoft Word from Begin­ners to Advanced. Mail Merge from dif­fer­ent sources is a par­tic­u­lar spe­cial­ity of mine as is deal­ing with long documents - click here

Microsoft Outlook

Microsoft Out­look is the main E-Mail / Diary / Con­tacts / Meet­ings pack­age used in busi­ness. The main ver­sions used are Out­look 365, 2016 and 2019. I also spe­cialise in sync­ing your iPhone with Out­look and Exchange Server - click here

Brendan Moran – Computer Training & IT Consultant

Categories:

Computer Training, IT Consultancy

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

Tags: , ,

Word – Templates, Styles and VBA Macros

Categories:

Microsoft Training, Word, Word Processing

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

 

This post has no tag

Excel File and Data Processing

Categories:

Excel, Microsoft, Microsoft Training

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

 

This post has no tag

Excel Dashboards

Categories:

Computer Training, Excel, Microsoft Training

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

Tags: ,

Excel – Moving to Excel 2013 / Excel 2016

Categories:

Excel, Spreadsheets

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.

 

Tags:

Database Training – Microsoft Access 2010, 2013 and 2016

Categories:

Access, Computer Training, Database

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

Tags: , ,

Older posts «