UK training courses contact:
telephone: 01382 453447
email: mail@ictwizard.com

ICT Wizard

 

Frequently Asked Questions

See our disclaimer regarding the use of this site and links to other websites.

Q: what are the benefits of Office 2010?
A: Click the following to see the top ten benefits for each application:

 

Top 10 benefits of Word 2010

Microsoft Word 2010 offers the best of all worlds: enhanced features to create professional-quality documents, easier ways to work together with people, and almost-anywhere access to your files.
Designed to give you the finest document-formatting tools, Word 2010 helps you organize and write your documents more efficiently. In addition, you can save documents online and access, edit, and share them from almost any Web browser.1 Your documents stay within reach so you can capture your best ideas whenever and wherever they occur.

1
Discover an improved search and navigation experience. Locating the information you need is faster and easier in Word 2010. With the new and improved Find experience, you can now view a summary of search results in a single pane, and click to access any individual result. The improved Navigation Pane provides you a visual outline of your document so you can browse, sort, and find what you need quickly.


2
Work with others without having to wait your turn.Word 2010 redefines the way people can work together on a document. With co-authoring, you can edit papers and share ideas with others at the same time.1 You can also view the availability of others who are authoring a document with you and can easily initiate a conversation without leaving Word.2


3
Access and share your documents from virtually anywhere. Post your documents online and then access, view, and edit them from almost any computer or your Windows phone.3 With Word 2010, you can take advantage of a best-in-class document experience across multiple locations and devices.
Microsoft Word Web App. Edit documents in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.1

Microsoft Word Mobile 2010. Stay current and take immediate action using an enhanced mobile version of Word specifically suited to your smartphone.3


4
Add visual effects to your text. With Word 2010, you can apply formatting effects such as shadow, bevel, glow, and reflection to your document text as easily as applying bold or underline. You can spell-check text that uses visual effects, and add text effects to paragraph styles. Many of the same effects used for images are now available to both text and shapes, enabling you to seamlessly coordinate all of your content.


5
Turn your text into compelling diagrams. Word 2010 offers you more options to add visual impact to your documents. Choose from dozens of additional SmartArt® Graphics to build impressive diagrams just by typing a bulleted list. Use SmartArt to transform basic, bullet-point text into compelling visuals that better illustrate your ideas.


6
Add visual impact to your document.New picture-editing tools in Word 2010 enable you to add special picture effects without additional photo-editing software. You can easily adjust pictures with color saturation and temperature controls. You also get improved tools for easier and more precise cropping and image correction, to help you turn a simple document into a work of art.


7
Recover work you thought was lost.
After working on that document for awhile, did you accidentally close it without saving? No problem. Word 2010 lets you recover draft versions of recently edited files as easily as opening any file, even if you never saved the document.


8
Transcend communication barriers. Word 2010 helps you work and communicate effectively across different languages.4 Translate a word, phrase, or document more easily than before. Set separate language settings for ScreenTips, Help content, and displays. And, get additional assistance for English as a second language with English text-to-speech playback.


9
Insert screenshots and handwriting into your documents.Capture and insert screenshots directly from Word 2010 to quickly and easily incorporate visual illustrations into your work. When you use a tablet-enabled device such as a Tablet PC or Wacom tablet, you get improved tools for formatting ink as easily as you format shapes.


10
Accomplish more with an enhanced user experience. Word 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your documents with just a few clicks. With the improved Ribbon, you can access your favourite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.

Top 10 benefits of Excel 2010

Microsoft Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions. New data analysis and visualization tools help you track and highlight important data trends. Easily upload your files to the Web and work simultaneously with others online. Access your important data on the go from almost any Web browser.
Whether you’re producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.

1
Create data charts in a single cell. With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It’s a quick and easy way to highlight important data trends such as seasonal increases or decreases, saving you time.


2
Zero in on the right data points quickly. Excel 2010 delivers a new and exciting filter enhancement for your PivotTables. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display precisely what you need. With the new search filter, you can spend less time sifting through large data sets in your tables and PivotTable views, and more time analyzing.


3
Efficiently model and analyze almost any data. The PowerPivot for Excel add-in, a free download, provides groundbreaking technology such as streamlined integration of data from multiple sources and lightning-fast manipulation of large data sets with up to millions of rows. Business users can effortlessly publish and share analysis through Microsoft SharePoint Server 2010, and have other users enjoy the same Slicer, PivotTable, and fast-query capabilities when working on their Excel Services report.1


4
Access your spreadsheets from virtually anywhere. Post your spreadsheets online and then access, view, and edit wherever from just about any computer or your Windows phone.2 With Excel 2010, you can take advantage of a best-in-class spreadsheet experience across multiple locations and devices.
Microsoft Excel Web App. Edit workbooks in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.2

Microsoft Excel Mobile 2010. Stay current and take immediate action when necessary using the mobile version of Excel specifically suited to your smartphone.3


5
Connect, share, and accomplish more when working together. Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations.2 See changes from others appear as they are made and with the number of editors in the workbook shown on the status bar, you’ll always know who else is editing the workbook with you.


6
Add more sophistication to your data presentations.Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You also can display data bars for negative values to more accurately illustrate your data visuals.


7
Take advantage of more interactive and dynamic PivotCharts. Quickly gather more insights with the ability to display different data views directly in a PivotChart, independent of PivotTable views, to analyze and capture the most compelling picture of your numbers.


8
Do things easier and faster.Excel 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your spreadsheets with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


9
Harness more power for building bigger, more complex spreadsheets. Power users and analysts rejoice! With the new 64-bit version of Excel 2010, massive amounts of information are easier to analyze than ever before. Analyze large, complex datasets greater than the 2-gigabyte file size of previous Excel versions.


10
Publish and share through Excel Services. SharePoint Server 2010 and Excel Services integration lets business users share analysis and results across their organization by publishing spreadsheets to the Web. Build a business intelligence dashboard and share sensitive business information more broadly with co-workers, customers, and business partners in a security-enhanced environment.

Top 10 benefits of Outlook 2010

Microsoft Outlook offers premium business and personal e-mail management tools to more than 500 million users worldwide. With the release of Outlook 2010, you get a richer set of experiences to meet your communication needs at work, home, and school. From a redesigned look to advanced e-mail organization, search, communication, and social networking features, Outlook 2010 provides you with a world-class experience to stay productive and in touch with your personal and business networks. Want information on Outlook 2010 with customer and contact management features? Please see Top 10 benefits of Outlook 2010 with Business Contact Manager.

Top 10 benefits of Outlook 2010
1
Manage multiple e-mail accounts from one place. You can easily manage e-mail messages from multiple mailboxes. Synchronize multiple e-mail accounts from services such as Hotmail, Gmail, or just about any other provider to Outlook 2010. Improved connectivity with Microsoft Exchange Server supports the use and management of multiple Exchange Server e-mail accounts in one location.


2
Manage large volumes of e-mail with ease. Conversation view in Outlook 2010 improves the tracking of e-mail conversations—reducing information overload—and helps you manage large amounts of e-mail with ease. Entire conversations can be condensed and categorized with a single click. And, new conversation management tools enable you to save valuable inbox space by turning dozens of e-mails into just a few conversations using the Clean Up feature. Or, use the Ignore feature to send the entire conversation to your Deleted Items.



3
Customize common tasks into single-click commands. Create and save custom actions in a new way with Quick Steps in Outlook 2010. You can save time by creating and defining multistep tasks that you can execute with a single click, including reply and delete, move to a specific folder, create a new e-mail to assigned groups, and more.


4
Make scheduling a breeze. Conveniently and efficiently schedule appointments, share your calendar availability and manage your work schedule. With the E-mail Calendar feature, you can send your schedule to others so they can quickly find time for your next appointment. And, the new Schedule View provides a horizontal display of multiple calendars. New calendar management tools enable you to save frequently used groups of calendars so they can be quickly redisplayed whenever you need them.


5
Search to easily find what you’re looking for. With Outlook 2010, you can easily sort through high volumes of data. The enhanced Search Tools provide you with ways to quickly find and manage large quantities of e-mail, calendar, and contact items.



6
Create e-mail messages that capture attention. Dynamic graphics and picture editing tools are not just for Word and PowerPoint anymore. With Outlook 2010, you can grab your readers’ attention by using compelling visuals such as pre-built SmartArt™ graphics, Office themes, and Styles. You also can more easily bring your ideas across to your readers by inserting and formatting screenshots in Outlook.



7
Stay connected to your social and business networks.Outlook 2010 is your hub for friends, family, and colleagues. Use Outlook Social Connector to get additional information about people, such as mutual friends and other social information, while staying better connected to your social and business circles.


8
Ensure that your e-mail messages get to the intended audience.For business users, sending unnecessary e-mail messages to out-of-office contacts, accidentally replying to a large distribution list, or distributing confidential information outside the company are frequent concerns. With the new MailTips feature, you’re alerted when you are about to send e-mail to a large distribution list, to someone who is out of the office or to individuals outside the organization.1


9
Receive voice mail transcripts in your inbox. With Outlook 2010 and new technology in Exchange Server 2010, voice messages are automatically transcribed. A voice-to-text preview of a recorded voice message is sent along with the voice mail recording directly to your inbox. Access them from almost anywhere using your computer, Microsoft Outlook Mobile, or Microsoft Outlook Web App.2


10
Initiate live conversations from Outlook. Keep in touch with your contacts. By using Office Communicator, or your instant messaging application, Outlook 2010 provides presence and status information for those on your buddy or contact list.3 Hover over a name, see their availability and then easily initiate a conversation directly through instant messaging. With Office Communicator, you can start a voice call without leaving Outlook.

Top 10 benefits of PowerPoint 2010

Microsoft PowerPoint 2010 gives you more ways to create and share dynamic presentations with your audience than ever before. Exciting new audio and visual capabilities help you tell a crisp, cinematic story that’s as easy to create as it is powerful to watch. With new and improved tools for video and photo editing, dramatic new transitions, and realistic animation, you can add polish to presentations that will captivate your audience. In addition, PowerPoint 2010 enables you to work simultaneously with other people or post your presentation online and access it from virtually anywhere using the Web or your smartphone.1

Top 10 benefits of PowerPoint 2010
1
Bring more energy and visual impact to your presentations. Save time and money by applying sophisticated photo effects without using additional photo-editing software programs. Transform your images into compelling, vibrant visuals by using new and improved picture editing features such as colour saturation and temperature, brightness and contrast, and an advanced cropping tool, along with artistic filters such as blur, paintbrush, and watercolour.


2
Work with others without having to wait your turn. PowerPoint 2010 redefines the way people can work together on presentations. With co-authoring, you can simultaneously edit the same presentation with individuals in different locations. You can also use Office Communicator or your instant messaging application to view the availability of others who are authoring a presentation with you and easily initiate a conversation without leaving PowerPoint.


3
Add a personalised video experience. Embed and edit video files directly in PowerPoint 2010. Easily trim your video to show only relevant sections. Bookmark key points in a video for quick access or trigger animation to begin automatically when those bookmarks are reached. You can also set the video to fade in and out at specified intervals and apply a variety of video styles and effects—such as reflections, bevels, and 3-D rotation—to help you quickly capture your audience’s attention.


4
Imagine just-in-time show and tell. Instantly broadcast your PowerPoint 2010 presentations by sending out a URL so people can view your presentation on the Web.3 Your audience sees your slides in high fidelity, even if they don’t have PowerPoint installed. You can also turn your presentation into a high-quality video with narration to share with virtually anyone through e-mail, via the Web, or on DVD.


5
Access your presentations from more locations and on more devices. Post your presentations online and then access, view, and edit them from the Web4 or your Windows phone.5 With PowerPoint 2010, you can get things done according to your schedule across multiple locations and devices.
Microsoft PowerPoint Web App. Extend your PowerPoint experience to the Web and enjoy full-screen, high-quality viewing of our presentations. Store your presentations online and edit your work through the PowerPoint Web App when you're away from your office, home, or school.

Microsoft PowerPoint Mobile 2010. Stay current and take immediate action when necessary using an enhanced mobile version of PowerPoint specifically suited to your smartphone.5


6
Create high-quality presentations with stunning graphics. You don’t have to be a design expert to create professional-looking graphics. Use dozens of additional SmartArt® layouts to create many types of graphics such as organization charts, lists, and picture diagrams. Transform words into impressive visuals that better illustrate your ideas. Create diagrams as easily as typing a bulleted list or convert text and images to a diagram in just a few clicks.


7
Captivate your audience with new transitions and improved animations. PowerPoint 2010 offers new, dynamic slide transitions and animation effects that look similar to graphics you’d see on TV. Easily access, preview, apply, customize, and replace animations. You can also use the new Animation Painter to easily copy animations from one object to another.


8
Organize and print your slides more effectively.Easily organize and navigate through slides using slide sections. Divide a presentation into logical slide groups, rename sections to help you manage content—such as to assign slides to a particular author—or easily print just one section of slides.


9
Get things done faster. PowerPoint 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional file menu to let you save, share, print, and publish your presentations with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


10
Work on multiple presentations and multiple monitors. PowerPoint 2010 gives you a completely separate window for each presentation that you open. So, you can view and edit multiple presentations independently, side-by-side, or even on separate monitors.


Top 10 benefits of Access 2010

Microsoft Access 2010 is all about simplicity. Access 2010 empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, it amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Top 10 benefits of Access 2010
1
Get started faster and easier than ever before.

Harness the power of the community in Access 2010. Build on database templates created by others and share your own designs. Use new prebuilt database templates available on Office Online, designed for frequently requested tasks, or select from community-submitted templates and customize them to meet your specific needs.


2
Create a centralized landing pad for your data.

Integrate your Access reports using multiple data connections and information linked or imported from other sources. With improved Conditional Formatting and calculation tools, you can create rich and dynamic reports with visual impact. Access 2010 reports now support data bars, enabling you and your audience to more easily track trends and gain insight.


3
Access your application, data, or forms from virtually anywhere.

Extend your database to the Web so that users without an Access client can open Web forms and reports via a browser and changes are automatically synchronized.1 Or work on your Web database offline, make your design and data changes, and then sync them to Microsoft SharePoint Server 2010 when you’re reconnected. With Access 2010 and SharePoint Server 2010, your data can be protected centrally to meet data compliance, backup, and audit requirements, providing you with increased accessibility and manageability.


4
Apply professional designs across your Access database.

Take advantage of familiar and appealing Office themes and apply them to your databases with high fidelity both on the Access client and the Web. Choose from a variety of themes, or design your own custom theme, to get great looking forms and reports.


5
Add navigation to your database using drag-and-drop functionality.

Create professional looking, Web-like navigation forms to make your frequently used forms or reports more accessible without writing any code or logic. Choose from six predefined navigation templates with a combination of horizontal tabs or vertical tabs. Applications with a large number of Access forms or reports can be displayed using multi-level horizontal tabs. Simply drag-and-drop forms or reports to display.


6
Accomplish your work more quickly and easily.

Access 2010 simplifies how you find and use features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you publish, back up, and manage your database with just a few clicks. And, with the improved Ribbon, you can access your favourite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.


7
Build your expressions effortlessly using IntelliSense.

The simplified Expression Builder makes it faster and easier for you to build out logic and expressions in your database. IntelliSense — Quick Info, ToolTips, and AutoComplete — enables you to reduce errors, spend less time memorizing expression names and syntax, and spend more time focusing on building application logic.


8
Design your macros faster than before.

Access 2010 has a revamped Macro Designer that makes it easier to create, edit, and automate database logic. The Macro Designer enables you to be more productive, reduce coding errors, and easily incorporate more complex logic to create robust applications. Increase code maintainability by using Data Macros to attach logic to your data, centralizing the logic on the source tables. With the more powerful Macro Designer and Data Macros, you can extend automation outside the Access client to SharePoint Web databases and other applications that update your tables.


9
Turn portions of your database into reusable templates.

Save time and effort by reusing database parts built by other users in your database. You can now save frequently used Access objects, fields, or collections of fields as templates that you can add to your existing databases and make you more productive. Application Parts can be shared across your organization to create consistency in building database applications.


10
Integrate your Access data with live Web content.

You can now connect to data sources via Web service protocol. Include Web services and line-of-business applications data right in the databases you build through Business Connectivity Services. 2 And, the new Web Browser control enables you to integrate Web 2.0 content in your Access forms.


Top 10 benefits of Visio 2010


The advanced diagramming tools of Visio 2010 help you simplify complexity with dynamic, data-driven visuals and new ways to share on the Web in real-time.

Start by building your diagram with professional-looking templates and modern, pre-drawn shapes. Then, easily link your diagram to popular data sources (such as Excel). You’ll see data automatically refresh right within your diagram, reflected in vibrant visuals such as icons, symbols, colours, and bar graphs. Finally, with just a few clicks, publish your data-linked diagram to SharePoint, and provide access to others on the Web, even if they don’t have Visio.

Together, simplicity, data-driven shapes, and Web sharing make Visio 2010 one of the most powerful ways to see and understand important information.

1
Jump-start diagramming with templates. With modern, pre-drawn shapes, intelligent templates, and sample drawings, Visio 2010 offers a wide variety of options to meet your diagramming needs for IT, business, process management, and more.


2
Find and access the tools you need quickly. Every step in creating a diagram is more intuitive, with the logical groupings of features in Ribbon tabs, an enhanced Shapes window for easy access to shapes and stencils, and a new status bar that helps you move more efficiently within and between your diagrams.


3
Draw diagrams faster with improved automatic features. Whether you are creating a diagram from scratch, or modifying an existing diagram, Visio 2010 helps you add and align shapes easily and accurately with features such as the Quick Shapes Mini Toolbar, enhanced dynamic grid, page Auto Size, and automatic alignment and layout adjustment.


4
Simplify large and complex diagrams. Add clarity to diagrams using Subprocesses and Containers to group related shapes visually and logically. As a diagram grows larger or becomes more complex, Subprocesses and Containers help you to keep information more organized and understandable.


5
Make your diagrams professional-looking and appealing in seconds. Visio 2010 helps you make diagrams look attractive with a wide range of formatting tools and design options, including modern shapes and visuals, a rich gallery of themes, and Live Preview.


6
Bring your diagrams to life with real-time data. See the entire picture with dynamic, data-driven diagrams. Simply connect your diagram to one or more data sources such as Excel or SQL Server. Then, display real-time data right within your diagrams, based on conditions you define, using vibrant colors, icons, symbols, and data bars.


7
Share diagrams with others on the Web. Easily share dynamic, data-linked Visio diagrams in Microsoft SharePoint Server. Online users can see your real-time information in their browsers at a high level, right on the diagram, or delve into the details—even if they don’t own Visio. They can pan and zoom in the diagram, follow hyperlinks in shapes, and refresh the data.


8
Ensure consistency and accuracy with diagram validation. Check for common errors and support diagramming standards across your organization using diagram validation. With one click, you can validate a diagram against a set of rules to make sure it’s logical and properly constructed.


9
Model and monitor SharePoint workflows. Create and monitor SharePoint workflows more easily than ever with a new, advanced template that contains SharePoint workflow rules and logic, and supports the ability to export and import workflows between Microsoft SharePoint Designer 2010 and Visio 2010.


10
Create visual mashups using Visio Services. Publish and share visually compelling dashboards that contain interactive Visio diagrams and other application services. Visio Services and SharePoint Server integration supports visual mashups of actionable data and diagrams for an information-rich viewing experience.



Top 10 benefits of Project 2010

Microsoft® Project 2010 delivers powerful, visually enhanced ways to effectively manage a wide range of projects and programs. From meeting crucial deadlines to selecting the right resources and empowering your teams, Project 2010 offers easier and more intuitive experiences to help you simply be more productive and realize amazing results.

1. Familiar and intuitive.

The Ribbon makes finding and using your favourite tools simpler with new graphical menus and a familiar experience to help you easily create and manage projects. Tooltips and contextual guidance provide information and shortcuts so you can accomplish more in less time. In the new Microsoft® Office Backstage™ view, simply save, share, print, or publish your projects from one location.


2. Save time and effort.

Save time and effort with familiar and essential functions like text wrapping, filtering, auto-complete, scroll and zoom, and more. Insert new columns on the fly—data types are readily identified so that you can quickly and effectively organize and analyze details. Quickly share schedule details through enhanced copy-and-paste, and retain key formatting between Project 2010 and other Microsoft Office applications.


3. Flexible and powerful.

User-controlled scheduling puts you in control and brings together the flexibility and ease of use of a tool like Microsoft Excel® 2010 and the power of the Project 2010 scheduling engine. Create project schedules at the level of detail that’s right for your project. Work with summary data initially or shift to a more detailed approach when it’s convenient. Place notes as reminders of where additional schedule information is needed, or simply add information as it becomes available.


4. Easier to see and share.

With a completely new and visually enhanced timeline view, you’ll have a clearer view of tasks, milestones, and phases. Newly expanded color palettes and text effects help you make every timeline and plan look their best—and help you to swiftly see and share important dates and deliverables.


5. At-a-glance.

(Team Planner – Pro only)

See the right mix of people and resources: simply drag tasks to effectively plan work for your entire team and project. The new Team Planner view in Project Professional 2010 shows resources and work over time, to help you spot problems and resolve issues. New in Project 2010, the Task Inspector offers additional analysis and intuitive guidance to resolve scheduling conflicts derived from a task’s attributes and assigned resources, which you can choose to act upon or not.


6. Control and deliver.

Quickly compare budget versus actual versus forecasted values to measure an initiative's progress with the flexibility of setting multiple baselines. Create high-level time-phased budgets with user-defined categories for costs and labor. Validate budgets against bottom-up estimates built by using labor, material, and cost resources. Control project costs by comparing budgets to completed tasks and forecasted totals. Use built-in earned-value metrics for predictive analysis and integrated performance management.


7. Evaluate possibilities.

(Inactive Tasks – Pro only)

Often you'll need to evaluate scenarios and consider options when planning new projects or monitoring ongoing work. Using inactive tasks, new in Project Professional 2010, you can easily experiment with your project plan and perform what-if analysis. A simple toggle removes or inserts one or more tasks, along with their effect on the project schedule. Project 2010 also offers more built-in tools to help support what-if analysis and scenario comparison, including multiple-level undo and change highlighting.


8. Collaborate with others.

(Task Status Updates – Pro only)

Connect your teams by synchronizing with Microsoft SharePoint® Foundation 2010. Using Project Professional 2010, you can synchronize SharePoint Foundation 2010 and Project Professional 2010 project task status updates for you and your team members. You can also save your project files to SharePoint Foundation 2010 team sites to communicate plans and collaborate on progress.


9. Grow capabilities.

(Connect to Project Server 2010 – Pro only)

Realize the power of unified project and portfolio management by combining Project Professional 2010 with Microsoft Project Server 2010. Together, Project Professional 2010 and Project Server 2010 create the Microsoft Enterprise Project Management (EPM) Solution, and deliver end-to-end capabilities to help organizations prioritize investments and optimize resources, gain control of all types of work, and visualize performance by using powerful dashboards.


10. Enhance performance.

Use the 64-bit options of Project 2010 to enhance performance and support very large projects and programs. Project Standard 2010 and Project Professional 2010 are offered in 32-bit and 64-bit options to support a diverse range of project types and sizes. 64-bit options take advantage of the expanded memory and optimized capabilities of the latest processors and of the 64-bit versions of Windows 7 and Windows Vista. 64-bit Project Professional 2010 also offers enhanced performance and handles extremely large project files with ease when connected to Project Server 2010.



Q: What is Microsoft Office 365?
A:

Small Business version

This is designed for up to 25 employees who want:

  • A solution without dedicated IT staff
  • Essential email, calendar, and website services
  • Free community support
  • Month-to-month subscription

 

Enterprise version

This is designed for any size organization that wants:

  • Advanced IT configuration and control
  • Office Professional Plus, Active Directory, or advanced archiving capabilities
  • 24x7 IT Administrator support
  • Annual contracts
 

See Office 365 information from Microsoft here
see business information from Microsoft here

 


 

Q: Could you give me information about Windows 7?
A: Click the following links for information from Microsoft about Windows 7:

    Windows 7 Editions

    Comparison between Windows 7 and Vista

    Windows 7 tips

    See our Windows 7 courses

    Guide to Windows 7 (PDF)


Q: What are the benefits of upgrading to Office 2010?
A: Click the following link for information from Microsoft about Office 2010:

    Office 2010


Q: What versions of Microsoft Windows Vista are available?
A: Click the following links for information from Microsoft about Vista versions:
    Windows Vista Enterprise
    Windows Vista Ultimate
    Windows Vista Business 
    Windows Vista Home Premium
    Windows Vista Home Basic
    Windows Vista Starter

    Compare Features


Q: What is the 2007 Microsoft Office Service Pack 2 (SP2)?
A: Details and download information can be found on Microsoft's website - click here to open. You can also click here to see a description of the Service Pack in a pdf doc.


Q: What is ICT?
A: It stands for stands for Information and Communications Technology. 

There are many definitions but it can be summarised as an electronic means of capturing, processing, storing and disseminating information.  ICT is concerned with the storage, retrieval, manipulation, transmission and receipt of digital data and the way these different uses can work with each other.

ICT is often categorised into two main areas: -
1. The traditional computer-based technologies of personal computers or using computers at home or at work; and

2. The newer range of digital communication technologies that are used to communicate and share information.

Incidentally, a Wizard can be a utility within software to assist with a task and guide you through accomplishing it or it could also be someone who is brilliantly dazzling in their field - both applicable to ICT Wizard of course!


Q: What are the benefits of upgrading to Office 2007?
A: click here to see benefits of Office 2007

    click here to see a presentation about Office 2007


Q: What is your fax number?
A: +44 (0) 7006099151


Q: What are Keyboard Shortcuts?
A: A key combination keyboard shortcut is a set of keystrokes that, when pressed together, initiate an action. In some applications you can often find the key combination for a command by resting the mouse pointer over it. If you're not using a mouse, there are no on-screen reminders of the key combinations — you have to memorize the keys.  For a list of keyboard shortcuts click here

 


Q: I have completed my VBA training with ICT Wizard, where can I find more VBA resources online?
A: To see a list of links click here

 


Q: Can you give me any further tips and strategies for creating and delivering an effective presentation?
A:

Click here to see tips in a PDF document
(PDF document - will open in a new window)

     or

Click here to see further tips as an XPS file
(XPS documents open in an Internet Explorer browser window)

 


Q: How do I create RSS feeds in Outlook 2007?
A: Really Simple Syndication (RSS) is a way for content publishers to make news, blogs, and other content available to subscribers. You can view RSS content in Microsoft Office Outlook 2007. Click here to see how.

 


Q: What is a Proactive activity?
A: See an explanation on our website by clicking here.  The Time manager Matrix is taken from: Covey, Stephen R., 1990, The 7 Habits of Highly Effective People, Restoring the Character Ethic, New York, Fireside.    1999, First Things First

 


Q: How do I resize photos for email?

A: to avoid sending large attachments.
You don’t have to use photo editing software; Windows XP has features installed that will optimise your photos for sending and viewing without altering the original photos.  See instructions here.

 


Q: What is XML?

A: XML (Extensible Markup Language) is a general-purpose specification for creating custom markup languages. It is defined as extensible because it allows users to define their own elements. Its main purpose is to facilitate the sharing of structured data across different platforms and information systems, particularly via the Internet.  It is used to encode documents and to serialise data. See further info here

 

 


Q: What is XPS format?

A: XPS is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed. See details on the Microsoft website here

 

 


Q: How can I save or export a file from Microsoft Office 2007 into PDF and XPS formats?

A: By using the Microsoft add-in that can be found here
This download allows exporting and saving to PDF and XPS formats in eight 2007 Microsoft Office programs. It also enables sending e-mail attachments in the PDF and XPS formats .

 


Q: What is an IP address?

A: An Internet Protocol (IP) address is a numerical identification (logical address) that is assigned to devices participating in a computer network utilizing the Internet Protocol for communication between its nodes. (Wiki)

Proxy servers can hide your actual location and details but you must be aware of the risks.

IP addresses are usually expressed in decimal format as shown above but computers communicate in binary form; an IP address in binary would look something like:
11001000.00111011.00101101.11001001

The four numbers in an IP address are called octets, because they each have eight positions when viewed in binary form. If you add all the positions together, you get 32, which is why IP addresses are considered 32-bit numbers. Since each of the eight positions can have two different states (1 or 0) the total number of possible combinations per octet is 256. So each octet can contain any value between 0 and 255. Combine the four octets and you get a possible 4,294,967,296 unique values! (source)

Out of the almost 4.3 billion possible combinations, certain values are restricted from use as typical IP addresses. For example, the IP address 0.0.0.0 is reserved for the default network and the address 255.255.255.255 is used for broadcasts.

 


 


Search

Custom Search

 

Disclaimer

No warranty of any kind, implied, expressed, or statutory, including but not limited to the warranties of non-infringement of third party rights, title, merchantability, fitness for a particular purpose, and freedom from computer virus, is given with respect to the contents of this web site or its hyperlinks to other Internet resources.  Information provided on our website is provided "as is", for training purposes and subject to our terms as outlined in our terms

 

FAQs

Training is a proactive activity

 

See 1&1 for domain names and web site hosting packages:
click below to go to 1&1

 

 

  • Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
  • Qualified trainers with relevant university degrees and frontline experience
  • delivered and arranged by Certified Master Instructors.
  • improve efficiency, effectiveness and productivity.
  • all levels from foundation to expert level.

  • courses delivered on your premises or at an outside venue to suit your needs.

ICT Wizard courses:

  • on your site or locations throughout the UK
  • Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
  • delivered by Certified Master Instructors.

Courses include:

Office 2007 New Features

Microsoft Office 2007 Integration


Microsoft Access courses -

Microsoft Access 2007 Foundation

Microsoft Access 2007 Intermediate

Microsoft Access 2007 Advanced

Microsoft PowerPoint courses -
Microsoft PowerPoint 2007 Foundation New

Microsoft PowerPoint 2007 Intermediate New

Microsoft PowerPoint 2007 Adv

 Microsoft Publisher courses -

Microsoft Publisher 2007 Foundation

Microsoft Publisher 2007 Intermediate

Microsoft Publisher 2007 Adv

Microsoft Publisher 2003 Found

Microsoft Publisher 2003 Intermed

Microsoft Word courses -

Microsoft Word 2007 Foundation

Microsoft Word 2007 Intermediate

Microsoft Word 2007 Advanced

Microsoft Visio courses -

Microsoft Visio 2007 Professional Foundation

Microsoft Visio 2007 Professional Advanced

Microsoft FrontPage and Expression Web courses -

Microsoft Expression Web 2007

Microsoft FrontPage 2003 Found

Microsoft FrontPage 2003 Intermed

Microsoft Outlook courses -

Microsoft Outlook 2007 Foundation

Microsoft Outlook 2007 Intermediate

Microsoft Outlook 2007 Advanced

Business Contact Manager 2007

Microsoft Project courses -

Microsoft Project 2007 Foundation

Microsoft Project 2007 Intermediate

VBA courses -

Excel VBA

Word VBA

Access VBA

Microsoft Windows courses -

Microsoft Windows Vista Basic

Microsoft Windows Vista Adv
  

SharePoint courses -

SharePoint Designer 2007 Basic

SharePoint Designer 2007 Adv

Adobe courses -

Adobe Acrobat 8 Professional Foundation New

Adobe Acrobat 8 Professional Advanced New

Adobe Acrobat 7 Professional

Many other courses, see here