课程详情

We get it, you're busy! You don't have time or patience to sit through hours of long winded, boring Excel lectures. This course is for you! You get through comprehensive material quickly that's to-the-point and presented by an expert in an approachable, lighthearted manner.You will learn how to write formulas and use functions. It isn't complicated or scary, and with this course's friendly, understandable and approachable style, you can quickly become an Excel expert. You will learn functions useful in different fields, industries, careers and tasks, and will learn efficient, time-saving techniques. You get videos with new and completed class files and a PDF reference guide.The material in this course covers older versions of Excel through the latest edition of 365. Most functions and features work on the Mac as well as Windows. A few feature works only in Windows and we make sure you know which those are.We start with writing simple formulas and functions, then progress to Excel's commonly used functions, like adding, taking averages and finding the highest and lowest numbers in a range. You'll learn how to use functions that make decisions, where the result can be two or more possibilities. Some of these functions are mashups of other functions you already know. Do you need to work with statistics? You'll find several functions in that chapter are just for you. Math or finance? We have those, too. And who knew Excel worked great for manipulating text? We cover functions and features that will make your life easier.We also cover Excel's data handling features like sorting and filtering tables, lookups, we have a chapter on data analysis that includes Pivot Tables, and how to manipulate data. You even get a chapter on how to create macros an even how to embed Python programs on a worksheet.

课程标签

0人关注该课程

主题相关的课程