Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
1 reviews
TAUGHT BY
  • CompuWorks Trainers Computer Training Specialists

    CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools.  CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.

WHAT'S INSIDE
  • Lifetime access to 24 lectures
  • 3+ hours of high quality content
  • A community of 100+ students learning together!
SHARE

Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
1 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

Learn and practice real-world skills and achieve your goals.

COURSE DESCRIPTION

This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications.

    • Basic Microsoft Windows and Intermediate Microsoft Excel 2010 training or equivalent experience
    • Over 24 lectures and 3 hours of content!
    • Use several different types of advanced functions
    • See the benefits of conditional formatting
    • Use Excel as a simple database
    • Mine business intelligence from your data with PivotTables and PivotCharts
    • Be able to import and export data
    • Students who understand the basics of Excel formulas, functions and data collection and are now ready to expand their skills and learn to use tools for gleaning information from their data

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction
  • 1
    Introduction
    01:48
    If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  
  • SECTION 2:
    Using Advanced Functions
  • 2
    Help with Functions
    04:12
  • 3
    Logical Functions
    18:42
  • 4
    Financial Functions
    09:38
  • 5
    Text Functions
    15:43
  • 6
    Lookup Functions
    08:36
  • SECTION 3:
    Conditional Formatting and SparkLines
  • 7
    Applying Conditional Formats
    06:39
  • 8
    Managing Conditional Formats
    05:05
  • 9
    Creating SparkLines
    04:33
  • 10
    Modifying SparkLine Styles
    05:06
  • SECTION 4:
    Managing Data
  • 11
    Data Validation
    05:22
  • 12
    Working with Tables
    04:26
  • 13
    Sorting a List
    05:06
  • 14
    Filtering Data
    08:46
  • SECTION 5:
    Using PivotTables, Pivot Charts, and Slicers
  • 15
    Creating and a Pivot Table
    09:57
  • 16
    Filtering and Sorting
    16:40
  • 17
    Filtering with Slicers
    06:07
  • 18
    Adding a PivotChart
    07:50
  • SECTION 6:
    Analyzing Data
  • 19
    Auditing and Error Checking
    09:26
  • 20
    Using the Scenario Manager and Goal Seek
    11:39
  • SECTION 7:
    Importing and Exporting Data
  • 21
    Transferring between Word and Excel
    10:43
  • 22
    Importing a Text File
    04:08
  • 23
    Transferring between Access and Excel
    04:17
  • SECTION 8:
    Conclusion
  • 24
    Conclusion
    03:43

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 0
  • 1
  • 0
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
1
  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED:
MORE FROM CompuWorks Trainers