Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - Level 3 - Advanced
Rating: 4.5 out of 5(31 ratings)
131 students

Microsoft Excel - Level 3 - Advanced

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae
Created byeLearnExcel
Last updated 9/2013
English

What you'll learn

  • This course introduces the power of Pivot Tables and Recording Macros. Pivot tables let us report and manipulate huge amounts of data quickly and easily. Learning the foundations of Macros can save you huge amounts of time by automating repetitive tasks.

Course content

6 sections • 31 lectures • 1h 30m total length

  • Introduction0:24

    This section includes the exercise files for Excel Level 3. Please download these before you start the course.

  • Orientation of text4:02
  • Merge and centre options4:00
  • Wrap text3:31
  • Custom formats6:34
  • Find and Select Options2:59
  • Paste special options4:32

Requirements

  • Regular exposure to Excel to an intermediate level

Description

This course covers the advanced tools in Excel. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae.

Who this course is for:

  • Anyone who has completed the Excel Level 2 course and is looking for more knowledge on Excel – in particular anyone looking to learn the foundations of working with Pivot Tables and basic Macros. If you work with Excel extensively, this course will benefit you.

Report abuse