Hire a Tutor
Search

Online Courses

Filter

MyPrivateTutor brings to you live online tutoring and courses from expert tutors and training institutes on a huge variety of topics. Whether you need tuition on Maths or want to learn Programming, you can find a tutor or center offering live online lessons on MyPrivateTutor.

1 to 25 of 26 Courses
Show per page
Introduction to Microsoft Excel 2013

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

Conducted by an expert in the finance sector, Chad Wambolt, this is a step-by-step online course to master Microsoft Excel 2013. Anyone who wishes to develop a complete understanding of the concepts of Microsoft Excel 2013 can attend this course. After completing this course, students will gain a complete understanding of the concepts covered and implement those effectively.

Topics Covered

The topics covered in this course include:

Week 1
•    Wednesday - Lesson 01

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

•    Friday - Lesson 02
In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Week 2
•    Wednesday - Lesson 03

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2013. By the time you finish this lesson, you'll really start to feel like an Excel pro.

•    Friday - Lesson 04

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Week 3
•    Wednesday - Lesson 05

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

•    Friday - Lesson 06

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Week 4
•    Wednesday - Lesson 07

In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

•    Friday - Lesson 08
Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Week 5
•    Wednesday - Lesson 09

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

•    Friday - Lesson 10
We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Week 6
•    Wednesday - Lesson 11

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

•    Friday - Lesson 12

I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.
 

Who can Join

Anyone who wishes to develop a complete understanding of the concepts of Microsoft Excel 2013 can attend this course.

Introduction to Microsoft Excel 2010

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

Conducted by an expert in the finance sector, Chad Wambolt, this is a course on Microsoft Excel 2010 to guide you through the basics of Excel in step-by-step details. Anyone who wishes to learn the various concepts of Microsoft Excel 2010 can attend this course. After completing this course, students will learn how to use Microsoft Excel tools effortlessly.

Topics Covered

The topics covered are as follows:

Week 1
•    Wednesday - Lesson 01

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

•    Friday - Lesson 02
In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Week 2
•    Wednesday - Lesson 03

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also cover the art of file management in this lesson, so you'll have no trouble saving, retrieving, printing, and emailing your worksheets, or copying, renaming, and even deleting files. By the time you finish this lesson, you'll really start to feel like an Excel pro.

•    Friday - Lesson 04

Do you know the difference between a relative reference, an absolute reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Week 3
•    Wednesday - Lesson 05

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you will join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

•    Friday - Lesson 06
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a database in Excel, you'll also learn how to subtotal, sort, and filter.

Week 4
•    Wednesday - Lesson 07

In this lesson and the next, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

•    Friday - Lesson 08
Today, we'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart, the bubble chart, and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings, and you'll discover the best ways to print or otherwise display the truly impressive charts that you'll be creating.

Week 5
•    Wednesday - Lesson 09

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

•    Friday - Lesson 10

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Week 6
•    Wednesday - Lesson 11

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how macros can be used to reduce just about any complex task to a single keystroke.

•    Friday - Lesson 12

I think you'll be intrigued by our final lesson, in which you'll teach Excel not only how to make decisions, but also how to act upon those decisions. We'll use a special function in Excel that allows it to make comparisons and use that comparison as the basis for important decisions.

Who can Join

Anyone who wishes to learn the various concepts of Microsoft Excel 2010 can attend this course.

Exclusive Online Training On Autodesk Revit Architecture 2015.

By:   Mostafa Saber

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Others
  • Schedule:
    Not Scheduled Yet

Course Details

The course is intended to introduce BIM concepts to the students.

Topics Covered

The following topics will be covered.

Lecture 1: Getting Started
User Interface, Navigation, Creating different types of elements 

Lecture 2: Building Exterior
Modeling Basic Elements + Deep Understanding of Walls + Loading Families + Groups

Lecture 3: Inside the Building
Building Interior Components (Shafts & Stairs) + Curtain Walls + Modifying Tools

Lecture 4: Inside the Building 2
Stairs & Railing + Floors + Constraints & Dimensions

Lecture 5: Inside the Building 3
Roof + Ceiling + Structural Elements + Area & Room Plans

Lecture 6: Producing Project Drawings 1
Schedules & Tagging + Annotations + Site Tools

Lecture 7: Producing Project Drawings 2
Visual Styles + Sheets + Printing & Publishing + Importing & Exporting Files

Lecture 8: Families & Rendering
Creating Families (in place) + Rendering & Walkthroughs

Who can Join

 If you are working in design or construction industry, you'll find one or more of the above is what you need. My students come from varying backgrounds:

  • Architecture / Interior Design Students
  • Real-Estate Owners & Developers
  • Architectural & Engineering Consultants
  • Contracting Companies
  • Project Owners
  • Government Authorities

Intermediate Microsoft Excel 2010

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

In these hands-on lessons, you'll learn how to create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools and so much more. Anyone who wishes to learn the concepts of Excel can attend this course. By the end of this course, you'll discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Topics Covered

A new session of each course starts monthly. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.

Week 1
•    Wednesday - Lesson 01
In our first lesson, you'll discover why Excel 2010 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So today, you'll find out how to choose the right chart for telling your story, and then how to create, format, and edit your chart to help others clearly visualize that story.

•    Friday - Lesson 02
There are so many great charting features and enhancements in Excel 2010, there's no way we could cover all of them in a single lesson. So today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself.

Week 2
•    Wednesday - Lesson 03
Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

•    Friday - Lesson 04
Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

Week 3
•    Wednesday - Lesson 05
Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

•    Friday - Lesson 06
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using a new Excel 2010 PivotTable filtering tool called Slicer.

Week 4
•    Wednesday - Lesson 07
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

•    Friday - Lesson 08
There's nothing more exciting than learning how to master a new feature in Excel.  In Excel 2010, Microsoft added a thrilling new feature called Sparklines.  In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each.  By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office.  If you enjoy creating charts, you'll really enjoy this lesson.

Week 5
•    Wednesday - Lesson 09
Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

•    Friday - Lesson 10
If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Week 6
•    Wednesday - Lesson 11
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of Excel 2010's new functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

•    Friday - Lesson 12
Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Who can Join

Anyone who wishes to learn the concepts of Excel can attend this course.

Introduction to Microsoft Word 2010

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

This course is a step-by-step guide designed to provide you with comprehensive training on the fundamentals of the Word processor that has been ranked by the PC Magazine as one of the “strongest and most intelligent programs ever written.” Anyone interested in joining or presently employed in a profession that involves working with Word on a frequent basis can benefit by attending this course. After completing this course, students will be able to develop a thorough understanding of Word and utilize it more confidently at home or at work.

Topics Covered

The topics covered in each new monthly session include:

Week 1

Wednesday - Lesson 01
•    Introduction to Word
•    Typing a Word Document

Friday - Lesson 02
•    Document Navigation

Week 2


Wednesday - Lesson 03
•    Basic File Management

Friday - Lesson 04
•    Editing Documents
•    Cutting and Pasting

Week 3

Wednesday - Lesson 05
•    Working With Multiple Documents

Friday - Lesson 06
•    Text Formatting and Alignment

Week 4

Wednesday - Lesson 07
•    Printing

Friday - Lesson 08
•    Margins, Tabs, and Page Numbering

Week 5

Wednesday - Lesson 09
•    Indentation
•    Paragraph Formatting

Friday - Lesson 10
•    Language Tools

Week 6

Wednesday - Lesson 11
•    Customizing Word

Friday - Lesson 12
•    Advanced File Management

Who can Join

Anyone interested in joining or currently employed in a profession that involves working with Word on a frequent basis can attend this course.

Intermediate Microsoft Excel 2013

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

Conducted by Finance professional and teacher, Chad Wambolt, this hands-on course on Microsoft Excel 2013 will train you how to how to create informative, eye-catching charts and graphs and harness the power of Excel's data analysis tools, AutoFilter commands and more. Upon completion of this course, the skills you would acquire would add muscle to your repertoire and would help you immensely in landing a good job.

Topics Covered

The topics covered in this course include:

Week 1

•    Wednesday - Lesson 01
In the first lesson, you'll discover why Excel 2013 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, today, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story.

•    Friday - Lesson 02
There are so many great charting features and enhancements in Excel 2013, there's no way we could cover all of them in a single lesson. So, today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself.

Week 2

•    Wednesday - Lesson 03
Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

•    Friday - Lesson 04
Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

Week 3

•    Wednesday - Lesson 05
Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

•    Friday - Lesson 06
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel 2013 PivotTable filtering tool called Slicer.

Week 4

•    Wednesday - Lesson 07
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

•    Friday - Lesson 08
There's nothing more exciting than learning how to master a new feature in Excel. In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboardlike mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson.

Week 5

•    Wednesday - Lesson 09
Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

•    Friday - Lesson 10
If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Week 6

•    Wednesday - Lesson 11
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

•    Friday - Lesson 12
Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Who can Join

Anyone who wishes to take their Microsoft Excel 2013 concepts to the next level can attend this course.

SAT/ACT Preparation - Part 1

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Others
  • Schedule:
    Not Scheduled Yet

Course Details

This course is a step-by-step guide designed to prepare you for the SAT and the ACT tests that are a part of the evaluation package for applicants for universities and colleges throughout the U.S. Both the ACT and the SAT contain verbal and math question categories and this course provides all the information required to do well on these questions. This course also provides you with suggestions on time management, anxiety relief, scoring, and general standardized test-taking; along with weekly assignments to assess your newfound knowledge. Completing this course will prepare you to excel in all sections of your undergraduate college entrance exams and enable you with the means to achieve your best potential score

Topics Covered

The topics covered in each new monthly course session include:

Week 1
Wednesday - Lesson 01

•    Understanding the general makeup of both the ACT and SAT so you’ll know exactly what you’re getting into on the test day.
•    Learning how to relax when you start feeling panicky, how to eliminate wrong answers that the tests try to entice you into choosing, how to guess when you aren't sure of the right answer, and how much time to spend on each question.
•    Becoming more familiar with the kinds of questions that test your verbal skills.

Friday - Lesson 02

•    Developing the tools you need to develop your own personal reading strategy.
•    How to glide through even the most tiresome reading topics by focusing on what’s important and ignoring what isn't.
•    How to eliminate answers that hook other unprepared test-takers.
•    How to spot the distracters the test-makers use to make wrong answers seem right.

Week 2
Wednesday - Lesson 03

•    Exploring the ACT reading comprehension passages that have appeared on past tests to give you a step-by-step approach for getting the most information from the passages in the least amount of time.
•    Practicing your skills on actual ACT reading test questions and getting the opportunity to discuss your efforts with your instructor and other classmates.

Friday - Lesson 04
•    Rehearse for your SAT passage reading performance by completing practice tests created by actual SAT test-makers.
•    Understanding the most efficient way to read through SAT passages and getting a detailed analysis of reading questions.
•    Understanding just what a question is looking for and how to weed through all of the possible answer choices to pick out the right ones.  

Week 3
Wednesday - Lesson 05

•    Exploring the SAT sentence completion questions that test your reading ability and your knowledge of vocabulary.
•    How to improve your vocabulary without memorizing boring word lists.
•    Understanding the tactics you need to dissect each sentence to extract its exact meaning so you'll know just what answer choice makes it whole.

Friday - Lesson 06
•    Review the grammar rules that are most commonly tested on the ACT and SAT.
•    Focus on the kinds of errors the tests like to see if you know, especially the ones you might be least familiar with, and learn how to spot them and correct them. 

Week 4
Wednesday - Lesson 07

•    How the ACT tests your knowledge.
•    Detailed understanding of how to approach ACT English questions.
•    Understand what you need to pay attention to and what you can disregard when you’re examining each of the paragraphs for errors. 

Friday - Lesson 08

•    How to tackle each of the three different multiple-choice question types to test your grammar and English usage skills in SAT.
•    Learn what types of errors crop up most commonly in the identifying errors questions so you can focus your attention on what’s important.
•    Understand how you can spot errors in the improving sentences questions just by noticing what types of words are underlined in the questions.
•    Learn which questions are best to skip if you notice that you’re running short of time.

Week 5
Wednesday - Lesson 09

•    Learn how to develop a specific plan for writing a complete analysis of a topic within a specified time period. This has become important as writing an essay is a new skill tested on the ACT and SAT. 
•    Learn how you can put your thoughts together in a cohesive and interesting essay. 

Friday - Lesson 10

•    How to compose a sample essay and share it with your instructor and classmates for review.
•    Get the chance to read what other test-takers write and provide them with your enlightened commentary!

Week 6
Wednesday - Lesson 11

•    Exploring in detail the science questions on the ACT that involve more reading than calculating.
•    How to excel on questions that test your verbal skills.
•    How to accurately read graphs and charts.
•    How to extract a bunch of information about experiments without wasting too much time on reading through the unnecessary material.

Friday - Lesson 12
•    Review all of the tips and strategies you’ll need to know to do your best on the verbal questions on the ACT and SAT.
•    Understand the elements of each question type, review what you should focus on, and learn how to best spend your study until you enter the exam site and appear for it.

Who can Join

Anyone who is interested to prepare for the SAT and the ACT tests that are a part of the evaluation package for applicants for universities and colleges throughout the U.S. can attend this course.

Introduction to Microsoft Excel 2013

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS Office
  • Schedule:
    Not Scheduled Yet

Course Details

Do you work with numbers? Then you need to master Microsoft Excel 2013—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.

Topics Covered

Week One

 Lesson 01

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

 Lesson 02

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Week Two

 Lesson 03

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2013. By the time you finish this lesson, you'll really start to feel like an Excel pro.

 Lesson 04

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Week Three

 Lesson 05

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Lesson 06

No, Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Week Four

Lesson 07

In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 08

Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Week Five

Lesson 09

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Lesson 10

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Week Six

Lesson 11

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Lesson 12

I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Who can Join

Anyone who is interested.

Introduction to Microsoft Access 2013

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    MS SQL
  • Schedule:
    Not Scheduled Yet

Course Details

Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2013 to organize, store, edit, manage, and report on hundreds of thousands of records.

Topics Covered

Week One

 Lesson 01

In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database . . . including all the components that turn a list of records into reports, forms, and queries. We'll start by opening the application and creating a new database.

Lesson 02

It's time to lay down the law! Today you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. Also, you'll set up rules that require allowing only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-free.

Week Two

 Lesson 03

Today you'll create additional tables for our class database, customizing them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.

 Lesson 04

In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also determine form layout.

Week Three

Lesson 05

In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms . . . which paves the way to creating queries and reports that draw data from more than one table.

 Lesson 06

Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. You'll follow the instructions step by step so you gain confidence with the process; then I'll turn you loose to create a query on your own.

Week Four

 Lesson 07

A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you a true power to search your database.

 Lesson 08

In this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports.

Week Five

 Lesson 09

Reports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database.

 Lesson 10

In this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple.

Week Six

 Lesson 11

In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.

 Lesson 12

Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

Who can Join

Anyone who is interested.

Performing Payroll In QuickBooks 2014

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    Business Training
  • Subject:
    HR/Personnel
  • Schedule:
    Not Scheduled Yet

Course Details

Preparing payroll in any small business can be a daunting task. Whether you have one employee or 20, the federal and state requirements are often the same! However, by using the payroll feature in QuickBooks 2014, you can master efficient techniques for creating paychecks, paying taxes, and generating forms and reports quickly and easily.

Topics Covered

Week 1

Wednesday - Lesson 01

The payroll process is much more than just printing paychecks. In fact, before you even attempt to process payroll in QuickBooks, you need to have a good understanding of tax withholding requirements and reporting deadlines, among other things. In this first lesson, you'll learn where to find the information you need to comply with both federal and state payroll requirements, how to apply for an Employer Identification Number (EIN), and how to use government websites to get answers to any payroll questions. You'll even find out how to properly classify workers as employees or independent contractors.

Friday - Lesson 02

One of the key advantages of processing payroll in QuickBooks is that the program automatically calculates and fills in federal and state tax withholdings on each paycheck. Subscribing to one of Intuit's payroll services ensures that you always have the most up-to-date tables and forms. In this lesson, we'll identify the differences between Intuit's payroll services so that you can choose the best payroll service for your situation. Also, we'll talk about the support resources available from both Intuit's website and other professionals who use the product.

Week 2

Wednesday - Lesson 03

In this lesson, we'll go through a checklist of the information you'll need to gather and enter into your QuickBooks file before creating paychecks for your employees. You'll also learn how to utilize the Payroll Preferences feature in QuickBooks to customize the program to your business situation. Finally, we'll go over why Payroll Items are so important to QuickBooks and how you can use these items to track every paycheck addition or deduction.

Friday - Lesson 04

Making a simple mistake, like entering an incorrect allowance for an employee's federal tax withholding, will result in an incorrect paycheck. In this lesson, you'll learn how to avoid these kinds of mistakes by carefully entering your employees' information from the paperwork you gathered in the previous three lessons. We'll walk through how to enter personal information, such as addresses, phone numbers, and Social Security numbers. Finally, you'll find out how to create defined fields and enter tax withholding amounts and employee sick and vacation time.

Week 3

Wednesday - Lesson 05

If you decide to start producing paychecks in QuickBooks midyear, you'll need to enter some year-to-date information to let QuickBooks know what payroll transactions have transpired since the beginning of the year. Today, you'll learn about entering year-to-date payroll information and using the QuickBooks year-to-date wizard to summarize each employee's information. In addition, you'll find out how to summarize and enter the tax liabilities you already paid earlier in the year and how to generate certain payroll reports to check your data entry.

Friday - Lesson 06

If you have employees who are assigned to work on specific projects and you need to track how much time they spend on those projects, then QuickBooks has some options for you. In this lesson, you'll discover how to enter and track employee time in QuickBooks. You'll see how to enter employee time using either the Stopwatch, Timer program, or the Weekly/Single Activity Timesheets. Depending on your situation, one of these methods will be most effective for entering and reporting employee time data. You'll also learn how to assign employee time to the jobs you've created in QuickBooks so that you can produce valuable job costing reports.

Week 4

Wednesday - Lesson 07

Now that you've completed the payroll setup process, today you'll learn how to create a new paycheck for an employee using a Payroll Schedule. We'll also discuss how to create paychecks using information entered on a time activity form, and how to review, correct, and, if necessary, void or delete a paycheck. And if you have to provide paper copies of a paycheck or pay stub, you'll find out how to review them for accuracy and then print them.

Friday - Lesson 08

Every company that has employees is responsible for certain payroll liabilities. Luckily, QuickBooks has a Scheduled Payments feature that allows you to create reminders of when to pay these liabilities, and that's what we'll explore today. You'll learn how to e-file liability checks and create printed liability checks that include assessed penalties. Since you don't always pay Payroll liabilities to governmental agencies, you'll also find out how to use the payroll feature to track and pay other payroll items, such as health insurance premiums and 401(k) contributions. By the end of this lesson, you'll understand how to adjust the balances due for each payroll tax item and record a refund of payroll taxes.

Week 5

Wednesday - Lesson 09

No payroll process is complete until you've created paychecks and paid tax liabilities. Along with paying your liabilities, you must prepare and file important quarterly and annual reports with the government. To get a handle on this crucial responsibility, today you'll learn QuickBooks' easy-to-follow steps for generating and revising Federal Forms 941 and 940. And to make sure your information is accurate, we'll cover how to review your entries and compare them to the payroll data in your QuickBooks company file.

Friday - Lesson 10

In this lesson, we'll explore one of the more powerful features of the payroll process in QuickBooks: the reporting feature. After completing this lesson, you'll know how to access and generate several of the preformatted payroll reports in QuickBooks. To help you avoid costly errors, you'll learn how to use these reports to review payroll data, identify errors, and even forecast future payroll obligations.

Week 6

Wednesday - Lesson 11

Benjamin Franklin once said, "In this world nothing can be said to be certain, except death and taxes." That saying still holds true! So to help you with the inevitable task of paying taxes, QuickBooks gives you the ability to generate Forms W-2 and W-3. The government requires employers to submit these summary reports to each employee and to the Social Security Administration. You'll also need to submit Forms 1099 to your independent contractors. In this lesson, not only will you see how to create these forms, but also you'll discover the best methods for reviewing them and making any necessary adjustments. Finally, we'll cover how to properly align the forms so that the payroll information shows up in the right places when you print them.

Friday - Lesson 12

We'll spend our last lesson helping you avoid and correct the most common mistakes QuickBooks users make when processing payroll. For instance, you'll learn what to do if too many payroll accounts were created in the Chart of Accounts. You'll also find out what steps to take if you didn't use the Scheduled Payments or Pay Liabilities windows correctly. We'll even cover the proper way to enter and track employee loans. At the end of the day, you'll be ready to process payroll in QuickBooks and solve many of the problems that can pop up along the way.

Who can Join

Anyone who is interested

Introduction To Crystal Reports

By:   Ed2go

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    AutoCAD
  • Schedule:
    Not Scheduled Yet

Course Details

Want to "wow" people with your business reports? In this course, you'll master the techniques the pros use to produce attractive, reader-friendly reports for any audience.

Topics Covered

Week 1

Wednesday - Lesson 01

Crystal Reports is the world's most popular software tool for creating reports based on data stored in databases. It's popular because of its power and flexibility, which will help you create reports that communicate the information you want to convey to the people you want to convey it to. In our first lesson, you'll learn why it's important to find out everything you need to know about the report you want to create before you even launch the Crystal Reports application. This advance planning gives you a much better chance of creating a report that achieves your objectives.

Friday - Lesson 02

In this lesson, we'll hit the ground running and create a Crystal Report from scratch. From Lesson 1, you already know how to connect to a data source. Today, you'll learn how to pull data from that data source and place it into your report. Then, I'll show you how to use Crystal Reports to create a quick, simple report with a professional appearance—adding headers and footers, and adjusting column headings and the data itself. We'll also discuss how to arrange all of these items on a page for maximum visual impact. By the end of this lesson, you'll know how to create a simple report!

Week 2

Wednesday - Lesson 03

Once you know how to pull data from a database and display it in a basic report, the next step is to pull data from multiple database tables and display only the data you want, filtering out any irrelevant information. In this lesson, you'll learn how to perform these functions, and I'll also show you how to build reports that allow users to decide at runtime what to display. In effect, you can build one report that serves the purpose of multiple reports!

Friday - Lesson 04

Displaying the information in a database is one thing; displaying it in a way that communicates effectively is another. In today's lesson, we'll review how to enhance communication by organizing a report's data in a meaningful way, and you'll learn how to use Crystal Reports to sort data and group related data items together. You'll discover how to summarize numerical data with group totals and how to obtain an overall grand total. And we'll also look into the drill-down capability of Crystal Reports, which allows your report readers to use a simple mouse click to access suppressed details of a specific data group!

Week 3

Wednesday - Lesson 05

In this lesson, you'll dive into the details of the various report sections. First, we'll discuss how to resize sections, and then we'll take a close look at the Section Expert, which is your major tool for selecting options that control the appearance and function of the various sections of a report. We'll also explore how you can control the placement of groups, reset page numbering, and move report totals. Finally, we'll take a closer look at the drill-down feature and hiding details.

Friday - Lesson 06

Today, you'll get even more hands-on experience formatting a report. First, we'll look at a number of formatting options that Crystal Reports offers to help you give your report just the look you want. Then, we'll look at how you can use report templates to achieve a consistent appearance across a family of reports. And finally, we'll practice using absolute formatting and conditional formatting, features that can adjust the appearance of your report based on the data it contains.

Week 4

Wednesday - Lesson 07

With Crystal Reports, you can do more than just display the data you select from your data source. You can also show correlations between related categories of data items. To do this, you create a cross-tab report, which can show such correlations across the entire data set or within a selected group of data items. As usual, Crystal Reports provides considerable flexibility in how it presents the cross-tab data to users. In this lesson, you'll learn what the options are and how to use them.

Friday - Lesson 08

You'll often need to create a report based on some, but not all, of the data in a database. For example, a sales manager may want to look only at the purchase records of her top five customers. Alternatively, she may want to view the performance of her bottom 10 salespeople. Crystal Reports makes it easy to produce such reports, as well as others that are selective about what they display. In this lesson, you'll create such targeted reports that make it easy for managers to make informed decisions.

Week 5

Wednesday - Lesson 09

The formulas and control structures in Crystal Reports allow you to make your reports dynamic, sensitive to what's happening at runtime. With formulas, you can operate on data and put the result into your report. You can also save time and effort by including one or more of the predefined functions in your formulas. You can even create your own custom functions, save them, and use them both now and in the future. These facilities give you the flexibility to produce a sophisticated custom report with very little time and effort. And you'll find out how to do all of this in today's lesson.

Friday - Lesson 10

Crystal Reports gives you the ability to embed one report inside another. The two reports can be related in some way, or they can be completely unrelated. As long as you have a reason for displaying both reports at once, you can do it, and you'll find out how in today's lesson. We'll also practice embedding hyperlinks today. This can be a great alternative to embedding a subreport within a main report!

Week 6

Wednesday - Lesson 11

Charts and maps can add visual dimension to the display of information in a report. While columns of numbers may be an effective way to present data for some readers, you may have visual learners in your target audience who would be better served by charts and maps. Today, you'll learn how to choose a chart type that best conveys the information you want to emphasize. And you'll find out how to use color, font, scale, legends, and titles to help you highlight trends in the data or data points that fall outside of the expected range.

Friday - Lesson 12

After you've created a report, you need to distribute it. Crystal Reports gives you several convenient distribution options, and we'll explore all of these in our final lesson. We'll talk about print and fax options, exporting a report to any of a number of popular file formats, and transmitting it to the people who should read it. You'll learn how to post the report on your organization's intranet or the Web, and then we'll discuss distributing reports via Crystal Reports Viewer 2008.

Who can Join

Who are willing to learn

Online Training On Microsoft Project 2013 Pro

By:   Jahan

Be First to Review

  • Fees:
  • Segment:
    Business Training
  • Subject:
    Management Training
  • Schedule:
    Not Scheduled Yet

Course Details

Learn Microsoft Project 2013 and quickly teach yourself how to manage the complete project life cycle with Project 2013.

Topics Covered

 Introduction to Microsoft Project
1. Microsoft Project, project management and you
2. A guided tour of Project
3. Simple Scheduling Basics
4. Starting a new plan
5. Building a task list
6. Setting up resources
7. Assigning resources to tasks
8. Formatting and sharing your plan
9. Tracking progress
10. Overview to Advanced Scheduling Techniques

Who can Join

Beginner / Intermediate

Online Training On Brazilian Portuguese For Beginner

By:   Luiz Colucci

Be First to Review

  • Fees:
  • Segment:
    Language
  • Subject:
    Portuguese
  • Schedule:
    Not Scheduled Yet

Course Details

Brazilian Portuguese or português brasileiro is a set of dialects of the Portuguese language used mostly in Brazil. It is spoken by virtually all of the 200 million inhabitants of Brazil and spoken widely across the Brazilian diaspora, today consisting of about two million Brazilians who have emigrated to other countries.

Topics Covered

1. Pronunciation 

Our first step will be the pronunciation. I want to help you to learn very well the pronunciation of some sounds in Brazilian Portuguese because they will be fundamental to make you feel comfortable to start talking and also to comprehend and identify some sounds while you are listening a song or a Brazilian person talking.

2. Simple Grammar

I want to teach you some simple elements about Portuguese grammar but, at the same time, powerful and very important to start building some sentences by yourself. This will also allow you to start talking with a Brazilian person - doing elementary questions to this person.   

Who can Join

Everyone that wants to start learning Brazilian Portuguese. 

Crash Course On French

By:   Amisha

Be First to Review

  • Fees:
  • Segment:
    Language
  • Subject:
    French
  • Schedule:
    Not Scheduled Yet

Course Details

More than 220 million people speak French on the five continents. The OIF, an international organisation of French-speaking countries, comprises 77 member States and governments. French is the second most widely learned foreign language after English, and the sixth most widely spoken language in the world. French is also the only language, alongside English, that is taught in every country in the world. France operates the biggest international network of cultural institutes, which run French-language courses for close on a million learners. The ability to speak French is an advantage on the international job market. A knowledge of French opens the doors of French companies in France and other French-speaking parts of the world (Canada, Switzerland, Belgium, and the continent of Africa). As the world’s fifth biggest economy and third-ranking destination for foreign investment, France is a key economic partner.

Topics Covered

Below topics will be covered:-
Reading:

Reading comprehensions like poems, passages and literature

Grammar:

Tenses, verbs, pronouns, nouns, direct and indirect speech, active passive voice, using right articles, adjectives, adverbs.

Listening activities:

Audio visual activities on screen and audio Cds 

Writing:

letters, stories, diaries, messages, emails, compositions

Speaking:

daily life situations role-play

Who can Join

This Course is targetted to :

  • Students in the university
  • British curriculum students
  • students planning for further studies in French soeaking countries
  • Candidates willing to migrate to Francophone countries
  • candidates who wish to appear for Delf exams

Course Details

How to learn / trade Forex? How much investment is required? How much profit I can generate / earn (earning potential)? What are the risks involved? What should be the educational background of Forex Trader? Do I need to sell something in market? How much time I need to devote daily? How much maths and English knowledge is required? Can I work from Home? Can I do this with my job or business? How much time it will take to become a Forex Trader?

Topics Covered

Forex Training Workshop – Detailed Curriculum

Pre-lunch Session – Fundamentals of Currency Market

  • Financial market Leverage concept
  • Factors affecting currencies – Economic & Political
  • Data releases & their Impact on GDP and currencies
  • Inflation and its impact
  • Central bank policies and their impact
  • Order management
  • Price quote – Direct & Indirect
  • Denomination and spread
  • Settlement
  • Interest Rate Differential
  • Premium & Discount
  • Post Lunch Session – Technical Analysis of Financial Market
  • Chart Formation
  • Direction and trends
  • Ranges
  • Periodicity
  • Support and resistance
  • Price gaps in market cycle
  • Technical tools and their application
  • Basics of Elliott Wave Principle
  • Basics of Fibonacci Series
  • Technical Continuation Patterns
  • Technical Reversal Patterns
  • Trading Strategies
  • Managing Risk

Who can Join

Anyone above 18 years of age who wants to make money part time by devoting just one hour a day.

Online Training On MS-Project

By:   C. Vikram

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Others
  • Schedule:
    Not Scheduled Yet

Course Details

Microsoft Project is the world's most popular project management software developed and sold by Microsoft. The application is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budgets and analysing workloads.

Topics Covered

MS-Project Topics

Chapter-1

Project management Flow chart of project management

Chapter-2

Project management basic concepts Recording project details in MS-Project Creating tasks in the Gantt Chart

Chapter-3

Successor Predecessor Establishing task relationships Lag Create calendars’ Assign calendars Setting default options

Chapter-4

Scheduling Outlining projects Sorting tasks Milestones

Chapter-5 Assigning constraints

Describe the available constraint types Apply a constraint to an individual activity

Chapter-6 Customizing Bar chart

Modifying Bar charts PERT chart

Chapter-7 Resources

Adding resources Assign resources Expenses Budgeted cost

Chapter-8 Project Utilities

Export project data Import excel file data Create filters Applying project filters Short keys in MS-Project

Chapter-9 Baseline

Create baseline Assign baseline

Chapter-10 updating/tracking

Project progress Enter actual work for resource assignments

Chapter-11 Reports

Reports and views Printing views

Chapter-12 Advanced Topics

Resource CURVE (S-CURVE) Earned value analysis (BCWS/ACWP/BCWP)

Who can Join

Any person can learn the course 

PMP Training Program

By:   Maha Nassar

Be First to Review

  • Fees:
  • Segment:
    Business Training
  • Subject:
    Project Management
  • Schedule:
    Not Scheduled Yet

Course Details

This course is based on the Project Management Institute, A Guide to the Project Management Body of Knowledge, (PMBOK® Guide) - Fifth Edition, Project Management Institute, Inc., 2013. The objective of the course is to prepare students for the Project Management Professional (PMP)® certification examination.

Topics Covered

Introduction to the PMBOK® Guide

A Guide to the Project Management Body of Knowledge (PMBOK® Guide – Fifth Edition)

  • Key terms and the project life cycle
  • Identifying Enterprise Environmental Factors (EEFs) and Organizational Process Assets (OPAs)
  • Organizational structure and influences
  • Mapping the interrelationships of the ten knowledge areas to the five process groups

Project Integration and Scope Management

Identifying and integrating processes and activities

  • Identifying a new project, business case and strategy
  • Defining and coordinating all subsidiary plans
  • Change-control and configuration management

Defining, validating and controlling the scope

  • Facilitating requirements-gathering using interviews, workshops and decision-making techniques
  • Requirements changes and traceability matrices
  • Determining scope through product analysis and Analysis of Alternatives (AoA)
  • Creating the WBS through decomposition
  • Setting the scope baseline and analyzing variances

Project Time and Cost Management

Time management

  • Defining and sequencing activities
  • Estimating activity resources and durations with analogous, parametric and three-point techniques
  • Developing the schedule with PDM, ADM and CDM diagrams

Determining the cost baseline and applying Earned Value Management (EVM)

  • Identifying costs and calculating performance baseline
  • Assessing EVM key dimensions, variances and indices
  • Forecasting with EVM
  • Performance reporting

Project Quality Management

Implementing systems for quality

  • Preventing nonconformance through Cost of Quality (CoQ)
  • Performing continuous improvements

Tools and techniques to study

  • Planning for quality using statistical tools
  • Implementing quality metrics and audits

Project Human Resource, Communications and Stakeholder Management

Developing the plan and acquiring the team

  • Creating hierarchical and matrix charts (RAM & RACI)
  • Developing the team: team building, Tuckman model, recognition and rewards
  • Motivational theories and conflict resolution techniques

Efficiently communicating with stakeholders

  • Distributing information with communication models
  • Applying communication theory and the levels of power

Managing stakeholder engagements

  • Identifying and analyzing stakeholders and their expectations
  • Increasing support and minimizing resistance

Project Risk and Procurement Management

Assessing project risks

  • Qualitative and quantitative risk analysis
  • Evaluating Expected Monetary Value (EMV)

Exam-relevant tools and techniques

  • Developing threat/opportunity response strategies
  • Reassessing and controlling risks

Procurement management

  • Performing make-or-buy analysis
  • Formally accepting the product and closing the project

Planning for the Exam

Preparing for test day

  • Applying proven tips for exam success
  • Conquering exam apprehension

Personalizing your study plan

  • Identifying your strengths and weaknesses
  • Optimizing your study time and focus

Who can Join

Project managers seeking to get the PMP certification 

Business Studies and Management Training

By:   Miss Noor

Be First to Review

  • Fees:
  • Segment:
    High School
  • Subject:
    Business Studies
  • Schedule:
    Not Scheduled Yet

Course Details

Business Studies and Management IB program is extremely thorough, challenging and balanced to prepare students for success at the university level and in the life beyond.

Topics Covered

II. Curriculum model overview Component 

Unit 1: Business organization and environment 

1.1 Introduction to business management

 1.2 Types of organizations 

1.3 Organizational objectives 

1.4 Stakeholders 

1.5 External environment 

1.6 Growth and evolution 

1.7 Organizational planning tools 

Unit 2: Human resource management 

2.1 Functions and evolution of human resource management 

2.2 Organizational structure 

2.3 Leadership and management 

2.4 Motivation

 2.5 Organizational (corporate) culture 

2.6 Industrial/employee relations 

Unit 3: Finance and accounts 

3.1 Sources of finance 

3.2 Costs and revenues 

3.3 Break-even analysis 

3.4 Final accounts 

3.5 Profitability and liquidity ratio analysis 

3.6 Efficiency ratio analysis 

3.7 Cash flow 

3.8 Investment appraisal 

3.9 Budgets 

Unit 4: Marketing 

4.1 The role of marketing 

4.2 Marketing planning (including introduction to the four Ps)

 4.3 Sales forecasting 

4.4 Market research

4.5 The four Ps (product, price, promotion, place) 4.6 The extended marketing mix of seven Ps

4.7 International marketing 

4.8 E-commerce 

Unit 5: Operations management 

5.1 The role of operations management 

5.2 Production methods 

5.3 Lean production and quality management 

5.4 Location 

5.5 Production planning 

5.6 Research and development 

5.7 Crisis management and contingency

Who can Join

Students of age 16 to 19 IB SL and HL level.

Dubai Excel Expert : VBA Macro Automation - All Kind of Reports, Graphs, Charts Solution

By:   Sonu

Be First to Review

  • Fees:
  • Segment:
    Business Training
  • Subject:
    Strategic Marketing
  • Schedule:
    Not Scheduled Yet

Course Details

Macro VBA Automation : All Kind of Reports, Graphs, Charts Solution classes at Dubai

Topics Covered

EXCEL EXPERT: Macro VBA Automation-All Kind of Reports, Graphs, Charts Solution

I am Excel Automation Developer, Not tutor. 

Are you or your organization spending a big amount of time in Excel Reports?

OR

Are you or your organization getting reports in Microsoft Excel with a lot of non-required Data?

OR

Are you getting same Excel Reports but not sure about accuracy due to complex formulas?

OR

Are you or your organization getting Excel reports in tabular formats and If you get same reports in graphical visual, it will be very helpful for you to make progressing decisions?

 

I can provide you Excel Macro powered automation solution for your such requirement. You will get same reports 100% accurate and in graphical view the way you want.

 

COMPLETE MICROSOFT EXCEL SOLUTION FROM YOUR EXISTING OR NEW DATABASE

REPORTING

GRAPHS

CHARTS

AND MANY MORE

 

 

 

 

I hereby introduce myself ( Sonu) as the solution provider for all your needs for reports ( exclusively in Microsoft Excel /Access ) from various departments i.e. accounts, H.R., Sales etc.

 

Halliburton, Emirates Airline, Etihad Airways, HSBC, SCB, Viva telecom are few of my satisfied client base.

 

I am a freelancer and I can provide you my services by working with you on temporary or contract or hourly basis as per your requirement. ( also can work with you permanent )

 

Please check attachment pictures which shows all details about me and few projects completed in a local market.

 

   Time Saving Reports On few Clicks. : In your organization, you might be experiencing the repetition of the same type of work for different reports in Microsoft Excel. I can develop such application in Excel (Using VBA Codes), you can get same reports in few clicks ( based on your available data). Your staff might be spending hours/days for the same kind of reports but different data. I can provide the solution which enables you to get same reports in few clicks (using advanced formulas and VBA Code).

 

 

Project Accomplished :

Client Type: Government Organization –GCC country (Telecommunication service provider) (Client Name withheld as per agreed terms of the contract.)

Project Description: In Microsoft Excel; developed Dashboard using Command buttons, filters & VBA Code, which retrieve data from online 8 Microsoft Excel Files, 25 Sheets, 47 Pivot Tables. (Department: Hiring /Recruitment, Platform: Sniperhire, VBA, Microsoft Excel)

Application Benefit: Now: organization gets the same report in 15-30 minutes by using one normal clerk staff which Before: they were getting in 1 to 2 days from two experts IT and admin staff.

 

 

Ready to use applications (Microsoft Excel Files)

 Bank Cheque Printing: Print your bank cheque in few clicks, maintain cheque data and view/print any time records date-wise, cheque numbers, party-wise, amount-wise, bank-wise and many more reports.

 Dubai Custom Duty Refund Form Printing: Print Dubai Custom duty refund form directly from Microsoft Excel and maintain data and print reports any time.

 Salary Pay Slip: Print employee salary pay slip direct form direct from Microsoft Excel and maintain data and print reports any time.

 Invoice Printing: Print commercial invoice on your letterhead as per your required design and maintain data to view or print any time.

Customized Projects (Microsoft Excel or Microsoft Access)

 

 I also undertake customized projects to prepare valuable reports as per your needs.

 Retrieve records from your existing application (or download from your data server/site)

 convert it into Microsoft Excel format -> Generate reports as per your requirement.

 Design and develop totally new Microsoft Excel files (Powered with advanced formulas and VBA codes) which generate reports as per your requirements and prints as per your preprinted stationery.

 

Should you (or your social network or your business network) be conducting a search for someone with my background – at present or in the near future – I would greatly appreciate your consideration or recommendation. Which can help me to expand my services and products?

 

Thanking you in advance

Excel, Access, Visual Basic, VBA, Macro, Advance, Formula, Vlookup, Hlookup, IF, Ifs, Reports, Repeat, Repetitive, IT, Technology, Solution, Programming, Program, Software, Application, File, xls, xlsm, macro, expert, custom, customized, solve, problem, Visa, employee, payslip, payroll, easy, fast, accurate, quick, Dashboard, Pivot Table, Dashboard, tool.

• HR, H.R., Human Resources, Accounts, Payroll, Software, MIS, Chart, Tool, Manipulation, Data, Mining. KPI, CRM, M.I.S. k.p.i. c.r.m.

• Tool, Graph, Pie, Column, Error, Trouble, Slicer, Graph, Header, Footer, Title, PDF, Word, Mail Merge.

Sep-16

Ledgers Time & Expense  Time & Billing    Expenses Event Management Inventory Control Service Call Management Resource Scheduling Contact Management Project Management

Asset Tracking ERP CRM MS Dynamics MS CRM MS Info path MS Share point Oracle SQL Server Data Migration Data Recovery Client Relationship Management Electronic Forms

Accord Forms  Web Surveys Pivot Table

Aug-2017

Data Analysis Analyst forecasting trend trending forecast trend planning  strategy Data Mining MIS 

Who can Join

EXCEL EXPERT: Macro VBA Automation-All Kind of Reports, Graphs, Charts Solution

I am Excel Automation Developer, Not tutor. 

Are you or your organization spending a big amount of time in Excel Reports?

OR

Are you or your organization getting reports in Microsoft Excel with a lot of non-required Data?

OR

Are you getting same Excel Reports but not sure about accuracy due to complex formulas?

OR

Are you or your organization getting Excel reports in tabular formats and If you get same reports in graphical visual, it will be very helpful for you to make progressing decisions?

 

I can provide you Excel Macro powered automation solution for your such requirement. You will get same reports 100% accurate and in graphical view the way you want.

 

COMPLETE MICROSOFT EXCEL SOLUTION FROM YOUR EXISTING OR NEW DATABASE

REPORTING

GRAPHS

CHARTS

AND MANY MORE

 

 

 

 

I hereby introduce myself ( Sonu) as the solution provider for all your needs for reports ( exclusively in Microsoft Excel /Access ) from various departments i.e. accounts, H.R., Sales etc.

 

Halliburton, Emirates Airline, Etihad Airways, HSBC, SCB, Viva telecom are few of my satisfied client base.

 

I am a freelancer and I can provide you my services by working with you on temporary or contract or hourly basis as per your requirement. ( also can work with you permanent )

 

Please check attachment pictures which shows all details about me and few projects completed in a local market.

 

   Time Saving Reports On few Clicks. : In your organization, you might be experiencing the repetition of the same type of work for different reports in Microsoft Excel. I can develop such application in Excel (Using VBA Codes), you can get same reports in few clicks ( based on your available data). Your staff might be spending hours/days for the same kind of reports but different data. I can provide the solution which enables you to get same reports in few clicks (using advanced formulas and VBA Code).

 

 

Project Accomplished :

Client Type: Government Organization –GCC country (Telecommunication service provider) (Client Name withheld as per agreed terms of the contract.)

Project Description: In Microsoft Excel; developed Dashboard using Command buttons, filters & VBA Code, which retrieve data from online 8 Microsoft Excel Files, 25 Sheets, 47 Pivot Tables. (Department: Hiring /Recruitment, Platform: Sniperhire, VBA, Microsoft Excel)

Application Benefit: Now: organization gets the same report in 15-30 minutes by using one normal clerk staff which Before: they were getting in 1 to 2 days from two experts IT and admin staff.

 

 

Ready to use applications (Microsoft Excel Files)

 Bank Cheque Printing: Print your bank cheque in few clicks, maintain cheque data and view/print any time records date-wise, cheque numbers, party-wise, amount-wise, bank-wise and many more reports.

 Dubai Custom Duty Refund Form Printing: Print Dubai Custom duty refund form directly from Microsoft Excel and maintain data and print reports any time.

 Salary Pay Slip: Print employee salary pay slip direct form direct from Microsoft Excel and maintain data and print reports any time.

 Invoice Printing: Print commercial invoice on your letterhead as per your required design and maintain data to view or print any time.

Customized Projects (Microsoft Excel or Microsoft Access)

 

 I also undertake customized projects to prepare valuable reports as per your needs.

 Retrieve records from your existing application (or download from your data server/site)

 convert it into Microsoft Excel format -> Generate reports as per your requirement.

 Design and develop totally new Microsoft Excel files (Powered with advanced formulas and VBA codes) which generate reports as per your requirements and prints as per your preprinted stationery.

 

Should you (or your social network or your business network) be conducting a search for someone with my background – at present or in the near future – I would greatly appreciate your consideration or recommendation. Which can help me to expand my services and products?

 

Thanking you in advance

Excel, Access, Visual Basic, VBA, Macro, Advance, Formula, Vlookup, Hlookup, IF, Ifs, Reports, Repeat, Repetitive, IT, Technology, Solution, Programming, Program, Software, Application, File, xls, xlsm, macro, expert, custom, customized, solve, problem, Visa, employee, payslip, payroll, easy, fast, accurate, quick, Dashboard, Pivot Table, Dashboard, tool.

• HR, H.R., Human Resources, Accounts, Payroll, Software, MIS, Chart, Tool, Manipulation, Data, Mining. KPI, CRM, M.I.S. k.p.i. c.r.m.

• Tool, Graph, Pie, Column, Error, Trouble, Slicer, Graph, Header, Footer, Title, PDF, Word, Mail Merge.

Sep-16

Ledgers Time & Expense  Time & Billing    Expenses Event Management Inventory Control Service Call Management Resource Scheduling Contact Management Project Management

Asset Tracking ERP CRM MS Dynamics MS CRM MS Info path MS Share point Oracle SQL Server Data Migration Data Recovery Client Relationship Management Electronic Forms

Accord Forms  Web Surveys Pivot Table

Aug-2017

Data Analysis Analyst forecasting trend trending forecast trend planning  strategy Data Mining MIS 

Course in Revit Architecture

By:   Aamir Dewan

Be First to Review

  • Fees:
  • Segment:
    College Level
  • Subject:
    Architecture
  • Schedule:
    Not Scheduled Yet

Course Details

Learning full software all versions Revit architecture 2009 to latest version 2018. 2d and 3d drawings for every building, learn from basic to master level software.

Topics Covered

Installation of software, Beginning with expert level learning, 2d drawing to detail 3d in Revit and rendering 3d in Lumion.

Who can Join

Students, professional engineers, draftsman.

CMA Part 1 & Part 2 Training

By:   Ali Usman

Be First to Review

  • Fees:
  • Segment:
    Exam Preparation
  • Subject:
    CMA
  • Schedule:
    Not Scheduled Yet

Course Details

By attending this course, students will be able to successfully attempt and pass the CMA examinations.

Topics Covered

CMA Part One: Financial Reporting, Planning, Performance, and Control

  • 15%External Financial Reporting Decisions
  • 30%Planning, Budgeting, and Forecasting
  • 20%Performance Management
  • 20%Cost Management
  • 15%Internal Controls

CMA Part Two: Financial Decision Making

  • 25%Financial Statement Analysis
  • 20%Corporate Finance
  • 20%Decision Analysis
  • 10%Risk Management
  • 15%Investment Decisions
  • 10%Professional Ethics

Who can Join

Financial Controller, Finance Managers, Accountants, Chief Accountants, and almost all sort of accounting and finance professionals who want to progress in finance profession by obtaining a renowned finance certification.

Python for Beginners 2018

By:   Simpliv LLC

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Python
  • Schedule:
    Not Scheduled Yet

Course Details

If you're becoming a professional developer, or are early in your development career, adding the Python skill set isn't just a resume embellishment-- It's an empowering language that will allow you to write procedural code in many types of environments and for many uses.

Topics Covered

  • How to use the Python Shell
  • How to use interactive mode in Python
  • How to develop and run programs in the IDLE editor
  • How to run Python scripts directly from the command line
  • How to use the print() function
  • How to use separators and new line characters to modify command line output
  • Assign variables of different types
  • Understand integer, floating point, complex and string variables
  • Be able to extract substrings
  • Easily concatenate strings
  • Create Lists and Tuples

Who can Join

  • First time Python programmers
  • Students and Teachers
  • IT pros who want to learn to code
  • Aspiring data scientists who want to add Python to their tool arsenal

Complete iOS 11 Machine Learning Masterclass

By:   Simpliv LLC

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Machine Learning
  • Schedule:
    Not Scheduled Yet

Course Details

If you want to learn how to start building professional, career-boosting mobile apps and use Machine Learning to take things to the next level, then this course is for you.

Topics Covered

  • Master the 3 fundamental branches of applied Machine Learning: Image & Video Processing, Text Analysis, and Speech & Language Recognition
  • Develop an intuitive sense for using Machine Learning in your iOS apps
  • Create 7 projects from scratch in practical code-along tutorials
  • Find pre-trained ML models and make them ready to use in your iOS apps
  • Create your own custom models
  • Add Image Recognition capability to your apps
  • Integrate Live Video Camera Stream Object Recognition to your apps
  • Add Siri Voice speaking feature to your apps
  • Dive deep into key frameworks such as coreML, Vision, CoreGraphics, and GamePlayKit.
  • Use Python, Keras, Caffee, Tensorflow, sci-kit learn, libsvm, Anaconda, and Spyder–even if you have zero experience
  • Get FREE unlimited hosting for one year
  • And more!

Who can Join

  • People with a basic foundation in iOS programming who would like to discover Machine Learning, a branch of Artificial Intelligence
  • People who want to pursue a career combining app development and Machine Learning to become a hybrid iOS developer and ML expert
  • Developers who would like to apply their Machine Learning skills by creating practical mobile apps
  • Entrepreneurs who want to leverage the exponential technology of Machine Learning to create added value to their business could also take this course. However, this course does assume that you are familiar with basic programming concepts such as object oriented programming, variables, methods, classes, and conditional statements

Machine Learning With Python Course

By:   Simpliv LLC

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Machine Learning
  • Schedule:
    Not Scheduled Yet

Course Details

This course is about Machine Learning with Python Course.

Topics Covered

Python Introduction

  • Introduction to Python   

  • Core programming concepts   

  • Objects in Python   

  • Visualizations in Python  

  • Packages in Python   

  • Matrix operations  

  • Data frames   

Machine Learning

  • Data Pre-processing   

  • Regression   

  • Classification   

  • Clustering   

  • Association Rule   

  • Natural Language Processing

Who can Join

 Programmers, Developers, Technical Leads, Architects, Freshers,Data Scientists, Data Analysts,Business Intelligence Managers.

Data Visualization with Tableau, R and Python Course

By:   Simpliv LLC

Be First to Review

  • Fees:
  • Segment:
    IT Training
  • Subject:
    Python
  • Schedule:
    Not Scheduled Yet

Course Details

This course is about Data Visualization with Tableau, R and Python Course.

Topics Covered

 All the professionals who are passionate about business intelligence, data visualization, and data analytics.

Who can Join

 All the professionals who are passionate about business intelligence, data visualization, and data analytics.

Enquire for a Course. It's FREE!

Tell us your course requirement in detail and get immediate response from our experts

Note: Your 9 digit Mobile Number without +971
Do you offer Tuition? Register Here!
X

We use cookies to help provide you the best experience on our website. By continuing to use our site, you constent to our use of these cookies.
More Information I accept