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

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.

 

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

Word Processing – Microsoft Word 2010, 2013 and 2016

Microsoft Word 2013Among the main areas that I train for Word 2010, Word 2013 and Word 2016 include the following:

  • Cus­tom­ising Word
  • Cre­at­ing and sav­ing documents
  • Set­ting up templates
  • Edit­ing Documents
  • Deal­ing with paragraphs
  • Pages, Sec­tions, Head­ers and Footers
  • Doc­u­ment Tools
  • Mail Merge
  • Auto­Text and AutoCorrect
  • Tam­ing the Rib­bon in Word 2007 / Word 2010, Word 2013 and Word 2016
  • Using XML for Customised Menus and  and Template Development
  • Deal­ing With Long Documents
Page 1 of 1212345...10...Last »