Certified Data Science Training using R, SAS and Microsoft Excel-3035530865

Course Objectives

At the end of this course you will be able to

• Describe the stages of analytics life cycle
• Use a variety of statistical tools and techniques to analyze data
• Use such tools to explore data
• Design, model and manage databases in an effective way
• Deliver new insights and competitive intelligence
• Use the SAS software with ease

Description

Section 1 : Analytics Using Excel

Introduction to the Course MS Excel 2010 Advanced

This chapter will provide a brief introduction about Microsoft Excel 2010 advanced

Office Button and Paste Function

This section gives you step by step procedure of using the paste function in MS Excel and it also lets you know the various other paste options.

Sparklines, Custom Ribbons and Screenshots

This section explains what is sparklines, ribbons and how to take screenshots along with examples.

Conditional Formatting and Equation Editor

Lets you learn how to use the new equation editing tool in Excel 2010 and highlight the cells using conditional formatting.

Paste Special

Here you can learn the step by step procedure of using the paste special option in Excel 2010.

Logical functions – IF AND OR

This topic lets you learn how to use Excel’s logical functions IF, AND and OR with few examples.

Arithmetic functions MAX MIN ABS etc

In this chapter you will be learning how to use the mathematical functions in Excel 2010.

COUNT COUNTIF COUNTA COUNTBLANK

This topic will explain all the different count function in Excel the purpose of it along with their specific criteria and examples for each.

Cell Information – IFERROR ISBLANK etc

Here you will learn what is IFERROR, ISBLANK formula is, its syntax, how does it work in Excel 2010and the examples.

CHOOSE Function

This section explains the formula syntax and usage of the CHOOSE function in Microsoft Excel.

VLOOKUP Function

In this you will understand how to use Excel’s VLOOKUP function with example

HLOOKUP Function

This section describes the formula syntax and usage of the HLOOKUP function in Excel with examples.

MATCH & INDEX

This chapter will help you to understand the basics of MATCH and INDEX function in Excel, how and where to use it and how to use MATCH and INDEX function in place of VLOOKUP function.

Database functions – DSUM DAVERAGE DCOUNT

This section explains the more complex versions of the basic SUM functions and helps you to learn how to use Excel D functions with few examples.

OFFSET Function- Understanding basics

This chapter explains how to use the OFFSET function to return the value of a cell in excel and a basic understanding of it.

OFFSET Function – Dynamic nature

This lets you learn how to create and use dynamic range names in Excel using the OFFSET function

FORECAST Function

Here you can understand the formula syntax and usage of the FORECAST function in excel along with its function.

One Dimensional Data Tables

In this chapter you will learn how to create a one variable data table in Excel 2010 with sample values

Two dimensional Data Tables

This section will make you understand how to use two variable data table in Excel 2010.

Solver

This chapter gives a brief introduction about the tool called Solver in Excel 2010 and the step by step procedure to use this tool

Goal Seek

Here you will understand what is Goal Seek feature in Excel 2010 and using What if analysis command in Excel.

Array Function – Introduction

This section gives a quick introduction to arrays and array formulas in Excel 2010

Array Function – Row and Columns

Under this section you will learn the array function with examples in detail.

Array Function – TRANSPOSE

This section gives you the detail of array formula “TRANSPOSE” in detail and how to use it in Excel 2010.

Array Function – FREQUENCY

This explains how to calculate the frequency distributions in Excel 2010

PROPER UPPER LOWER LEFT RIGHT MID

This chapter is a quick guide on how to use various text related functions like PROPER UPPER LOWER LEFT RIGHT MID in Excel 2010

FIND CLEAN REPT CONCATENATE

Explains these text functions in detail along with examples

Pivot Tables

This section explains how to create or delete a pivot table in Excel

Pivot Table Filter – Slicer

This chapter explains how to use Slicer to filter Pivot table data in Excel 2010.

Pivot Charts

Under this section you will learn how to produce a pivot chart report in Excel 2010.

Naming Dynamic Ranges

This section will help you in creating and checking dynamic named ranges using OFFSET function in Excel 2010

Naming a Cell and a Range

In this section you will learn how to name a cell or a cell range in Excel 2010 with example.

Auditing Toolbar

This lets you know how to use auditing toolbar to investigate spreadsheets in Excel

Watch Window

Here you can learn how to use watch window to inspect, audit or confirm formula calculations and results in larger worksheet

Group Boxes and Options Button

This is an tutorial on how to add group box or a frame control to a worksheet

Check Boxes

This topic lets you to learn how to create and use a check box in worksheet. It also lets you to know how to insert multiple check boxes

List Boxes and Combo Boxes

In this section you will learn how to use list box and combo box in a worksheet in Excel 2010

Scroll Bar and Spinners

This topic lets you learn how to add a scroll bar or a spin button to a worksheet in Excel

Text to Columns

You can learn how to use combinations of text functions to extract from one cell and copy it into other cells

Grouping Tabs

In this chapter we will learn the step by step process to group and ungroup worksheets in Excel 2010

SUBTOTAL Function

This chapter tells you how to use SUBTOTAL function syntax in Excel and mentions its arguments

Hyperlinks

Here we will learn how to use and stop automatics hyperlinks and how to use special characters in hyperlinks in Excel 2010

Data Validation

In this section we will see how to add data validation in Excel sheets

Random Numbers

This tutorial lets you understand how to use the Excel RAND function with its syntax and few examples

Custom View

This topic tells you how to use custom view to save specific display settings and filter data and columns

Protecting – Worksheet and Workbook

Here you will learn how to password protect your worksheet or workbook elements

Excel 2010 Sparklines

It explains what is sparklines and how to use them

Range Charts Type 1

In this section you will learn how to create a chart and customize it

Range Charts Type 1- Continued

The various types of charts are explained with examples

Range Charts Area Type 2

This helps you to create type 2 charts and customize it

Range Charts Area Type 2- Continued

Type 2 charts are explained with examples in this section

Funding Graph

Creating a budget graph in excel can be learnt in this chapter

Two Axis Graphs

This will show you how to create a two axis graph in Excel 2010

Scenario Graphs

Here you will understand how to evaluate scenarios with Excel using Graphs

Scenario Graphs Continued

The formation of scenario graphs is explained with examples

Average Line

This section tells you how to add average line chart in excel

Bar to Pie Chart

Lets you learn to create bar and pie charts in Excel 2010

Combo Charts

This chapter explains how to create a combination chart and how to represent data in a combination chart

Creating Histograms

You will know how to use the histogram tool in excel and how to present your data in Histogram

Invert Negatives

Here you will learn how to change positive numbers into negative in excel and how the negative values can be converted into chart

Scrolling Chart

Gives step by step guide to create a scrolling chart in Excel 2010

Scrolling Chart Continued

Examples of scrolling chart is given in this section

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel Professional In Company Training-3035530865

Description

This course contains the following modules:

Advanced Conditional Formatting
- Editing Standard Formatting Rules
- Using Formulas in Conditional Formatting

Using Form Controls and Templates
- Using Form Controls
- Creating Templates

Advanced Lookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using Index and Match with Array Formula
- Using the Indirect Function

Advanced Functions in Excel
- Using Error Functions
- Using Logical Functions
- Using Array Formulas
- Using Rounding Functions

Advanced Pivot Table Tools
- Importing Pivot Table Data
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles

Introduction to User Defined Functions Using VBA
- Creating a User Defined Function
- Creating an Interactive Procedure
- Create and Share a Function Add-in

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Office Fundamentals: PowerPoint and Excel-3035530865

Overview

With so much communication to contend with today, it can be difficult to grab people's attention.

Description

Course Description:

With so much communication to contend with today, it can be difficult to grab people's attention. So, to grab and maintain an audience's focus we need to be clear, organised, and engaging. And, that is exactly what Microsoft Office PowerPoint can help you do by creating engaging, dynamic multimedia presentations With the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming very challenging. Fortunately, this is where Microsoft Office Excel can help. Excel can help you organise, calculate, analyse, and present your data in simple way and in less time, than if using pen-and-paper methods or non-specialised software. This course aims to provide you with a foundation for Excel knowledge and skills.

Who is this course for?

This course is designed for students who wish to gain a foundational understanding of Microsoft PowerPoint and Excel that is necessary to create and develop engaging multimedia presentations, and to create and work with electronic spreadsheets.

Requirements

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

Career path

 Get started with Microsoft Office Exc· Prepare to deliver your presentation · Add graphical elements to your presentation · Perform advanced text editing operations · Develop a PowerPoint presentation · Identify the basic features and functions of PowerPoint ·Upon successful completion of this course, students will be able to:  Print workbooks· Perform calculations ·el

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel: Essential Excel Functions-3035530865

Description

The Microsoft Excel Masterclass course is designed for professionals that want to learn the ins and outs of excel to help boost your productivity and skills for work.

If you are looking at this course, you already have some experience with excel but don’t really know how to use essential excel functions.

There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.

If you don’t understand how to really use excel, you’ll slowly get left behind. This course will encourage you to take the next step in separating yourself from your peers by learning how to really use excel.

Microsoft Excel Masterclass will cover the following topics:

Topic 1 - Starting Off

• Introduction To Excel 2013
• Recap Of Software Layout

Topic 2 - Home Tab

• Home Tab
• Wrap Text And Cell Format

Topic 3 - Insert Tab

Topic 4 - Page Layout Tab

• Page Sizing
• Gridlines
• Bring Forward & Send Backward

Topic 5 - Formulas Tab

• Function Dropdowns
• Trace Precedents & Dependents
• Formula Checking
• Calculation Options

Topic 6 - Data Tab

• Sorting & Filtering
• Text To Columns
• Data Validation

Topic 7 - Review Tab

• Protect & Share Workbooks

Topic 8 - View Tab

• Freeze Panes & Split

Topic 9 - File Tab

• New & Open
• Saving
• Printing

Topic 10 - Options

• Share, Export, & Options
• Formula Options
• Proof & Save Options
• Language & Advanced Options
• Copy Paste & Chart Options
• Display Options
• Formula & Calculation Options
• Toolbar Options & Add-ins

Topic 11 - Math

• Simple Math
• Functions Using Cells
• Using Parenthesis
• Sum & Average
• Min, Max, Absolute Value
• Trig Functions
• Inverse Trig
• Convert
• Degrees & Radians
• Exponential Function
• Future Value
• Future Value Example
• Present Value
• Complex Numbers
• Logarithms
• Square Root

Topic 12 - Data Set Functions

• Correlate
• Count & Countblank
• Greatest Common Denominator
• If Function
• Info
• Least Common Multiple
• Median
• Mode
• Slope
• Standard Deviation
• Random Number
• Randbetween
• Rounddown & Roundup

Topic 13 - Graphs & Charts

• Inserting Graphs
• Vertical Formatting
• Manage Graph Data
• Using Select Data Source
• Modifying Graphs
• More Axis Options
• Graphing Equations
• Improving Graph Display
• Additional Graph Features
• Changing Chart Types

Topic 14 - Tables & Data

• Formatting Tables
• Cell Borders
• Excel Tables
• Excel Table Freeze Pane
• Excel Table Sorting
• Trendlines

Topic 15 - Example Sheets

• Timesheet Setup
• Timesheet Calculation
• Equation Example
• Equation Example With Name Manager
• Equation Calculation
• Dragging Calculations
• Timeplot Profiles
• Matrix Math
• Complex Calculation Example

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Office 365 Online Versions-3035530865

Description

What you will learn:

• Office 365 versions and features
• Bullets, numbering and styles
• Data entry and navigation
• Screen layout
• Configuring Outlook online
• One Note Desktop

Why study online?

Technological improvements and advances in educational design mean that studying online is no longer just a low-cost alternative to traditional training methods. In many respects, our online courses offer training which is superior to the majority of available “classroom” options.

Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online make it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.

Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.

Curriculum for the Microsoft Office 365 Online Versions course:

What Is Microsoft 365?
Introduction to 365
A Little Background on MS Office
Office 365 Versions and Features - Part 1
Office 365 Versions and Features - Part 2
Online Sign-Up

Word Online
Word Online Overview
Starting a document in Word Online
Word saved to OneDrive
Navigating
Tools and Features
Fonts Attributes - Part 1
Fonts Attributes - Part 2
Lines and Paragraphs - Part 1
Lines and Paragraphs - Part 2
Bullets, Numbering and Styles - Part 1
Bullets, Numbering and Styles - Part 2
Inserts, Pictures and Tools - Part 1
Inserts, Pictures and Tools - Part 2
Tables and Formatting - Part 1
Tables and Formatting - Part 2
Sharing and Templates - Part 1
Sharing and Templates - Part 2

Excel Online
Excel Online Overview
Getting Started with Excel
Data Entry and Navigation
Data Entry - Part 1
Data Entry - Part 2
Data Entry and Formatting - Part 1
Data Entry and Formatting - Part 2
Intro to Formulas
Formulas - Part 1
Formulas - Part 2
Formulas - Part 3
Intermediate Formula and Table Format - Part 1
Intermediate Formula and Table Format - Part 2
More Formula and Charts - Part 1
More Formula and Charts - Part 2
Charts
Sheets and Templates

PowerPoint Online
What is PowerPoint?
Screen Layout
Entering and Formatting Text
Layouts and Designs - Part 1
Layouts and Designs - Part 2
Inserting Objects around
Objects and Transitions
Animations
Smart Art
Notes Printing and Templates

Outlook Online
Intro to Outlook Online
Intro to Email Accounts Screen Layout
Configuring Outlook Online
Sending Emails Outlook Online
Organization Outlook Online
Mail Rules in Outlook Online
Additional Mail Options in Outlook Online
Spam & Junk Outlook Online

One Note Online
What is one Note?
One Note Screen Overview
One Note Desktop
Drawing Tools with One Note
Send to One Note
Media with One Note

Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Office Specialist with Career Program-3035530865

Description

Course syllabus

1. Microsoft Office Specialist (MOS) 77-725: Word 2016 (1 EXAM)
2. Microsoft Office Specialist (MOS) 77-727: Excel 2016 (1 EXAM)
3. Microsoft Office Specialist (MOS) 77-729: PowerPoint 2016 (1 EXAM)
4. Microsoft Office Specialist (MOS) 77-731: Outlook 2016 (1 EXAM)
5. Microsoft Office Specialist (MOS) 77-730: Access 2016 (1 EXAM)

COMPLETE THE ENQUIRY FORM TO SEE A FULL BREAKDOWN OF THE COURSE SYLLABUS

Features of GMetrx system included in this course

GMetrix practice tests for MOS certification are designed to replicate the certification exam experience so test-takers can better prepare themselves for test day. The online practice tests use the same exam format as the certification exams and are mapped to the certification objectives so a test-taker is assured that he/she is learning and practicing the skills that will help him/her pass the certification exam. The student may take up to 100 MOS practice tests within a 12 month period.

Key Features:

• GMetrix accurately replicates a “live application” testing environment.
• Enhances learning through self-paced practice questions.
• Builds familiarity with the testing environment.
• Enhances confidence towards certification exams.
• Better prepares students to pass certification exams.

GMetrix test modes explained

Testing Mode:

Students experience what the certification exams will be like. Timed practice test present scenario to perform just like the actual certification exam.

Training Mode:

Students work at their own pace as they receive feedback and step-by-step instructions for each question. The practice test titles available in your bundle include:

1. MS Excel 2016
2. MS Word 2016
3. MS PowerPoint 2016
4. MS Access 2016
5. MS Outlook 2016

How long do I have to complete the course?

You have 12 months to complete the courses and take the exams.

Who is this course for?

• Anyone looking to gain a series of Microsoft Office Specialist certifications.
• Anyone looking to secure a job role based around Microsoft Office.
• Anyone looking to upgrade their Microsoft Office skills.
• Anyone looking to utilise our Career Program and get Microsoft Office Specialist certified.

Career path

• Administrative Assistant
• Executive Assistant
• Administrative/Office Manager
• Personal Assistant (P.A.)
• Secretary/Receptionist
• Microsoft Office Trainer
• Desktop Designer
• Data Entry Officer
• Bookkeeper
• Excel Administrator
• Excel Analyst
• Excel Data Analyst
• Excel Specialist
• PowerPoint Designer
• PowerPoint Specialist
• Word Specialist

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Querying Microsoft SQL Server 2012 (Microsoft 70-461 Course) -3035530865

Microsoft 70-461: Querying Microsoft SQL Server 2012

What will I learn?

• Create Database Objects
• Create and alter tables using T-SQL syntax (simple statements).
• Create and alter views (simple statements).
• Design views.
• Create and modify constraints (simple statements).
• Create and alter DML triggers.
• Work with Data
• Query data by using SELECT statements.
• Implement sub-queries.
• Implement data types.
• Implement aggregate queries.
• Query and manage XML data.
• Modify Data
• Create and alter stored procedures (simple statements).
• Modify data by using INSERT, UPDATE, and DELETE statements.
• Combine datasets.
• Work with functions.
• Troubleshoot & Optimise
• Optimise queries.
• Manage transactions.
• Evaluate the use of row-based operations vs. set-based operations.
• Implement error handling.

Why not try the training before you buy

Get access to a free trial of the course, explore different learning segments and get an exact idea how the training is delivered.

Credit towards the new MCSA SQL Server 2012

ITonlinelearning’s courses follow official Microsoft curriculum and Microsoft 70-461 Querying Microsoft SQL Server 2012 course contributes a credit toward the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification, which ITonlinelearning also offers.

What do I Get?

• Expert, instructor-led training delivered via video streaming
• Extensive demonstrations and presentations delivered in a multimedia format
• Practice tests and full exam simulators
• Unlimited access to the course for 1 year

What Next?

Enquire today! Our Advisors can answer any questions you have and set up your learning page as soon as you are ready to start your studies.

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Expert-3035530865

Description

Course Content

Lesson One: Using AutoFill, carrying out date calculations, adding a picture as a watermark, creating and working with tables, converting text to columns, removing duplicates, using Flash Fill, consolidating data, using paste special, creating a custom format

Lesson Two: Defining, using and managing named ranges, using named ranges in formulas, inserting, modifying and removing hyperlinks, formatting elements of a column and pie charts, saving a chart as a template, creating combination chart, using functions: ROUND; SUMIF; SUMIF; IF; IFERROR; AND, using the IF function nested with OR

Lesson Three: Using conditional formatting, editing a conditional formatting rule, using the Rules Manager, formatting cells meeting a specific condition, applying more than one conditional formatting rule, sorting data using cell attributes, filtering data.

running a macro from the Quick Access Toolbar, deleting macros, using data validation, tracing precedent/dependent cells in a worksheet, evaluating formulas, tracing errors.

Lesson Five: Summarising data using subtotals, using database functions, grouping and ungrouping data, creating a pivot table, refreshing pivot table data, filtering information in a pivot table, formatting pivot table data, creating and using a slicer, formatting a slicer, creating and using a timeline, using recommended pivot tables

Lesson Six: Using the VLOOKUP function, inserting an embedded object into a spreadsheet, inserting a linked object into a spreadsheet, using paste special to create a link between programs, linking Excel workbooks, using the scenario manager, setting up data tables

Lesson Seven: Protecting worksheet cells, applying and removing passwords, setting file properties, sharing workbooks, merging workbooks, tracking changes, accepting or rejecting changes, using the Document Inspector, marking a workbook as final

Lesson Eight: Using statistical functions: COUNTA, COUNTBLANK, COUNTIF, using text functions: PROPER, UPPER; LOWER, TRIM, LEFT, MID, RIGHT, CONCATENATE, using financial functions: PV; NPV; RATE, using nested functions

Whatsapp: +923035530865, 03219606785, 3315145601,

03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad