Excel 2013 is a game changer for any Excel user. Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.

In this course we learn the following:

Power Query

• Cleaning up Data
• Merging Data
• Appending Data
• Grouping Data
• Loading data to PowerPivot

Power Pivot

• Create relationships between Tables
• Manage millions of rows of data
• Custom Calculations, Key Metrics and KPIs
• Analyzing Data with Pivot Tables
• Analyzing Date data

Power View

• Creating Tables and Cards
• Visualizing data with Graphs
• Creating Interactive dashboards
• Filter and Ask Questions of your Data
• Powerful data analysis with ScatterPlots and BubblePlots
• Visualize Geographical data and maps

Power Map

• Mapping Data with Power Map
• Changing the Method of Visualization
• Changing the Method of Aggregation
• Mapping Data over Time
• Creating Tours

This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.

Create amazing reports and analyze data in minutes with Excel Pivot Tables. This course focuses on creating and understanding how to use Excel Pivot Tables to quickly analyze and understand your business data. Pivot Tables make it easy to compile management reports and generate new insight and intelligence from your data in minutes.

This Excel Business Intelligence training course is for all business users who are required to develop management reports, analyze data or ask ad-hoc questions of their data. McKinsey Consulting in a recent report entitled 'Big data: The next frontier for innovation, competition, and productivity' emphasizes that data skills will become the basis for competition, innovation, growth and productivity. The report also highlights the need for around 1.5 million managers in United States with data skills.

This course has over 25 video lectures that take you step by step through creating management reports and analyzing data with a couple of clicks of the mouse. The course is structured into 9 sections which takes you from creating simple management reports to sophisticated data analysis.

Learn techniques to easily aggregate your data, produce reports, understand trends, filter your data, create interactive reports and use sophisticated calculations.

So begin your journey today with Excel Business Intelligence.

• Create management reports in minutes
• Analyze business data effectively
• Learn to format Pivot Tables
• Calculate trends
• Calculate percentage contributions
• Create a range of calculations such as rankings and difference from
• Learn to create frequency analysis with Pivot Tables
• Use Slicers to analyze data in seconds

In this course we are going to show you how to supercharge your Google Sheets into Interactive Dashboards and incredible reports. Google Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.

Google Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes. The addition of filtering tools produces stunning reports that will take your data analysis to the next level.

Google Data Studio is available for free to people with a Google or Gmail account. In addition reports and dashboards can be shared to any users whether they have a Google account or not.

In this course we are going to teach you the following:

• How to connect Data Studio to Google Sheets
• Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values
• Create Scorecards to display key metrics and KPIs
• Create powerful trend analysis graphs to help with forecasting
• Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button
• Learn to gain powerful analysis from Stacked Bar and 100% graphs
• Create powerful Time and Category filters to easily create interactive reports
• Learn to share your Reports and Dashboards with other users

Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.You will need a Google Account,Google Sheets and Google Data Studio.

Microsoft Power BI is continually evolving. We have added the following new lessons to address the new features that Power BI have added in recent months:

• Using the new Table and Matrix visualizations
• Creating Drill through between different sheets. For example you could be reviewing a list of Products and want to select one Product to view a summary of this product
• Themes - Learn how to add new Power BI Themes from the Community Theme Gallery
• Changes in Custom Visuals - We look at how to easily add Custom Visualizations from the new Microsoft Office Store
• Creating Apps - Learn how to easily share your dashboards and reports using Power BI apps and App workspaces
• Relative Date Filters - In this lesson we show how to easily create a dashboard displaying Microsoft stock data. Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters
• Quick Measures - Learn how to easily create and use Quick Measures. Calculate averages across categories or Year to Date totals on tables.
• Ribbon Chart - Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

-----------------------------------------

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free - all you need to do is sign up!

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses powerful drag and drop capabilities that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful PowerBI Desktop Designer.

The Complete Introduction to Business Data Analysis teaches you how to apply different methods of data analysis to turn your data into new insight and intelligence.

The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. A recent McKinsey Consulting report has identified that data analysis is one of the most important skills required in the American economy at the current time.

This course focuses on the following different methods of analysis. During the course you will understand why the form of analysis is important and also provide examples of using the analysis using Excel 2013.

The following methods of analysis are included:

• Comparison Analysis
• Trend Analysis
• Ranking Analysis
• Interactive Dashboards
• Contribution Analysis
• Variance Analysis
• Pareto Analysis
• Frequency Analysis
• Correlations

The Complete Introduction to Business Data Analysis is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy to use techniques that are taught in this course.

This course is presented using Excel 2013. Excel 2010 can be used for the majority of the training exercises. Small parts of the course do use Excel Power Pivot and Power View. Please note that this course does not include any complicated formulas, VBA or macros. The course utilizes drag and drop techniques to create the majority of the different data analysis techniques.

Welcome to this course on Tables, Conditional Formatting and Excel formulas. This course is for all Excel users who want to take their Excel skills and capabilities to the next level.

This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets. The course is presented in an easy to follow step by step approach. The course also includes practical activities for the student to practice the skills that have been learnt in the course.

The course will provide you with a comprehensive understanding of the following:

Tables

• How to create and format Tables
• How to easily filter data in text, numeric and date fields
• Easily Sum, Average, Count and use Max and Min in your tables
• Use Slicers to easily filter Table data

Conditional Formatting

• How to apply conditional formatting rules
• How to easily highlight the Top 10
• Learn to use Data Bars and Color Scales
• Learn to apply icons

Formulas

• Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS
• Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay
• Learn Text formulas such as LEFT, MID, RIGHT and TRIM
• Learn to use the IF formula to create powerful 'IF Then' logic
• Learn the HLOOKUP and VLOOKUP

This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.

This course is for all Excel users who wish to learn how to create powerful interactive dashboards using Pivot Charts and Pivot Tables. This course will teach you to turn your Excel data into powerful tables, graphs and dashboards.

In this course you will learn to create three different dashboards.

The first dashboard will focus on Sales information creating key metrics, trends, top 10 analysis and a percentage contribution.

The second dashboard will focus on Human Resource data and display key metrics, number of employees by age, number of employees by years of service and gender profile.

The third dashboard focuses on financial information and allows the user to understand the variance of the Profit from previous months and how much it has changed from month to month. In addition techniques and tools such as sparklines, data bars, trendlines and slicers are also included.

This course is very important for all Excel users who are required to develop management reporting or to perform data analysis and wish to gain insight and intelligence from their data.

The course is designed to take you through step by step to create the interactive dashboards using simple drag and drop techniques. This course does not include any custom programming or macros. All the dashboards and techniques can be followed by any Excel user who understands the basic principles of Excel.

An introductory knowledge of Pivot Tables and Pivot Charts will assist you in the course. However you can follow the step by step instructions if you do not have an in-depth knowledge of Pivot Tables and Pivot Charts. Please note that you will require Excel 2010 or 2013 for this course. The course is presented using Excel 2013.

Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.

Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.

• Create relationships between tables of data without Vlookups
• Create powerful Key Metric and Key Performance Indicator calculations
• Manage and work with data models of millions of records of data
• Create powerful new dashboards and reports

Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.

Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.

Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.

Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light.

Leading a team? Boost their efficiency in minutes with this mega packed Excel Productivity course.

Excel Productivity shows you have to work faster and smarter in Excel. You'll pick up great tips that will make working in Excel a pleasure.

Some of the areas covered include:

• Conditional formatting
• Various types of sorting
• Days and years between dates
• Removing duplicates
• Viewing multiple sheets in a single view
• and more

The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster.

The Microsoft Office 2016: New Features course builds upon the candidates’ existing Microsoft Office 2007/2010 knowledge and skills by focusing on the new and enhanced features in Microsoft Office 2016. The course enables the candidates to manage, organize, present, and distribute your company’s data and information in a much more organized manner. The course explores a variety of enhancements in Microsoft Word 2016, Microsoft Excel 2016, Microsoft PowerPoint 2016 and Microsoft Outlook 2016. This course helps bridge the gap from the previous versions to this latest release of Microsoft’s flagship office productivity suite.

Microsoft Office is critical to the day to day operations of any organization. This course is specifically focused on the common applications from the Microsoft Office suite that are used by almost every organization. The course is essential to allow smooth transition from the older Microsoft Office versions to the latest Microsoft Office 2016.

The Microsoft Outlook 2016 Advance course is the second and final course in the two course series on Outlook 2016. The course provides the more advanced and complex knowledge necessary for the end users to make full use of the functionalities and features of Microsoft Outlook 2016. The course covers the advanced topics such as global options, outlook data files, contacts and groups, message management and search function.

Microsoft Office Outlook is a very useful email management application. This series on Microsoft Outlook 2016 provides the students with a complete overview of the latest Outlook application and enables them to manage their email communications, contact information, calendar events, tasks, and notes.

The Microsoft Office Access 2016: L3 course builds upon basic Microsoft Access skills acquired in Access Level 1 and Level 2 courses to help students become the masters of Microsoft Office Access 2016. In this Microsoft Access course, students will delve deeper into the program by studying more complex topics such as implementing advanced form designs, sharing data across applications, using macros to improve user interface, using VBA, using advanced database management, distributing and securing a database and managing switchboards.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.

The Microsoft Excel 2016 Advanced course is the third and last course in the three course series on Microsoft Office Excel 2016 that covers the advanced-level topics regarding Microsoft Excel 2016. The course covers the more complex concepts like multiple worksheets, lookup functions, formula auditing, workbook sharing and protection, workbook automation and data mapping.

Microsoft Office Excel 2016 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2016 to achieve excellence in the daily routine tasks.

The Microsoft Office Access 2016: L2 course builds upon basic Microsoft Access skills acquired in Access Level 1 course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more. The course focuses on the Access 2016 topics such as designing a relational database, joining tables, using data validation, creating advanced queries, organizing a database for efficiency and using advanced reporting techniques.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.

The Microsoft Office Access 2016: L1 course helps the individuals and their organizations to collect and manage large amounts of data. Microsoft Office Access 2016: L1 course allows the candidates to use Microsoft Office Access 2016 as a personal data management tool, or to develop applications for a department or an entire organization. The course focuses on the Access 2016 to manage the data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Microsoft Office is critical to the day to day operations of any organization. This course is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.

The Microsoft Excel 2016 L2 course is the second course in a three course series on Microsoft Office Excel 2016 that covers the intermediate-level topics regarding Microsoft Excel 2016. The course covers the more advanced concepts like functions, lists, data analysis, data visualization and pivot tables. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2016.

Microsoft Office Excel 2016 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2016 to achieve excellence in the daily routine tasks.

The Microsoft Outlook 2016 Basic course is the starting point for the two course series on Outlook 2016. The course provides the basic knowledge necessary for the end users to make full use of the functionalities and features of Microsoft Outlook 2016. The course covers the fundamental topics such as formatting email messages, work with attachments, customize message options and work with tasks, notes and calendar.

Microsoft Office Outlook is a very useful email management application. This series on Microsoft Outlook 2016 provides the students with a complete overview of the latest Outlook application and enables them to manage their email communications, contact information, calendar events, tasks, and notes.

The Microsoft PowerPoint 2016 Advanced course is the second and last course in the two course series on PowerPoint 2016. The course provides the more advanced and complex knowledge necessary for the end users to make full use of the functionalities and features of Microsoft PowerPoint 2016. The course covers the advanced topics such as modifying the PowerPoint environment, customization of design templates, SmartArt, math equations, animations and presentation security.

Microsoft Office PowerPoint is a very useful content presentation application. This series on Microsoft PowerPoint 2016 provides the students with a complete overview of the latest PowerPoint application and enables them to prepare, develop and deliver effective presentations using Microsoft Office PowerPoint 2016.

The Microsoft PowerPoint 2016 L1 course is the starting point for the two course series on PowerPoint 2016. The course provides the basic knowledge necessary for the end users to make full use of the functionalities and features of Microsoft PowerPoint 2016. The course covers the fundamental topics such as developing a PowerPoint presentation, advanced text editing, graphical elements, objects and adding tables and charts to a presentation. The course also gives some helpful tips to candidates on how to prepare for a presentation.

Microsoft Office PowerPoint is a very useful content presentation application. This series on Microsoft PowerPoint 2016 provides the students with a complete overview of the latest PowerPoint application and enables them to prepare, develop and deliver effective presentations using Microsoft Office PowerPoint 2016.

The Office 2013 Transition from Microsoft 2007/2010 course builds upon the candidates’ existing Microsoft Office 2007 and 2010 knowledge and skills by focusing on the new and enhanced features in Microsoft Office 2013. The course enables the candidates to manage, organize, present, and distribute their organization’s data and information in a much more organized and secure way using the Microsoft Office 2013. The course explores a variety of enhancements in Microsoft Word 2013, Microsoft Excel 2013, Microsoft PowerPoint 2013 and Microsoft Outlook 2013. This course helps bridge the gap from the previous versions to this latest release of Microsoft’s flagship office productivity suite.

Microsoft Office is a suite of applications, critical to the day to day operations of any organization. This course is specifically focused on the common applications from the Microsoft Office suite that are used by almost every organization. The course is essential to allow smooth transition from the older Microsoft Office versions to the latest Microsoft Office 2013.

The Microsoft Office Access 2010: Advanced course builds upon the Microsoft Access skills acquired by the candidates in Access 2010 Basic and Intermediate courses and helps the students become the masters of Microsoft Office Access 2010. In this Microsoft Access course, students will delve deeper into the program by studying more complex topics such as query with SQL, create crosstab, parameter, and action queries, create macros, import, export and link database objects, interact with XML documents, create hyperlink fields, optimize, split and backup databases. The students will also learn to secure the databases by implementing password-protection, encryption and access options.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2010 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2010.

The Microsoft Office Access 2010: Intermediate course builds upon basic Microsoft Access skills acquired in Access 2010 Level 1 course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage and normalize data, manage table relationships, enforce referential integrity, work with lookup fields and subdatasheets, create join queries, calculated fields and summary values, add objects to forms, and learn to create advanced form types, print reports and labels, and understand the functionalities of PivotTables and PivotCharts.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2010 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2010.

Microsoft Word 2013 is a very popular word processing program that can be used for both personal and business purposes. While already feature rich and critical for productivity, Microsoft continues to improve and enhance their software with each new release like theMicrosoft Word 2013. In this course, you will develop and improve your Microsoft Word skills, so that you are able to maximize this industry standard word processing system.

Our Word 2013 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Word 2010 Exam 77-418, you achieve Microsoft Certified Application Specialist (MOS) status in Word 2013.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

The Microsoft Outlook 2010 Basic course is the starting point for the three course series on Outlook 2010. The course provides the basic knowledge necessary for the end users to make full use of the functionalities and features of Microsoft Outlook 2010. The course covers the fundamental topics such as formatting email messages, work with attachments, customize message options and work with contacts, appointments, meetings, tasks and calendar.

Microsoft Office Outlook is a very useful email management application. This series on Microsoft Outlook 2010 provides the students with a complete overview of the latest Outlook application and enables them to manage their email communications, contact information, calendar events, tasks, and appointments.

This very basic training course on Microsoft Windows 7 is part of the two course series on Microsoft Windows 7 operating system. The course gives an overview of the new features in Microsoft Windows 7 operating system and enables the students to navigate through Windows 7 interface by learning the basic concepts. This basic course is designed for inexperienced professionals who are beginning to use personal computers at their home, office or educational institute.

Microsoft Windows is the most widely used personal computer operating system in the world. Anyone who wants to use computers should have a little know-how of this operating system. This course develops the essential skills of navigation and usage of Windows 7 so that the beginners get the feel of the interface and the features it has to offer.

The Microsoft Office 365 is a suite of cloud-based applications by Microsoft. This suite of applications provides the users with Microsoft Office applications in a cloud-based environment. This course is an introductory course and gives the students an overview and working knowledge of using Microsoft Outlook, Microsoft Office and other Microsoft applications on Microsoft Office 365 platform.

The Microsoft Office 365 – End Users course provides an overview of the Microsoft Office 365 web applications and enables the candidates to make full use of the cloud-based environment. In addition to learning the basics of the web applications, the students will develop an understanding of how Microsoft Office 365 can provide a central location for accessing and modifying shared documents. The candidates will also learn to perform basic tasks such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft Office 2016 on the local computer.

The Microsoft Word 2010 Intermediate course is the second course in a three course series on Microsoft Office Word 2010 that covers the intermediate-level topics regarding Microsoft Word 2010. The course builds on the fundamental knowledge gained in the Word 2010 L1 course and explores the concepts like organizing tables and charts, controlling the flow of document, quick parts and templates.

Microsoft Office Word 2010 is an essential application for students, office workers, executives, writers and publishers. This course helps the candidates to get started with the latest version of Microsoft Office Word. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Word 2010 to achieve excellence in the daily routine tasks.

The Microsoft Word 2010 Advance course is the third and final course in the three course series on Microsoft Office Word 2010 that covers the advanced-level topics regarding Microsoft Word 2010. The course builds on the fundamental knowledge gained in the Word 2010 L1 and Word 2010 L2 courses and explores the complex and advanced concepts like manipulating images, custom graphic elements, collaboration, forms, macros and Mail Merge.

Microsoft Office Word 2010 is an essential application for students, office workers, executives, writers and publishers. This course helps the candidates to get started with the latest version of Microsoft Office Word. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Word 2010 to achieve excellence in the daily routine tasks.

The Microsoft Office 365 is a suite of cloud-based applications by Microsoft. This suite of applications provides the users with Microsoft Office applications in a cloud-based environment. This course is an introductory course and gives the students an overview and working knowledge of using Microsoft Outlook, Microsoft Office and other Microsoft applications on Microsoft Office 365 platform.

The Microsoft Office 365 – End Users course provides an overview of the Microsoft Office 365 web applications and enables the candidates to make full use of the cloud-based environment. In addition to learning the basics of the web applications, the students will develop an understanding of how Microsoft Office 365 can provide a central location for accessing and modifying shared documents. The candidates will also learn to perform basic tasks such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoft Office 2016 on the local computer.

The Microsoft Project 2010 Basic course is the first course in a two course series on Microsoft Office Project 2010. The course series cover the application features, use cases and other tips and tricks that can enable the candidates to take full benefit of the Microsoft Office Project 2010. This course focuses on the beginner-level topics regarding Microsoft Project 2010. The course covers the fundamental concepts like creating and managing task lists, establishing project schedule, creating calendar, assigning tasks to resources, and tracking cost of a project. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Project 2010 from older versions such as Microsoft Office Project 2007.

Microsoft Office Project 2010 is an essential application for project management staff especially project managers and project leaders. This course helps the candidates to get started with Microsoft Office Project 2010. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Project 2010 to achieve excellence in the daily routine tasks.

The Microsoft Excel 2010 Basic course is the first course in a three course series on Microsoft Office Excel 2010 that covers the beginner-level topics regarding Microsoft Excel 2010. The course covers the fundamental concepts like managing, formatting, modifying and printing Excel workbooks. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010.

Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks.

The Microsoft Word 2010 Basic course is the first course in a three course series on Microsoft Office Word 2010 that covers the beginner-level topics regarding Microsoft Word 2010. The course covers the fundamental concepts like formatting text and paragraphs, managing lists, tables, graphical objects and page appearance. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Word 2010 from older versions such as Microsoft Office Word 2007.The Microsoft Word 2010 L1 course is the first course in a three course series on Microsoft Office Word 2010 that covers the beginner-level topics regarding Microsoft Word 2010. The course covers the fundamental concepts like formatting text and paragraphs, managing lists, tables, graphical objects and page appearance. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Word 2010 from older versions such as Microsoft Office Word 2007.

Microsoft Office Word 2010 is an essential application for students, office workers, executives, writers and publishers. This course helps the candidates to get started with the latest version of Microsoft Office Word. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Word 2010 to achieve excellence in the daily routine tasks.

The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010.

Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks.

The Microsoft Office 365 – Administration Basics enables the candidates to setup a cloud-based environment by evaluating, planning and deploying Microsoft Office 365. The candidates are also enabled to operate and administer the Microsoft Office 365 services including identities, dependencies, requirements, and supporting technologies. The students will learn the skills required to set up and sustain an Office 365 tenant and users.

This course focuses on the administration, configuration, troubleshooting and operations of the Microsoft Office 365 platform. The candidates who complete this course are able to setup a working environment of Microsoft Office 365 including all applications such as Exchange Online, SharePoint Online and Skype for Business.

The Microsoft PowerPoint 2010 Advance course is the second and final course in the two course series on PowerPoint 2010. The course provides the more advanced and complex knowledge necessary for the end users to make full use of the functionalities and features of Microsoft PowerPoint 2010. The course covers the advanced topics such as modifying the PowerPoint environment, customization of design templates, SmartArt, math equations, animations and presentation distribution.

Microsoft Office PowerPoint is a very useful content presentation application. This series on Microsoft PowerPoint 2010 provides the students with a complete overview of the latest PowerPoint application and enables them to prepare, develop and deliver effective presentations using Microsoft Office PowerPoint 2010.

The Microsoft Outlook 2010 Advance course is the third and final course in the three course series on Outlook 2010. The course provides the more advanced and complex knowledge necessary for the end users to master the Microsoft Office Outlook 2010. The course covers the advanced and complex topics such as collaborating with Microsoft Outlook, managing mailbox, working with notes and journals, managing calendar and contacts, using mail merge and templates.

Microsoft Office Outlook is a very useful email management application. This series on Microsoft Outlook 2010 provides the students with a complete overview of the latest Outlook application and enables them to manage their email communications, contact information, calendar events, tasks, and notes.