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.
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.
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.
Anyone who wishes to develop a complete understanding of the concepts of Microsoft Excel 2013 can attend this course.
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.
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.
Anyone who wishes to learn the various concepts of Microsoft Excel 2010 can attend this course.
The course is intended to introduce BIM concepts to the students.
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
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:
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.
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!
Anyone who wishes to learn the concepts of Excel can attend this course.
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.
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
Anyone interested in joining or currently employed in a profession that involves working with Word on a frequent basis can attend this course.
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.
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!
Anyone who wishes to take their Microsoft Excel 2013 concepts to the next level can attend this course.
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
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.
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.
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.
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.
Anyone who is interested.
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.
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.
Anyone who is interested.
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.
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.
Anyone who is interested
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.
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 are willing to learn
Learn Microsoft Project 2013 and quickly teach yourself how to manage the complete project life cycle with Project 2013.
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
Beginner / Intermediate
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.
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.
Everyone that wants to start learning Brazilian Portuguese.
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.
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
This Course is targetted to :
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?
Forex Training Workshop – Detailed Curriculum
Pre-lunch Session – Fundamentals of Currency Market
Anyone above 18 years of age who wants to make money part time by devoting just one hour a day.
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.
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)
Any person can learn the course
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.
Introduction to the PMBOK® Guide
A Guide to the Project Management Body of Knowledge (PMBOK® Guide – Fifth Edition)
Project Integration and Scope Management
Identifying and integrating processes and activities
Defining, validating and controlling the scope
Project Time and Cost Management
Time management
Determining the cost baseline and applying Earned Value Management (EVM)
Project Quality Management
Implementing systems for quality
Tools and techniques to study
Project Human Resource, Communications and Stakeholder Management
Developing the plan and acquiring the team
Efficiently communicating with stakeholders
Managing stakeholder engagements
Project Risk and Procurement Management
Assessing project risks
Exam-relevant tools and techniques
Procurement management
Planning for the Exam
Preparing for test day
Personalizing your study plan
Project managers seeking to get the PMP certification
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.
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
Students of age 16 to 19 IB SL and HL level.
Macro VBA Automation : All Kind of Reports, Graphs, Charts Solution classes at Dubai
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
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
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.
Installation of software, Beginning with expert level learning, 2d drawing to detail 3d in Revit and rendering 3d in Lumion.
Students, professional engineers, draftsman.
By attending this course, students will be able to successfully attempt and pass the CMA examinations.
CMA Part One: Financial Reporting, Planning, Performance, and Control
CMA Part Two: Financial Decision Making
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.
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.
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.
This course is about Machine Learning with Python Course.
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
Programmers, Developers, Technical Leads, Architects, Freshers,Data Scientists, Data Analysts,Business Intelligence Managers.
This course is about Data Visualization with Tableau, R and Python Course.
All the professionals who are passionate about business intelligence, data visualization, and data analytics.
All the professionals who are passionate about business intelligence, data visualization, and data analytics.