Skip to main content

Analytics in Excel - Course Contents

Hey you want to be master in Excel. Then these are the course contents you need. There are 4 parts of in this course. These contents cover all the functionalities you need to work with Excel.
Excel Course Contents
Excel Course Contents
Part-1 - Importing Data from other sources
  • Learn about the typical import sources of data (e.g. accounting software, ERP systems and common database programmes)
  • Understand the pros and cons of different importing methods with walk through examples Discuss the form of received information and its implications (e.g. dating, text and number formats) Clarify what data aims to represent in column and row arrangements, in spatial and duration terms
Part-2 - Converting data Excel ready
  • Identify how Excel understands your data and make data Excel compliant Learn key Excel functions, tips and tricks to assist quick conversion including: functions – e.g. RIGHT, LEFT, CLEAN, TRIM, PROPER, MID, LOWER, UPPER tips – e.g. use of custom formatting to cleanse data tricks – e.g. converting specific elements of data blocks fast by changing between number and text forms Understand when data is corrupted or simply unreadable for Excel
Part-3 - Data Mining
  • Discuss and define analytical goals for the data by posing the correct questions Identify what data may be omitted in light of goals and learn how to remove this efficiently Define the parameters of your data and manipulate it into useful blocks for analysis, using: Dating and time controls Lookup and reference formulas including LOOKUP, MATCH, INDEX, CHOOSE, OFFSET Sum controls including SUMPRODUCT and SUMIF Arrangement controls including TRANSPOSE, FILTER and SORT
Part-4- Excel Data Analysis Tools
  • Answer your data queries by understanding a wide range of tools at your command including: Pivot tables Statistical functionality (e.g. MEDIAN, PERCENTILE, CORREL) What if analysis tools, including Goal Seek and data tables Moving averages Regression analysis Finalise your investigations by presenting your findings: Use advanced conditional formatting commands and tricks Develop professional presentation charts for reporting to senior management.


Comments

Popular posts

Blue Prism complete tutorials download now

RPA blue prsim tutorial popular resources I have given in this post. You can download quickly.Learning Blue Prism is really good option if you are learner of Robotic process automation. The RPA is also called "Robotic Process Automation"- Real advantages are you can automate any business process and you can complete the customer requests in less time.

The Books Available on Blue Prism 
Blue Prism resourcesDavid chappal PDF bookBlue Prism BlogsVideo Training
RPA training The other Skills you need
Basic business skills and Domain skills are more than enough to be successful in this automation careerScripting languages like Perl/JSON/JavaScript/VBScript.  The interesting point is learning any RPA tool is not a problem. You can learn tool quickly. The real point is how quickly you apply your knowledge to implement automated tasks is important.


Also read
Robotic RPA Software developer skills you needBlue Prism tutorials download to learn quicklyPopular RPA tools functionality differen…

Three popular RPA tools functional differences

Robotic process automation is growing area and many IT developers across the board started up-skill in this popular area. I have written this post for the benefit of Software developers who are interested in RPA also called Robotic Process Automation.

In my previous post, I have described that total 12 tools are available in the market. Out of those 3 tools are most popular. Those are Automation anywhere, BluePrism and Uipath. Many programmers asked what are the differences between these tools. I have given differences of all these three RPA tools.

BluePrismBlue Prism has taken a simple concept, replicating user activity on the desktop, and made it enterprise strength. The technology is scalable, secure, resilient, and flexible and is supported by a comprehensive methodology, operational framework and provided as packaged software.The technology is developed and deployed within a “corridor of IT governance” and has sophisticated error handling and process modelling capabilities to ensu…

Robotic RPA Software developer skills you need

Robotic process automation is an upcoming and becoming most popular skill. As I said there are three popular tools. To become proficient in any one of the tool is really good to get a job in Developer role.
To get a job in this line, I found in my research that some programming skills and Hand-on training on any one of the tools is required. Also, try to to know differences in other popular rpa tools.

Most people are asking experience in tools like Automation anywhare, Blue Prism and Uipath. But, you cannot be proficient in all. So just know what are the differences. Ok...
You may ask a question like how to know. First join one good coaching institute and learn one tool perfectly. And start taking online training. Really good for you. Whatever you are lacking quickly you can learn online way.

To learn Uipath try here. Also, you can learn Automation anywhere tool online way.

The following are the list of IT skills commonly asking:
Automation anywhere/Blue Prism/Uipath.Net/C#/Java/SQL ski…