A big thank you to Schrader Electronics Ltd for choosing us to deliver a bespoke PowerPivots with Excel course at their premises in Antrim this week. The course went very well and the feedback has been great!
http://www.mullantraining.com/PowerPivots_with_Excel_2010
Published by Sabina
MOS – Microsoft Office Specialist Certification is a qualification recognised worldwide, that demonstrates a high level of skill and knowledge in the following Microsoft applications:
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Outlook
- Microsoft Access
Whether you are looking for the ideal job, trying to advance in your present career, or pursuing academic goals, Microsoft Office Specialist gives you the tools to achieve more, distinguish yourself, and advance in today’s competitive academic and professional environments.
As an Authorised Microsoft Office Specialist Testing Centre, Mullan IT Training offer both Microsoft Office Specialist Courses and Exams.
For more information on dates and prices please contact us at: info@mullanittraining.com
For more information on MOS, visit the official MOS website: http://www.microsoft.com/learning/mcp/officespecialist/default.mspx
For information on Microsoft Office Specialist Certification requirements click on the – following link: http://www.microsoft.com/learning/mcp/officespecialist/requirements.mspx
Enquire About This Course
This 1 day Introduction to Adobe Photoshop CS5 CS6 CC course introduces participants to Adobe Photoshop.
Adobe Photoshop is a graphics program, mainly used for editing images or retouching photographs but can also be used to create original artwork either from scratch or based on an existing image.
PRERQUISITES
No experience of Adobe Photoshop is necessary.
BENEFITS
Delegates will learn how to use this professional photo editing tool to:
- Blend photos
- Add images together
- Create transparent images and layers
- Make web savvy images
- Remove or add parts of images easily
- Prepare images for print
COURSE CONTENT
WHAT IS PHOTOSHOP?
• Exploring the Menu Bar
• Introducing the Toolbox
• Understanding the Options Bar
• Using Palettes
• Customizing Photoshop
• Opening and Navigating Images
• Using Adobe Bridge
• Getting Help
• Using the History Palette
OVER VIEW OF SELECTION TOOLS
• Using the Marquee Tools
• Exploring the Lasso Tools
• Creating Selections Using the Magic Wand
• Using Colour Range to Create Selections
• Creating Selections Using Extractions
• Transforming a Selection
• Copying Pasting and Moving a Selection
UNDERSTANDING LAYERS
• Working with Layers
• Applying Layer Styles
• Fill and Adjustment Layers
• Exploring Layer Comps
• What are Masks?
• Using Layer Masks
• Merging and Flattening Layers
UNDERSTANDING COLOUR MODES
• Specifying Colour
• Understanding Colour Adjustment
• Using the Adjustment Tools
• Replacing Colour
• Introduction to the Drawing Tools
• Creating Paths
• Modifying Paths
• Introduction to the Painting Tools
• Using the Painting Tools
WORKING WITH TYPE
• Converting Type into a Shape or Path
• Exploring Type Effects
• Understanding Filters
• Previewing Filters
• Working with Filters
• Retouching Images
PREPARING TO PUBLISH
• Printing Basics
• Optimizing Images for the Web
• Using Save For Web and Devices
• Creating Image Slices
Click here to download:
Photoshop Intro
Enquire About This Course
For the past 20 years Mullan Training have been committed to providing high quality corporate IT Training in Belfast and throughout the province to the public and private sectors.
Our latest expansion marks a new chapter for our company and we are excited to showcase our new facilities to the business community and general public.
We are confident that our high specification training rooms will offer everything that our clients need to have an exceptional training experience.
- Opposite Europa
- Extra Training Rooms
- Delegate WiFi
- Course Booklets
- Lunch Provided
- Hi-Spec Facilities
We would like to thank Marcon Fit Out for Orchestrating and successfully executing this project.
The team at Mullan Training are “pleased to see the project successfully completed and hope everyone likes the facilities as much as we do.”
Counting with PivotTables
Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.
Suppose you have a data table set up in Excel that represents your club membership. In the first column are the names of club members. In the second column are the cities in which the members live. If you want to find out how many people live in each city, there are several methods you can choose. One method is to create a PivotTable.
To create a PivotTable on your data, follow these steps:
- Select a cell within your data table.
- Make sure the Insert tab of the ribbon is displayed.
- In the Tables group, click the PivotTable tool.
- Excel displays the Create PivotTable dialog box.
- In the Range box, make sure your entire data table is selected, then click on OK. Excel creates an empty PivotTable worksheet.
- Drag the City field from the field list to the Row Labels area.
- Drag the Name field from the field list to the Values area. Your PivotTable is complete.
Excel Courses at mullantraining.com
Enquire About This Course
Our 2 day Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Microsoft Excel 2007, Microsoft Excel 2010 and Microsoft Excel 2013 and who wish to progress to the most complicated functions and features.
Web Marketing Fundamentals Training course in Belfast, Tyrone, Armagh and Throughout NI
This course is designed for people involved in Digital Marketing and Business Management, and who want to use the internet to its full potential in relation to their business.
Duration: 1 Day
Course Objectives
- Understand the fundamentals of various Web marketing techniques
- Develop efficient online Web marketing plans
- Measure and evaluate the effectiveness of Web marketing
- Conduct Web search engine and directory promotions
- Exploit the potential of mass Web marketing using viral techniques
- Deploy highly personalised Web-based marketing
Course Content
Web Marketing Fundamentals
- Low Risks, Costs and More Benefits
- Broad Customer Base
- Push-Pull Strategy
- Powerful Branding
- Prospect Generation
- Building Trust
- Giving and Selling
- Reasons for Failure
Web Search Engine & Directory Marketing
- Robot Compiled Search Engines
- Human Compiled Directories
- Pay-Per-Click Search Engines
- Important International / Regional Search Engines & Directories
- Correct Web Site Promotion Procedures
Web Marketing Plans
- Strategic Planning
- Situation Analysis
- Customer Analysis
- Market and Product Focus
- Pricing Strategy
- Product Distribution
Viral Web Marketing
- Viral Internet Marketing – Rapid, Inexpensive, Harmless and Unobtrusive
- Viral Marketing Techniques
- Successful Viral Marketing Strategies
One-To-One Web Marketing
- Site Personalisation
- Building Web Site Community
- Targeted Advertisement Delivery
- Real-time Product Customising
- Online Customer Service and Sales
Measuring e-Marketing Success
- Measuring Hits
- Measuring User Sessions
- Measuring User Click-Paths
- Measuring Revenues
- Measuring Tools