The Ultimate Microsoft Excel 2010 Training Course - 14 Hours

What you'll learn
Discover how to create and edit spreadsheets.
Learn how to organize your data with rows, columns, and multiple sheets.
Master both simple and more complex formulas.
Sort and filter your data.
Four basic steps to consider when creating charts and graphs.
How to better format your charts and graphs like professionals do.
Discover how to deal with complex trends in your charts and graphs.
Learn how to use a bar chart and a pie chart to accentuate the differences in a data set.
Discover the tools and options for exporting your charts and graphs.
Discover the limitations of pie charts and the best way to correct them.
Learn how to use Pivot Tables and Pivot Charts.
Learn how to integrate graphics into your spreadsheets.
Requirements
Microsoft Excel 2010
Description
Just about everyone will find him or herself having to use Microsoft Excel at work at one point or another, and Excel 2010 is one of the most popular and powerful versions around. That means that everyone could benefit from devoting some time to mastering the program. Excel mastery will not only have a huge impact on your own productivity, but also it can look hugely impressive to your boss.
With our Ultimate Microsoft Excel 2010 Training Course, you'll find basic and advanced courses for Microsoft Excel 2010.
This bundle includes:
Beginner and advanced courses for mastering Excel 2010 14 hours of video tutorials Over 100 individual video lectures Optional quizzes to test what you've learned Certificate of Completion
Courses included with this bundle:
Learn Microsoft Excel 2010 for Beginners
Our professional instructor will talk you through Excel 2010's features, starting with the basics like creating files to editing existing documents. Secondly, you'll move onto moving and managing data across rows and columns, as well as different sheets, in addition to introducing your first formulas. Formatting workbooks comes next, in addition to adding attractive charts and graphs to display your work. You'll then progress to sorting and filtering data, linking multiple files and, finally, working with some more advanced formulas.
Learn Microsoft Excel 2010 - Advanced
Discover methods to make your exceptions stand out so you can attack the anomalies and use the data to make your operations better. During this Advanced level course, Excel's tools are covered in depth and include discussions on setting up live charts, Sparklines, color scales, and icon sets. Your data will become alive as you identify key action items and understand the meaning behind the numbers. Learn how to use Pivot Tables combined with Pivot Charts in powerful ways. By the end of this course, you will be able to move columns and rows to understand more easily than ever before how the numbers relate.
Where else can you find so many extra tools to help you gain advanced skills in Excel?
What people are saying:
★★★★★ "This would have to be the most enjoyable on-line course I have ever done. The material is nicely laid out, the presenter talks at a nice pace and explains things clearly. I highly recommend this course to those seeking Excel tuition." -Paul Schrooder
★★★★★ "Cindy is very clear and has organized the course brilliantly. Her explanation and covering of topics is granular enough to pick up once the course if over. Even though I am quite used to using most of what is covered, it was always interesting to hear her describe the features and was not bored!" -Sam Malone
★★★★★ "I learned two new things I never heard before. I have only been using Excel for 15 years. Well Done!" –David Munro
★★★★★ "Truly outstanding course. I have been in accounting/controllership for over 40 years. I decided to review the basics of Excel just to make sure I knew it all. I didn't know it all and this highly detailed, cover everything course did show me new stuff. Cindy's teaching style is the way it should be done. For someone starting out, very highly recommended." -Pierre Nantais
★★★★★ "Very clear easy to follow instructions and extremely well presented. Love the layout and how easy it is to navigate to the section you want. Very quick response to any queries you may have. Some companies wanted to charge over £200 for 4 hours! This is great, you work at your own pace, fit it in around your "hectic" lifestyle and you don't feel overwhelmed or afraid to look at a spreadsheet. I've gone from novice to understanding quite a lot from what I've learned so far and I'm not even half way through the course." -Debbie Lee
Overview
Section 1: Intro to Excel 2010
Lecture 1 Introduction and Overview of Excel Course
Lecture 2 READ ME: Essential Information for a Successful Training Experience
Lecture 3 Overview of the Excel Window
Lecture 4 Working with the Mouse
Lecture 5 Excel Options
Section 2: Getting Started Creating a New Workbook
Lecture 6 Entering Text and Numbers
Lecture 7 Creating Basic Formulas
Lecture 8 Relative References
Lecture 9 Order of Operations
Lecture 10 Working withe Ranges
Section 3: Saving Workbooks
Lecture 11 Working with Save and Save As Commands
Lecture 12 File Extensions
Section 4: Navigating Workbooks
Lecture 13 Opening a File
Lecture 14 Working with Larger Files
Lecture 15 Freeze Panes Options
Lecture 16 Split Screen Option
Section 5: Printing
Lecture 17 Page Setup Options
Lecture 18 Headers and Footers
Lecture 19 Print Titles
Lecture 20 Comments
Lecture 21 Fit to print on one page
Lecture 22 Printing Workbooks
Section 6: Working with Rows, Columns, and Cells
Lecture 23 Adding and Deleting Rows, Columns, and Cells
Lecture 24 Changing Column and Row Widths
Section 7: Moving Data
Lecture 25 Cut, Copy and Paste
Lecture 26 Copying Formulas
Section 8: Formulas and Functions
Lecture 27 Overview of Formulas
Lecture 28 Create Formulas using Functions - Part 1
Lecture 29 Create Formulas using Functions - Part 2
Lecture 30 Absolute Values
Section 9: Working with Worksheets
Lecture 31 Adding, Deleting and Renaming Sheets
Lecture 32 Additional Sheet Tab Options
Lecture 33 3-D Formulas
Section 10: Formatting Worksheets
Lecture 34 Cell Formatting
Lecture 35 Number Formatting
Lecture 36 Borders and Shading
Lecture 37 Format as Table
Lecture 38 Using Styles
Lecture 39 Using Format Painter
Lecture 40 Protecting Sheets
Lecture 41 Fill Handle and Custom Lists
Section 11: Charts
Lecture 42 Creating Charts
Lecture 43 Types of Charts
Lecture 44 Editing Charts
Lecture 45 Using Graphics to Enhance Charts
Lecture 46 Course Review
Section 12: Working with Names
Lecture 47 Creating Range Names
Lecture 48 Managing Names
Lecture 49 Using Names in Formulas
Section 13: Sorting and Filtering
Lecture 50 Removing Duplicates
Lecture 51 Sort Data
Lecture 52 Filter Data
Lecture 53 Advanced Filters
Section 14: Outlining and Subtotaling
Lecture 54 Creating an Outline - Part 1
Lecture 55 Creating an Outline - Part 2
Lecture 56 Subtotals
Section 15: Working with Views
Lecture 57 New Window Option
Lecture 58 Arrange File Options
Lecture 59 Creating a Workspace
Lecture 60 Custom Views
Lecture 61 Scenarios
Section 16: Linking Files
Lecture 62 Creating Formulas between Files
Lecture 63 Working with Links
Section 17: Advanced Formula Creation
Lecture 64 IF Statement
Lecture 65 VLookups
Lecture 66 Consolidating Data
Lecture 67 Data Validation
Lecture 68 Formula Auditing
Section 18: Additional Excel Features
Lecture 69 Comments
Lecture 70 Goal Seeker
Lecture 71 Text to Columns Option
Lecture 72 Watch Window
Section 19: Conclusion
Lecture 73 Closing Video
Section 20: Intro to Excel 2010 Advanced - Basic Steps for Charts & Graphs
Lecture 74 Introduction to Advanced Excel 2010
Lecture 75 READ ME: Essential Information for a Successful Training Experience
Lecture 76 Four Basic Steps When Creating Charts/Graphs
Lecture 77 Additional Features to Help Create Charts/Graphs
Lecture 78 Additional Features to Help Create Charts/Graphs Part 2
Section 21: Layout Tab
Lecture 79 Detailed Formatting for Charts/Graphs
Lecture 80 Formatting Legends within Charts/Graphs
Lecture 81 Formatting Axes and Gridlines within Charts/Graphs
Section 22: Trends
Lecture 82 Trends within Charts and Graphs
Lecture 83 Complex Trends within Charts and Graphs
Lecture 84 Trends over Time within Charts and Graphs
Section 23: Differences
Lecture 85 Showing Differences Using Bar Charts
Lecture 86 Showing Differences Using Pie Charts
Lecture 87 Limitations with Pie Charts & How to Correct
Lecture 88 Alternative Ways to Show Differences
Section 24: Relationships
Lecture 89 Using Charts & Graphs to Show Relationships Part
Lecture 90 Using Charts & Graphs to Show Relationships Part 2
Section 25: Stock
Lecture 91 Charting & Graphing Financial Information
Lecture 92 Charting & Graphing Financial Information Part 2
Lecture 93 Specific Charts for Finance Information
Lecture 94 Setting Up Live Charts
Section 26: Sparklines
Lecture 95 Using Sparklines for Data Visualization
Section 27: Data Bars & Conditional Formatting
Lecture 96 Using and Formatting Data Bars, Color Scales & Icon Sets
Section 28: Pivot Tables
Lecture 97 Setting Up Pivot Tables/Charts
Lecture 98 Setting Up Pivot Tables/Charts Part 2
Lecture 99 Filtering Pivot Tables/Charts
Lecture 100 New Features for Pivot Tables/Charts
Section 29: Graphics
Lecture 101 Graphics Tools
Lecture 102 Graphics Tools Part 2
Section 30: Exporting
Lecture 103 Exporting Charts and Graphs
Lecture 104 Exporting Charts and Graphs Part 2
Section 31: Excel 2010 Advanced Quiz
Anyone new to Microsoft Excel or upgrading from an earlier version.,Those seeking advanced Excel training.


Homepage

https://www.udemy.com/course/the-ultimate-microsoft-excel-2010-training-course/