#MICROSOFT EXCEL CLASSES HOW TO#
#MICROSOFT EXCEL CLASSES FULL#
#MICROSOFT EXCEL CLASSES PC#
#MICROSOFT EXCEL CLASSES SERIES#

The tips themselves include everything from working with fractions, to unlinking a pivot table from its source data, to spreadsheet protection FAQs. The most helpful part of his website is probably the Excel Tips tab, which has a long list of useful pointers on formatting, formulas, charts and graphics, and printing.

#MICROSOFT EXCEL CLASSES HOW TO#

In other words, the man knows his stuff - and he knows how to present it.

#MICROSOFT EXCEL CLASSES PC#

At one point, he wrote the monthly spreadsheet column for PC World. Over the past 30 years, he's written more than 60 Excel books for users of all levels, and around 300 articles and reviews for magazines like InfoWorld, PC World, and PC/Computing.

#MICROSOFT EXCEL CLASSES FULL#

Here's a very well-organized site that's chock full of helpful Excel tips, collected by an expert named John Walkenbach. Learnings include data and time functions, how to group and ungroup rows and columns, using conditional formatting, PivotTables, chart design, and more. In addition to this a-la-carte curriculum, Excel Exposure offers a 'Master Workbook' that lives directly in Excel to help you practice what you learn in each lesson. There are nearly 40 lessons - split into 'Beginner,' 'Intermediate,' and 'Advanced' - each no more than 20 minutes long.

#MICROSOFT EXCEL CLASSES SERIES#

' How to Create a Pivot Table in Excel: A Step-by-Step Tutorial' (video & blog post)Įxcel Exposure is a free series of written and video-based courses to help you learn Excel regardless of your skill level.' 9 Excel Templates to Make Marketing Easier' (free templates).The Ultimate Guide to Using Microsoft Excel (long-form content).' How to Use Excel: The Essential Training Guide for Data-Driven Marketing' (free ebook).Hubspot Academy x GoSkills Excel for Marketers course (free course).Here are a few of our best Excel resources: By the end of the course, you’ll have mastered time-saving hacks to simplify your workflow and gain a shiny Certificate of Achievement for your efforts. The universal course content can be applied to any context, including marketing, and is perfect for those who need a refresher in Excel fundamentals. In the lessons, you will quickly get up to speed with Excel’s most common formulas, functions, and shortcuts. Level up your Excel skills with GoSkills’ and HubSpot Academy in our free Excel for Marketers course. GoSkills & HubSpot Academy Excel for Marketers Course How to Learn Excel With Free Training Resources 1. Bookmark your favorites and get that much closer to working more efficiently in Excel. Take a look at the free and paid resources below. Print your Excel spreadsheet for presenting to others.Add conditional formatting to rows and columns that fit certain criteria.

Create dashboards to manage multiple groups of performance data.

Develop histograms of data from the charts you create.

Create charts from your spreadsheet data.

Use keyboard shortcuts to make quick changes to cell values.

Perform data validation to control the format of cell values.

Group, ungroup, and reformat rows and columns.

Run accounting functions to track business finances.

Conduct a VLOOKUP across an entire column.

Enter formulas across cells, rows, and columns.

Create PivotTables to find relationships between data.

In these trainings, you'll learn the following: Half of them are free, and the ones that aren't might be worth the investment.

So in the spirit of becoming a more productive, data-driven marketer, I scoured the internet for the best online resources for learning Excel. I can't be the only one out there who wants to master the world's most popular data analysis and visualization solution - or at least learn how to create charts and graphs that'll impress my manager. But as a beginner, I probably have a few too many Excel questions to rely on colleagues - or Google - to answer every one.

When I asked even my most Excel-savvy colleagues where they picked up their knowledge, they told me things like, 'I mostly learned from colleagues and friends,' or, 'When I have a specific question, I ask someone or search on Google.' Fair enough. Like me, you're missing out on a world of Excel training courses that could teach me how to automate my reports and save hours of time. I've used it to organize events, plan meals, and sort data - but I don't have nearly the advanced knowledge I wish I did.Īnd thanks to those limited skills, I'm constantly subjecting myself to the tedium of updating my spreadsheets manually. Like many marketers, I have a bit of experience with Microsoft Excel.

Microsoft excel classes