[All4One] Data analysis with MS-Excel [100% to steem-alive]

Mindset ICT Academy organisms customized training for people with very tight schedule who have need to update or upgrade their skill.
A tight schedule makes it impossible to enroll in the regular training program held during working hours,

Trending Skills

Among the the trending e
skill often needed buy this busy set of people are:

• Microsoft Excel
• Serge 50
• Quickbook
• Auto CAD
• Digital Marketing
• pitch tree accounting

In most cases, they don't have enough time to walk through the program. They often ask for a special arrangement to help them glide through the training at a considerable speed without compromising the quality of training.

Ms Excel for Data analysis

The set of student captured in this post are interested in Microsoft Excel, specifically for data analysis.
The class started with the definition and difference between sorting and filtering.

• We arranged a given set of data in ascending and descending order, while some special set of data had to be arranged based on a chronology
• Sorting was performed based on single and multiple fields.
• much time was spent on filtering data based on single and multiple criteria
• Managing a pivot tables
• Representing data as pie chats, bar chats histogram and line chats.
• Data entry and validation
• lookup, Toolpak and statistical functions
• Conditional formation and nested if.

Sorting and filtering data

On the 2016 version of Ms Excel, the sort and filter option is located at the extreme right of the home ribbon, under a group called editing.
Here is a sample of the data we are sorting.

• Place the pointer on any cell in the table
• Go the the top left
• Select the sort and filter option
• Select filter (this will attach drop arrows on each column)
• You can now drop the arrow on a column and specify your criteria

Conclusion

Even with a buzzy schedule, you can carve out time to update or upgrade your skill set. That is a sure way to remain relevant in this competitive generation.