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.
What is the “Microsoft Excel Training: Learn Excel 2010” course about?
In this Excel training course, you will learn efficient and effective ways to work in Excel environment from Dr. Chris Albright from Indiana University (you should Google him!). This comprehensive Microsoft Excel training course covers all the topics from beginners to advanced level. Instead of focusing on the length of the course, we focus on how effective the course can be; we value your time. We will teach you everything you need to know, all the way up to passing the Microsoft Excel exam, in little more than 8 hours videos. These videos are broken down into 125 topics. All of these topics also come with Read and Practice workbook where you will be able to apply what you learned.
When we created this course, we had five things in mind.
Since you will spend most of the time in this course within Excel, you will love your new Excel tab, “Excel Now!”. You will be able to read, practice and watch videos, all inside your own MS Excel under this tab. As you learn new topics, you will find yourself looking forward to seeing how the future topics work. And as you go forward, we will also remind you about what you have already learned. You will get plenty of opportunity to apply your new Excel skills and see the power of Excel along the way. Trust me, it will be fun!
What kind of materials are included?
Reading Workbooks, Practice workbooks, Videos, Tip Files and an add-in that will allow you to access any part of this course from within your Excel Application.
How long will the “Microsoft Excel Training: Learn Excel 2010”course take to complete?
The course is only 8 hours long, but give yourself about 15 hours to master Excel.
How is the course structured?
For windows with Excel 2007 or 2010, you will get a tab in Excel called Excel Now!. This tab will have 125 topics with reading, practice and videos material built in. See the screenshots.
For Mac users, you will find all of the material here on Udemy page.
Why take this Microsoft Excel training course?
This course is created by experts with you in mind.
Many universities require our course for their students.
Our Excel training course will make you efficient and effective in Excel in less than 15 hours.
You will be a rock star of Excel at School and Work.
And above all, you want to!
Sign up for this Microsoft Excel Training course now and learn Excel 2010 from expert.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction to ExcelNow!Preview
|Section 2: Changes in Excel 2007 and 2010|
Changes in Excel 2007 and 2010 IntroPreview
Tabs and RibbonsPreview
Modifying Ribbons in 2010
File and Office Buttons
Quick Access Toolbar
Opening Recent Files in 2010
Selected Range Coloring in 2010
New Functions in 2010
Add-Ins Buttons in 2010
Slicer in 2010
Sparklines in 2010
New Solver in 2010
|Section 3: Intro to Basics|
Intro to Excel Basics
|Section 4: Moving and Selecting|
Intro to Moving and Selecting
Going Home to Cell A1
Splitting the Screen
Selecting a Range with Keys
Selecting a Range by Pointing
Selecting Multiple Ranges
Go to Options
|Section 5: Copying, Cutting, Pasting|
Intro to Copying, Cutting & Pasting
Copying and Pasting
Cutting and Pasting
Paste Special Options
Transposing a Range
|Section 6: Other Basic Tools|
Intro to Other Basic Tools
Manipulating Rows & Columns
Filling a Series
Sorting and Custom Lists
|Section 7: Formulas|
Intro to Formulas
Relative, Absolute Addresses
Evaluating a Formula
External Formula References
Error Codes & IS Functions
|Section 8: Charts|
Intro to Charts
Creating a Chart
Modifying a Chart
Locating a Chart
|Section 9: Intro to Functions|
Intro to Functions
|Section 10: Two Essential Functions|
Intro to Two Essential Functions
|Section 11: Basic Summarizing Function|
Basic Summarizing Functions
SUM, AVERAGE, PRODUCT
COUNT, COUNTA, COUNTBLANK
COUNTIF, SUMIF, AVERAGEIF
COUNTIFS, SUMIFS, AVERAGEIFS
|Section 12: Math Functions|
Intro to Math Functions
INT, ROUND, CEILING, FLOOR
ABS, SQRT, SUMSQ
|Section 13: Text Functions|
Intro to Text Functions
LOWER, UPPER, PROPER
Parsing with Text to Columns
Parsing with Text Functions
|Section 14: Date and Time Functions|
Intro to Date and Time Functions
YEAR, MONTH, DAY, WEEKDAY
Dr. Christian S. Albright is the renowned author of several books on spreadsheet modeling, data analysis, decision making, statistics, and Visual Basic for Applications, all of them based on the extensive use of Excel. You can check out his books at Amazon.com. He has spent most of his life teaching at Kelly School of Business in Indiana University. He recently retired from the University. He spends a lot of his time developing ExcelNow! and making changes to his books for Excel 2013. He has been engaged by Microsoft to teach many of their professionals about VBA and Excel modeling.</p></p>