Mastering Excel 2010
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
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.
The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were
If you’ve mastered Microsoft Excel 2010 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, then even mastering Excel.
This is our most requested training course! If you learn to use Excel 2010, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. Of course, you may have a rudimentary knowledge of how Excel works, but if you want to learn to get the most of it, then take this course. Let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you’ve ever wanted to know about Microsoft Excel 2010, including:
·How to customize Microsoft Excel 2010 to work better for you
·Easily creating & modifying PivotTables
·The best way to create easy-to-view Charts & Graphs
·Using Conditional Formatting and Sparklines to Highlight Data Trends
·Tips & Tweaks for over 120 Excel 2010 functions and features!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Excel 2010: The Basics|
What Is Excel?Preview
Basic Text and Number Entry
The Interface: Ribbon and Quick Access Toolbar
The Interface: Status Bar and View Options
Open, Save, and AutoSave
Undo and RedoPreview
|Section 2: Text and Formatting|
Text Formatting - Part 1: Font Style, Size, Color
Text Formatting - Part 2: Alignment, Numbers
The Windows Clipboard (Paste Options)
The Office Clipboard (Advanced Cut and Paste)
Find and Replace
Spellcheck and Reference
|Section 3: Shapes and Graphics|
Shapes, Part 1: Inserting and FormattingPreview
Shapes, Part 2: Arranging and re-Shaping
Pictures: Advanced Effects
Clip Art and SmartArt
Navigating and Highlighting in a Spreadsheet
Insert, Delete, Hide, Unhide
|Section 4: Data, Formulas, and Functions|
Entering Data in SeriesPreview
Formulas - Order of Operations, Absolute vs Relative
Intro to Functions
Time and Date Functions
Formulas Tab: Text Functions
Logical, Math, and Statistical Functions
vLookup and More Functions
Formatting Cells and Ranges
|Section 5: Working with Tables|
Sorting and Filtering
Creating Pivot TablesPreview
Customizing Pivot Tables
|Section 6: Visualizing Information with Charts|
Intro To Charts
Chart Design and Styles
Optimizing Chart DataPreview
Advanced Chart Formatting
|Section 7: Advanced Features|
Customizing Your Worksheet View, Part 1
Customizing Your Worksheet View, Part 2
Advanced Worksheet Formatting
Advanced Data Copy Techniques
Transforming Data With The Clipboard
Manipulating Text With Functions
Using Data Validation
Analyzing Data: What-If Analysis / Scenario ManagerPreview
Analyzing Data: What-If Analysis / Data Tables
Analyzing Data: What-If Analysis / Goal Seek
Text To Columns
Creating Random Numbers and Custom Series
Calculating Functions Across Multiple Workbooks
Customizing The Ribbon and Quick Access Toolbar
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.