MS ACCESS 2013

Access is a database management system that combines a relational database engine with a graphical user interface and software-development tools. It stores data in its own format and can also import or link directly to data stored in other applications and databases.

Software developers and data architects can use Access to develop application software, and “power users” can use it to build software applications.Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components.

Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.

COURSES

MS Access 2013 Introduction »

MS Access 2013 Intermediate »

MS Access 2013 Advanced »

MS EXCEL 2013

Excel is a spreadsheet application and features calculation, graphing tools and pivot tables.

Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.In addition to its standard spreadsheet features, Excel also offers programming support via Microsoft’s Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE), and extensive graphing and charting capabilities.

COURSES

MS Excel 2013 Introduction »

MS Excel 2013 Intermediate »

MS Excel 2013 Advanced »

MS OUTLOOK 2013

Outlook is a personal information manager used mainly as an email application but also includes a calendar, task manager, contact manager, note taker and journal.

It can be used as a stand-alone application, or can work with Microsoft Exchange Server and Microsoft SharePoint Server for multiple users in an organization, such as shared mailboxes and calendars, Exchange public folders, SharePoint lists and meeting schedules.

There are third-party add-on applications that integrate Outlook with devices such as BlackBerry mobile phones and with other software such as Office and Skype internet communication. Developers can also create their own custom software that works with Outlook and Office components using Microsoft Visual Studio. In addition, Windows Mobile devices can synchronize almost all Outlook data to Outlook Mobile.

COURSES

MS Outlook 2013 Introduction »

MS Outlook 2013 Advanced »

MS POWERPOINT 2013

PowerPoint is presentation application designed to help users create informative slides that can contain text, graphics, movies and similar objects. Presentations can be viewed as printouts, directly on a computer, or via video projectors, and are frequently used in business and educational settings for situations like lectures, meetings and product briefings.

PowerPoint presentations can also be viewed, edited and shared in the cloud with Microsoft’s Office Web Apps, a collection of free online companions to Microsoft Word, Excel, PowerPoint, and OneNote.

New features in the latest releases of PowerPoint include direct video embedding and editing, Smart Guides, a new Reading View, a Broadcast Presentation feature, and new built-in transitions and animations effects.

COURSES

MS PowerPoint 2013 Introduction »

MS PowerPoint 2013 Advanced »

MS PROJECT 2013

Project is a project management software program which is designed to assist a project manager in developing a plan, assigning resources to tasks, tracking progress, managing the budget, and analysing workloads.

Project creates budgets based on assignment work and resource rates. As resources are assigned to tasks and assignment work estimated, the program calculates the cost, equal to the work times the rate, which rolls up to the task level and then to any summary tasks and finally to the project level.

Schedules can be resource levelled, and chains are visualized in a Gantt chart.

COURSES

MS Project 2013 Introduction »

MS Project 2013 Intermediate »

MS Project 2013 Advanced »

MS VISIO 2013

Visio is a drawing, diagramming and vector graphics application that includes a variety of pre-drawn shapes and picture elements that can be dragged and dropped onto the illustration.

Users can define their own elements and place them onto the Visio palette.It is available in three editions:

Standard, Professional and Premium. The Standard and Professional editions share the same interface, but the latter has additional templates for more advanced diagrams and layouts, as well as unique capabilities intended to make it easy for users to connect their diagrams to data sources and display their data graphically.

COURSES

MS Visio 2013 Topic Details »

MS WORD 2013

Word is a widely used commercial word processing application.

Microsoft Word offers several features to ease document creation and editing, including:

– WYSIWYG (what-you-see-is-what-you-get) display: It ensures that everything you see on screen will appear the same way when printed or moved to another format or program.

– Spell Check: Word comes with an built-in dictionary for spell checking; misspelled words are marked with a red squiggly underline. Sometimes, Word auto-corrects an obviously misspelled word or phrase.

– Text-level features such as bold, underline, italic and strike-through.

– Page-level features such as indentation, paragraphing and justification

– External support: Word is compatible with many other programs, the most common being the other members of the Office suite.

COURSES

MS Word 2013 Introduction »

MS Word 2013 Intermediate »

MS Word 2013 Advanced »