Course Description
This course is for
the benefit of everyone. If financial constraints prevent you from
enrolling, simply send me a message and I will give you access to all of
my courses for free.
This training
provides you everything you need to know about Microsoft Excel. From the
fundamentals, to the most advanced features, after taking this online
class you will be able to use Microsoft Excel at an expert level.
You can learn Microsoft Excel easily and quickly if it is taught
correctly. Developed by a Microsoft Certified Master Instructor, this
course covers the most recent version of Microsoft Excel for the Mac -
Microsoft Excel 2011. As tenured college faculty in computer information
technology, and with over fifteen years of experience teaching
individuals of all ability levels "how to use" Microsoft Excel, Todd
McLeod has designed, refined, and perfected a method for understanding
Excel which will allow you to learn what you need to know about
Microsoft Excel as quickly and efficiently as possible.
With over five hours of video, you will learn all of the following about Microsoft Excel:
- Learn how to navigate around Excel
- Learn how to enter and edit data in Excel
- Learn how to adjust the way data and information are displayed in Excel
- Learn how to write formulas quickly and easily with the point-and-click method
- Learn how to use relative, absolute, and mixed references in Excel
- Learn how to create powerful calculations with Excel functions
- Learn how to visually represent your data with charts and graphs in Excel
- Learn how to use Excel data tools like sorting, subtotaling, and filtering
- Learn how to "freeze columns and rows" with freeze panes in Excel
- Learn how to remove duplicates from data in Excel
- Learn how to "transpose data" - switching the columns and rows in Excel
- Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
- Learn how to format worksheets in Excel for impact and appeal
- Learn how to automate Excel tasks with time-saving macros
- Learn how to integrate Microsoft Excel with Microsoft Word
- Learn how to use passwords in Excel to protect your work in multiple scenarios
- Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
- Learn how to use printing and sharing in Excel
- Learn how to harvest data from the web
- Learn how to create online forms which allow you to gather data from individuals
- Learn how to use templates to quickly create stunning spreadsheets
- As a bonus, you can download all of the Excel project files used in the videos so that you can get a “hands-on” approach to learning the material
This class is
guaranteed to teach you Microsoft Excel. Once enrolled, you will have
access to this Excel course for the rest of your life. You will always
be able to come back to this Excel class to review material or to learn
new material about how to use Excel. Described as “fun” and “amazing”
and “life changing,” Todd McLeod’s Excel training will forever transform
the way you work with numbers. Try this course for yourself and see how
quickly and easily you too can learn Microsoft Excel.
Curriculum
You Are Amazing
Absolute References
Academic Discounts & Student Pricing
Arrows, Circles, & Shapes
Border & Fill
Calculating Your Grade
Chart Types
Charts
Conditional Formatting
Content & Form
Copying Data From The Web
Create A Loan Amortization Schedule
Creating Charts - Area Stacked Chart
Creating Charts - Bar Chart
Creating Charts - Column Chart
Creating Charts - Combo Chart (AWESOME!!!)
Creating Charts - Line Chart
Creating Charts - Pie Chart
Creating Charts - Pivot Charts
Creating Charts - Scatter Charts
Creating Charts - Sparklines
Creating Charts - Troubleshooting Charts
Creating Pivot Tables
Data & Excel - Google Adwords Example
Data Tables
Extracting Data From The Web
Filtering Data
Formatting Tour
Freeze Panes
Functions
Future Value Functions & Pensions
Gathering Data With Online Forms
Gradebook & VLookup
Headers, Footers & Page Numbers
Home Ribbon Formatting
Inserting & Formatting Images
Inserting Media
Integrating Word & Excel
Intro to Formatting
Introduction to Charts (graphs)
Introduction to Data
Introduction To Excel
Introduction to Functions
Introduction to Pivot Tables
Investment Amortization
Join Me In My Other Courses!
Locating Files Used In Course
Locking & Securing Worksheets
Macros
Macros Illustrated
Mouse Pointer Awareness
MS Office Versions & MS Office 365
Not Creating A Macro
Page Layout
Page Setup
Payment Functions and Loans
Pivot Charts & Slicers
Pivot Table Examples
Pivot Table Grouping
Predefined Styles
Printing Introduction
Refreshing Pivot Tables
Relative References
Relative, Absolute, and Mixed References
Removing Duplicates
Right-Clicking for Formatting
Saving Time With Templates
Scaling Content
Section 1 Review
Section 1: Course Information
Section 10 Review
Section 10: Excel Errata
Section 11: Farewell
Section 2 Review
Section 2: Quick Start
Section 3 Review
Section 3: Getting Started
Section 4 Review
Section 4: Working With Functions
Section 5 Review
Section 5: Creating Charts & Graphs
Section 6 Review
Section 6: Working With Data
Section 7 Review
Section 7: Going Pro With Pivot Tables
Section 8 Review
Section 8: Formatting For Impact
Section 9 Review
Section 9: Printing
Securing Workbooks
Sorting Data
Subtotaling Data
Textboxes & Hyperlinks
The "IF" Function
The "IfError" Function
The Basics of Creating Charts
Transposing Data
Video Settings
Welcome
Word Art
Writing Formulas
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
