|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-pivot-tables/
课程评论:没有评论
课程名称:微软Excel数据透视表初学者指南 课程概述:你是否是一位需要提升技能的职场人士?是否在争取加薪或晋升过程中遇到挫折?或许你是一名应届毕业生,简历看起来空洞无物,缺乏工作经验?又或是在近期被裁员或合同终止?如果你的回答是“是”,那么具备“专业的微软Office技能”将有助于你实现找到第一份工作、新工作的目标,或在当前岗位进一步发展。如今的就业市场波动性很大,越来越多的人频繁更换工作,同时也有许多人因为缺乏技能被新入职者取代。因此,提升技能变得愈加重要。根据微软和IDC发布的研究,在1460万份招聘信息中,熟练掌握微软Office被雇主认为是2020年前最受欢迎的第二大技能。掌握这项技能能够提高你的适应能力和长期价值。 在线培训的普遍问题是内容庞杂,难以入手。因此,许多人选择报名在线培训课程。在这个课程中,我力争以最低的价格提供丰富的内容,以便为大学生、应届毕业生、失业者或希望转行的人提供可负担的学习机会。 课程的授课风格是简单易懂,我拥有20年的微软Office使用经验,讲解尽量简洁,避免复杂的术语,力求让每位学生都能轻松跟上进度。课程的每个视频都很短,以小节划分,便于学习和消化。使用特殊软件在屏幕上绘制和放大细节,确保不会错过任何重点。 在本课程中,您将学习到数据透视表这一强大的分析工具。我将通过一个简单的例子来介绍它的应用,想象一下如果你有100颗M&M巧克力,你该如何按颜色、类型和大小进行分类。数据透视表就像是一个神奇的工具,可以轻松地对信息进行排序、分组和汇总。在课程中,我将教你如何设置数据、创建第一个数据透视表、应用不同参数、修改数据源、刷新链接等。 每日你都在等待什么?今天就报名参加吧! 讲师简介:我是一名Udemy理事会成员,联合创办了Paperclip Learning,专注于教授微软Office课程,已有超过6万名学生报名参加我开设的课程,我的教学热情源于对微软Office的热爱并贯穿于我的职业生涯。我有多年的教授经验,涵盖小学、中学、大学及职场专业人士。 学员评价:许多学员反映课程内容精彩,学习迅速,讲师的指导详细易懂,课程的“迷你教学”形式快速有效,内容全面且趣味横生。 课程大纲:无
WHAT'S YOUR STORY? Are you a business professional needing to up-skill?Are you struggling to get a pay-rise and/or promotion?Are you a recent graduate with an empty looking resume and no job experience?Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having "Expert Microsoft Office Skills" will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you're not up-skilling, you're falling behind. It's scary I know. I've experienced this myself. A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics. This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory. ONLINE TRAINING AND THE MOST COMMON PROBLEMS One of the most common problems with online learning content is that there is so much of it now and it's difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won't happen and will just waste your time. Many take the route you're about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I'm offering substantially more content than most of my competitors here on Udemy. COURSE DELIVERY STYLE I have been using Microsoft Office for over 20 years. I know the in's and out's and the simplest ways of doing things. My delivery philosophy is simple, if I can't get a 6 year old to follow along and understand, than I'm not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won't get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I'm about to press as well as zoom in on small area's so you don't miss a thing. WHAT YOU'LL LEARN IN THIS COURSE Pivot Tables are extremely powerful analytic tools available in Microsoft Excel. I shall share an example of it's use using my favorite lunch time chocolate snack, M & M's! If you don't know what M & M's, firstly you haven't lived, and second, they're awesome chocolates that come in little bite size forms in a variety of colors. So imagine someone gives you 100 M & M's. It's your job to sort them by color, by type and by size. Obviously, this will take a long time as you have to sift through the M & M's one by one. However, imagine you had some magical tool that will instantly sort the M & M's however you like. By type....No worries! By colour....even easier! Pivot Tables sort, group and summarize information similar to sorting M & M's by colour, size or shape. It's so easy to use and even easier to learn! In this course I'll teach you how to setup your data, how to create your first pivot, apply the different types of parameters using the pivot module, change data sources, refresh links and much more. So what are you waiting for, sign up today! ABOUT ME Member of the Udemy CouncilCo-Founded Paperclip Learning which teaches Microsoft OfficeOver 60,000 students and over 17,000 students for this course aloneOver 130,000 enrollmentsOver 5,000 Positive Reviews and over 1,000 Reviews for this courseOver 20 courses on Udemy Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics. TESTIMONIALS Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn't waste time and gets to the point quickly!! Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing. Spencer Berkman - Extremely knowledgeable and clear on instructions. E Frank - Simple to learn techniques and instructor made it all really easy. Thank you! Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.