Home > Blogs > Seven Tips to Become a Pro at Excel
Excel is probably the most underrated professional tools available in the market today. Very few can boast of having mastered Excel. Those who are working towards it or have a good knowledge of the software certainly make an impact on their team mates.
There are endless online Excel tutorials to help you hone your Excel skills. You can also opt for the Advanced Excel Training programs offered by Manipal ProLearn to improve your professional efficacy and in turn, your productivity.
There is always something new to learn in Excel and below are some of the quick tips that could save you time and energy.
1. Auto Fill – Auto Fill can save you a ton of time taken on menial typing. It is a handy tip to use when you are filling in a series of repetitive entries like dates, numbers or alphabets in consecutive cells.
All you need to do is begin the series and then move the cursor to the bottom left corner of the last cell of the series using the fill handle. Use the little plus sign (+) and click and drag to select all the cells you need to fill, and voila – time saved.
2. Text to columns – When working with a data dump in Excel, you might need to separate text into different columns for ease of use. For example, if you have a column with full names, but want to separate it out to have two columns with first name and the second with last name or if you have a numerical code and then a word, you can use ‘Text to Columns’ feature to separate it out. Select the data, then on the ‘Data’ tab click ‘Text to Columns’, then choose to separate it either with delimited or fixed width.
3. Freeze Rows and Columns – When you have lengthy spreadsheets, the header disappears as you scroll down leaving you with data that you have lost track of. The easy way to keep the data visible is to freeze panes, which is a feature available under the ‘View’ menu. Just highlight the below or to the right of the row or columns you want to freeze and choose freeze panes.
4. Remove duplicates from a data set – Excel is most useful to handle large volumes of data. When you are using such large volumes of data, it is likely that there are duplicates that you do not need. Luckily, this is easily dealt with by using the ‘Remove Duplicates’ command in the ‘Data Tools’ group under the ‘Data’ tab. To highlight unique or duplicate values you could also use the ‘Conditional Formatting’ command in the ‘Style’ group in the ‘Home’ tab.
5. Validate data to create drop-downs – Create a drop-down menu of selections to use in particular cells when you have a large list of data to handle, especially if it is a shared spreadsheet.
Highlight the cell and go to ‘Data Validation’ under the ‘Data’ tab. Select ‘List’ under ‘Allow:’ and type out your list, separated by commas in the ‘Source:’ field. Alternatively, you could click the button next to the source field and select the data series (you can hide that data later, if needed). Data validation is a good way to restrict the data entered and you can even create the exact error message you would like displayed.
6. Import data into Excel – The boon Excel grants us is to be able to use data from multiple data sources. Instead of using the copy+paste option of complex data sets, you can bring in the data by using the ‘Get External Options’ under the ‘Data’ tab and choosing the right options to be able to create drop-down lists and Pivot Charts or Tables as required.
7. Vague searches – You may want to find something in your large quantity of Excel data and the Ctrl+F option certainly helps with it. However, what if you remember only some of its letters or numbers? In such cases, Excel gives you wildcard characters to help you complete your search query.
- Question Mark – The “ ? ” can replace a single character. For example “B?nd” could mean Bind or Bond, but not Bound.
- Asterik – The “ * ” can take the place of any number of characters. For example “B*nd” could mean Bend, but could also mean Bound.
- Tilda – The “ ~ “ indicates that the character will be treated as a normal character and not a wildcard character. For example “B~?nd” can only mean “B~?nd”.
Bonus tip: You can never know all of the Excel shortcuts, so here are some you can add to your existing list.
Ctrl+; - Inserts today's date.
Ctrl+Shift+: - Inserts the current time.
Ctrl+Shift+# - Changes the format of a date.
Ctrl+5 - Applies a strikethrough to the text in a cell.
Ctrl+0— Hides the current column.
Ctrl+9 - Hides the current row.
Ctrl+F6 - Switches between open workbooks (that is, open Excel files in different windows).
Ctrl+` - That's the accent mark, up by the 1 key. This combo toggles the view in the sheet to show all the formulas. Ctrl+PageUp or PageDown allows a quick shift between the sheets in the currently open workbook.
F2 - Start editing the current selected cell (much faster than double-clicking).
Shift+F10 - Opens the right-click menu for the cell you're in.
Excel includes several lesser known features. Try your hand at Pivot tables, Data Query, Visual Basic Applications, Macros, etc. through Manipal ProLearn’s online training programs that offer certification courses in Excel.
Home > Blogs > R in the Industry: 4 Great Examples
Whether you have a tech background or not, you must have certainly heard of R. It is a project, a language, and a software environment. The most remarkable thing about R is that it is part of the GNU free software project. This project is about sharing software without any license restrictions or fees. Since R is a free software, over 2 million data scientists and statisticians use the software worldwide.
Why is it so popular? The adoption of R for business applications helps companies to understand the behaviour of the user, allowing them to improve their applications and software to meet these needs. So a lot of online and professional courses related to Big Data training are coming up as well.
To get an insight into how R is impacting the industry, let’s take a look at four great uses of R by companies.
Facebook and R
Facebook is a social media giant, but the company never stops looking for new ways to keep their audience engaged. They have over 2 billion monthly users and manage more than 500 terabytes of data per day! They use R to understand what their users do on Facebook and the kind of elements they interact with on the platform.
The statistical data that R provides helps the teams at Facebook understand what the users are doing throughout the day and how they can cater to them better. They are even able to track and explain how things like memes go viral on the platform, all thanks to the inputs from R.
Picture Courtesy - Quora
Google and R
If you have ever run a campaign on Google, you may often wonder ‘Is the increase in traffic because of something unrelated, or is it only because of the campaign?’ Google wanted you as a marketer, to be aware of what would have happened if the campaign didn’t run. So they released a new package for R called the CausalImpact. It relies on R to tell you what would have happened, how many clicks or how much interaction you would have generated had you not run the campaign.
CausalImpact uses Bayesian structural time-series models, which give us the answers we seek. Keep in mind, for this to work, you’ll need a time series of results before and after the intervention, and a "control" time series during times when there was no intervention at all.
Example of R and CausalImpact Picture Courtesy - revolutionanalytics
The New York Times and R
If you think of data journalism, you think The New York Times. They use R to create interactive data visualizations, which they started doing back in 2009. The graphics editor - Amanda Cox has gone as far as calling R "the greatest software on Earth" because of the visualizations it helps her publish.
R helps journalists to transform concepts to neat visualization in just hours. They have used R to cover topics like – election forecasts, best places to grow up, wealth distribution and more.
Picture Courtesy - r-bloggers
The environment and R
You’d be happy to learn that it’s not just big businesses that use R, but also several weather stations and more. R is used to help predict calamities such as floods due to overflowing rivers, which helps save thousands of lives! Realclimate.org uses R to warn us how climate change is negatively affecting our world, from showing us rising tides to melting ice caps. Reading numbers and figures about these issues is not nearly as impactful as studying it in the form of visuals, and we only have R to thank for this.
It can easily be said that the popularity of R is increasing without bounds. It is sure to create a plethora of job opportunities as well. Enrol in any of the courses provided by Manipal ProLearn on Big Data analytics training, Big Data certification or Big Data tutorials to up your professional game and technical knowledge by a few notches!
|Enroll Now with coupon UPSKILL|
Home > Blogs > Dragonfire Academy Collaboration with Manipal ProLearn brings Affordable Online UPSKILLING to Malaysian Professionals
Kuala Lumpur, Malaysia: Dragonfire Academy, the lifelong learning division of KL-based Dragonfire Corporate Solutions Sdn Bhd, has collaborated with Manipal ProLearn (a unit of India’s Manipal Global Education Services) to bring ProLearn’s online courses and certifications to Malaysia. The collaboration will see Dragonfire Academy providing online learners in Malaysia with access to over 100 programs offered by Manipal ProLearn in areas such as digital marketing, IT and data science, and finance and accounting. In addition, the Academy will supplement the online delivery of programs with interaction with Dragonfire’s team of learning advisors to reinforce learner understanding of key subject concepts.
The collaboration is designed to address the lack of face-to-face support for online learners, a common issue found in online learning and one of concern to Malaysian professionals that might otherwise embrace this “anywhere, anytime” form of learning. “One of the biggest challenges for individual online learners is that there is typically no one available locally to answer questions they may have about the subject they are studying,” explains George Bohlender, Dragonfire’s Managing Director. “As a result, they are unsure of their understanding of the subject and become discouraged with their studies. Providing online learners with access to an advisor with industry experience can give them the confidence they need to succeed,” Bohlender contends.
The affordability and flexibility of Manipal ProLearn’s professional upskilling programs were two key features that spurred Dragonfire’s interest in working with the company, Bohlender says. “ProLearn’s courses and certifications are cost-effective. We can bundle them with complementary programs and services to provide our clients with complete learning and development solutions for both individuals and groups of employees.”
About Dragonfire Academy: Dragonfire Academy (https://academy.dragonfire.com.my) is a centre for continuous learning established in July 2017 by Dragonfire Corporate Solutions Sdn Bhd, a KL-based boutique management consulting firm. The Academy’s aspiration is to provide as many Malaysians as possible with the education and skills necessary to contribute to the national economy. The Academy offers academic and skill-based programs, training in socially-responsible entrepreneurship, professional certifications and executive education, and personal development programs. The Academy’s education and training offerings are supported by a suite of services, including career counseling and assessment, psychometric profiling, and prior learning assessment and recognition, designed to help Malaysia’s adult learners chart out and achieve success in their career or self-employment journey.
Home > Blogs > Openings for Monitoring Trainees in 22by7
22by7 is hiring for Monitoring Trainees for their Bangalore office. Kindly go through JD below and in case you are interested in applying, please mail your updated profile to email@example.com.
LAST DATE TO APPLY: 6th Sep 2017
JOB DESCRIPTION (JD):
JOB LOCATION: Bangalore, India
ROLE: Monitoring Trainees
NO. OF OPENINGS: 04
EXPERIENCE : Fresher’s are Welcome Too
QUALIFICATION: Diploma/ Graduate / BE with CCNA/MCP and basic Networking Knowledge
- The candidate should have excellent written and verbal skills as they would have to interact with different clients
- Preferable to have knowledge on networks and security systems
- Desire to Learn
- Good Aptitude with Positive Attitude
- The employee shall monitor the incoming tickets with respect to all the clients. He / She shall close the false alerts and dummy tickets
- The employee shall try to solve the tickets taken up by him / her with the assistance of colleague or his / her senior. Else , he / she shall escalate the problem to the higher level
- The employee shall be logged on to the support tool during his/ her presence in the office premises. In case, the problem is not solved, he / she shall raise a ticket for the same.
- The employee shall monitor the client servers and shall report if any critical alerts are received.
- The employee shall check the backups running with respect to all the clients and status for the same has to be communicated to the concerned personnel.
- The employee shall check for Windows updates, Anti Spy ware and antivirus updates and shall send a report on the same. .
- The employee is expected to learn and work on issues while he/ she is assisting his / her senior.
- The employee shall try to upgrade his technical skills.
- The employee shall update colleagues on the status of the job performed.
- The employee shall update his activity in the reporting tool on a day to day basis.
Delivering a functional environment for IT infrastructure to enable Business Continuity and Emerging Technologies is the raison d’etre of 22by7. They are forerunners in Info Security, ILM & Cloud, Virtualization & Networking domains.
At 22by7, they are committed and are eminent in the industry to deliver these exponentially emerging verticals, through virtue of quality certified professionals who design, deploy, ASSIST & manage your IT backbone.
Know more about 22by7 at http://22by7.in/
Home > Blogs > Success Bells are ringing at the Manipal Prolearn
Manipal Prolearn is happy and proud to welcome esteemed organisations like Shopalyst, Zensar, Genpact, GrowthEnabler, and Gramener for campus placements for the current batch of PG Diploma in Data Science.
About Manipal University PG Diploma in Data Science (Full Tme)
This PG Diploma in Data Science by Manipal University is conducted at the Manipal Prolearn, Bangalore. Through this course, you get to master Data Management, Statistics, Machine Learning and Big Data and launch your career in data science.
The pedagogy is driven in collaboration with Genpact, Experian, and IBM Big Data University. Spread over 77,000 square feet, the campus boasts of state-of-the-art classrooms and data science labs equipped with the latest analytics software and applications. The course is taught by the best minds in the Analytics domain with over 15+ years of industry & analytics domain experience.
Home > Blogs > How Social Startups Can Use Data Science to Find Their Next Opportunity!
In India, we are constantly exposed to the inequalities and man-made problems of the world, be it hunger, poverty, lack of infrastructure, or pollution. With millennials turning their focus towards work that gives them a sense of purpose, there is now a generation of people empowered with technological skills needed to make the world a slightly better place. They are working for and setting up organisations, large and small, to harness the power of data to find trends, predict outcomes, and prescribe solutions to social issues worldwide.
Making a difference
Organizations like the Bill & Melinda Gates Foundation, Change.org, and the Organization for Economic Co-operation and Development, invest heavily in data science and analytics for many reasons. The Bill & Melinda Gates Foundation uses data science internally to analyse opportunities, find gaps that need to be filled, figure out how much to invest in solving the problem they found, and track their progress.
They also host and publicly share the data they gather because they believe that they can better, identify opportunities, assess evidence, learn from each other’s experiences and build trust by relying on an open exchange of ideas and information. For example, earlier this year they invested in gathering data about women and girls to improve their representation and visibility to advance gender equality.
Bringing about a change
Change.org allows users to create and distribute petitions to submit to governments and policy makers. They use data science to help improve their user experience because they know that their users are the ones whose actions will help make a difference. One of their goals is to bridge the gap between parsing search parameters and truly understanding what a user is looking for in their database.
Change.org is able to engage with their audience better and have them sign more relevant petitions by improving their search results and tailoring them for each user. For example, by analysing data about their users and petitions, they found that localizing their website for non-English speakers gave a voice to the people who were not otherwise able to influence policy makers in their communities.
The Organization for Economic Co-operation and Development analyses data about a variety of topics to help governments and policy makers tackle social and economic issues in their regions. By aggregating and analysing big data, they are able to make predictions, and set standards about topics ranging from agriculture and fisheries to bribery and corruption to help governments accelerate their work.
We, millennials, are a generation that does not need to second guess a hunch we have about a problem in the world. With the power of information at our fingertips, opportunities do not need years of research or a great sense of intuition any more. We can just look online for the reassurance we need and dive right into solving the problems we see.
Home > Blogs > Opening for Scrum Master with a leading EdTech Company
A leading EdTech copany has immediate need for a Scrum Master in Mumbai. ProLearners who wish to apply, please send a mail with your updated resume to firstname.lastname@example.org.
JOB DESCRIPTION (JD) FOR SCRUM MASTER:
Job Location: Mumbai, India
Role: Java Lead
Experience : 8-12 years
Qualification : B.E, B.C.A, M.C.A, B.Sc, M.Sc and any other graduation stream
Certification : Entry level of Scrum Certification- CSM, PSM 1 is a must
Advanced Level of Agile/ Scrum Certification- CSP, PSM 2, SAFe Agilist
JOB ROLES & RESPONSIBILITIES:
- Minimum 4-5 years of experience of working as a SCRUM Master with hands on Agile experience and in applying Agile principles, culture, best practices & theory.
- Having experience of development will be added advantage
- Experience of facilitating SCRUM ceremonies & practices
- Excellent written and verbal communications skills
- Grooming, prioritizing and maintaining the product backlog in collaboration with Product owner
- Must have worked on following tools – JIRA & Confluence
- Maintain relevant metrics like Burn down, Velocity etc. that help the team see how they are doing and coordinate release efforts
- Good experience of people management, Risk assessment, planning, execution
- Remove any impediments or blockers that would prevent the team from achieving its sprint goals
- Help achieve potentially shippable product increment at the end of the sprint
- Experience of collecting and maintaining artefacts for internal audits as per organization policies
- A strong team player with the ability to understand team issues and to encourage and enforce strong working ethics within the team.
- The ability to lead and motivate the team to fully adopt Scrum processes
- The ability to build strong and effective working relationships with all key contributors to the project - the development team, the PO and/or BA and the management stakeholders
Home > Blogs > Opening for Java Lead with a leading EdTech Company
A leading EdTech copany has immediate need for a Java Lead in Mumbai. ProLearners who wish to apply, please send a mail with your updated resume to email@example.com.
JOB DESCRIPTION (JD) FOR JAVA LEAD:
Job Location: Mumbai, India
Role: Java Lead
Experience : 7+ years
Qualification : B.E, B.C.A, M.C.A
- Extremely proficient on core as well as J2EE design patterns.
- Should have worked on OO model, web services and API integration.
- Working knowledge on UML.
- Very good verbal & written communication skills expected.
- Should be able to handle team.
- Solution oriented approach.
- Programming and implementing components using J2EE model.
- Uses best practices in development during programming and testing.
- Unit Testing and Documentation.
- Strong problem solving and analytical skills.
- Any other responsibility that falls in the purview of this role.
- Spring Framework, Spring Securities, AJAX
- MySQL, Oracle 10g, PL/SQL
Home > Blogs > The Secret to Making Blockbuster Movies Will Amaze You!
The secret lies with a bunch of analysts poring over statistics about when people stopped watching something, what they fast-forwarded, what they replayed, which actors were in the most successful movies, and when those movies were released.
Before you get creeped out, they are not watching your individual actions, and no, they do not know that you watched your favourite feel-good movie seven times last month. They are looking at aggregate data amassed by online streaming services like Netflix and Hulu.
With this kind of information readily available, user interaction data has gone beyond basic web design into the practical details of how people respond to TV shows and movies. Netflix is already known for its recommendation algorithm that is based on giving each movie or TV show hundreds of tags to predict what specific combination each user will like best.
With this staggering amount of data that can be collected from online viewing, streaming, and downloads, analysts can crunch the numbers not only to figure out why a movie failed, but more importantly, to predict what will do well in the future. Based on big data analytics, movie producers can pick a winning formula with greater accuracy better than ever before. They no longer need to rely solely on intuition, safe story lines, and big movie stars to pull a movie through to a profit.
Even after the movie is made, data analytics can help predict the best time for release based on certain metrics like the actors in the movie, their previous work and releases, the time of year, and previous responses to a similar type of film. For example, if an Anushka Sharma movie is released right after two other movies that she starred in, the movie might not do too well. The audience might get fatigued, especially if it is her third romantic comedy in a row.
Analysts can also look at aggregate data across social media to see the engagement levels that the target audience had across different platforms for similar movies in the past. Based on this prior experience and knowledge, analysts can put together a marketing strategy to maximize buzz and create curiosity ahead of the release. For example, Netflix put together different types of previews of House of Cards that were tailored to different target audiences, to maximize its appeal.
While this is great for filmmakers and investors, it might not be the same for audiences. The caveat to this kind of predictive analysis could be that the formulas may become more and more generic over time. As we have already seen with our Facebook newsfeed, when we get more of what we already like, we rarely see anything new. Hopefully, audiences will stay diverse and fickle so we can keep our movie options open and interesting.
Home > Blogs > Opening for Social Media & Outreach Intern with IIHS
The Indian Institute of Human Settlements (IIHS), Bangalore is in hiring for a Social Media and Outreach intern who can help with the launch of their Urban Fellows Programme (UFP). ProLearners who wish to apply, please send a mail with your updated resume to firstname.lastname@example.org.
JOB DESCRIPTION (JD) FOR SOCIAL MEDIA & OUTREACH INTERN OPENINEG:
Role: Social Media Internship (2 Months)
Title : Social Media and Outreach Intern
Experience : 0- 1 years
Qualification : Marketing/ Communication/ Business Graduates
Key Responsibilities / Experience
- Extending support for Social Media Activities, research, data mining, content for newsletters and other promotional activities.
- Assist the outreach process and provide communication support.
- Must be proficient in Microsoft Excel.
- Candidates with 1 year relevant experience can also apply.
Job Location: BANGALORE
Stipend: 15,000 per month
About the Indian Institute of Human Settlements:
The Indian Institute of Human Settlements (IIHS) is a national institution committed to the equitable and efficient transformation of Indian settlements.
IIHS aims to establish an independently funded and managed National University for Research and Innovation focused on the challenges and opportunities of India’s urban transition. IIHS has also been designated a National Resource Centre (NRC) by the Ministry of Housing and Urban Poverty Alleviation.