
Take a quick visual tour of Excel line and pie charts, including graphs, overlays, colors, gradients, labels, and trendlines. See how basic knowledge enables diverse chart variations.
Learn to build and format Excel charts and pie graphs by selecting data, labeling, and styling with rounded edges, backgrounds, and a chart area gradient.
Explore creating line and pie graphs using a case study of famous musicians' album sales, with artist names, album titles, years, and sales figures.
Learn to insert a chart from a raw sheet, avoid starting inside a table, use the Insert menu to choose a line chart, then move and resize the graph.
Learn to build a line graph in Excel by selecting data, setting music sales on the y axis and artist names on the x axis, with a labeled series.
Add a precise chart title, set horizontal and vertical axis labels, and include a legend. Activate the chart and edit the title in layout options.
Use the Layout tab to add primary vertical and horizontal axis titles, rotate the vertical title, type 'millions of album sales' and 'artists', and drag to reposition.
Activate your chart and insert a legend in Excel. Use the layout menu to place the legend on the right and resize it for a better fit.
Learn how to change a line graph’s color in Excel, by selecting the line, changing the color to orange, and applying changes via format selection or metadata series.
Learn to adjust the line width in Excel charts by selecting the data series, accessing line style, and setting a thicker thickness for clearer multi-line displays.
Change the line pattern to differentiate multiple lines by applying dash types, then use format selection to pick the line and apply a dash type such as dash 1.
Set the chart axis major units to smaller increments, replacing 20s with 1, 2, or 5 so the axis becomes easier to read with more gridlines.
Add a secondary axis to a line chart to display two data series with different scales, music sales on the left and year on the right.
Insert a 3-D exploded pie chart from the insert menu, select the data for music sales, add the values, and press OK to display.
Format a pie chart by adding data labels, removing the legend, and using percentage and category name labels to improve readability and compare slice sizes.
Learn to instantly change your chart type in Excel by converting a line graph into a column or pie chart without rebuilding, while preserving data and applying quick formatting.
Select the pie chart, open the design menu, and apply pre designed chart styles for formatting in Excel with a click; experiment with black, white, red, purple, and rounded-edge options.
Apply background formatting to charts by selecting format chart area, choosing solid, gradient, or pattern fills, and experimenting with colors to enhance your Excel graphs.
Celebrate completing the Microsoft Excel line and pie graph design and styling course and invite feedback via email. Inspire hesitant learners to give it a try and explore more courses.
WHAT’S YOUR STORY?
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
The proper utilization and construction of Charts and Graphs is crucial as it is the vessel which will allow you to present and communicate your results effectively.I'll teach you how to introduce your charts with minimal frustration. I'll then teach you how add titles, axes labels, legends, secondary axes and multiple series. Along with construction I'll teach you how to add style and impact to your charts through design styles, background formatting, graph textures and many more!
ABOUT ME
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