Excel 2013 Data Analyst Intermediate Training
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Short and Concise - no fillers or fluff!
A big "thank you" to the course instructor for going straight into the point and showing me how each feature works while elaborating on the use of them in the real world. It was very easy to understand all the lessons which averages only about 5-8 minutes each.
Very good excel course!
The course is well structured, easy to follow, it has good content, nice visuals and practical examples. I recommend it!
Focused on data analysis
The Excel Data Analyst course is a course focused helping you take advantage of all MS Excel data analysis tools. It is not a generic course and this gives me the possibility to take the time and go into detail on the covered topics.
Learning Excel is not just about knowing Excel
This course should not be only about learning Excel because is not enough. It should be about taking advantage of all the Excel features to help you in your everyday professional and personal life. It should be about that report that you create that will blow people away and get you noticed or that family budget that will help you find out what drains your money away.
The course is split into 3 main sections.
After each section we have a task list that will help you put the information into practice. All the working files will be available for later use.
In this 90 minutes training you will learn the following:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting started|
|Section 2: Data analysis basics|
Getting visual with conditional formating
Using subtotals for summarizing data
Using data validation
|Section 3: Using pivot tables|
The Pivot Table concept
Building a Pivot Table
Fine tuning the Pivot
Slicers and timelinesPreview
|Section 4: Using charts|
Excel Chart types
Adding data to a ChartPreview
|Section 5: Closing the course|
|Quiz 1||11 questions|
Glad you made this far, please take the time to go through this brief quizz to check your knowledge.
Hello, my name is Radu and I live in Romania. I work as a trainer and consultant in a very cool Romanian company (ROMCOM) and I am focused mainly on the technical and technology side.
Even though I graduated a computer science faculty some during the last study years I decided I don't want to be a software developer but rather work in Human Resources. 4 years of volunteering experience in AIESEC got me very interested in working with people and helping them grow.
So far I have worked in 4 very different companies, a small Dutch-Romanian IT company, a multinational manufacturing corporation, a Romanian HR Consultancy company and now in a Swiss-Romanian consultancy company.
Even though I have worked as a HR professional in all these places, my computer science background made me always look for ways in which technology can help me do my work in a more efficient, better and maybe even fun way. About this topic I also started a blog called freshcomputerskills.