Excel 2010 Advanced

Name: Excel 2010 Advanced
Rating: 4.4 (162 reviews)

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

Created byIntellezy Trainers

Last updated 5/2018

English

GermanEnglish

What you'll learn

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

Course content

9 sections • 24 lectures • 3h 8m total length

Introduction1: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.

Help with Functions4:12
Logical Functions18:42
Master Excel logic by building if and nested if statements, combine conditions with and/or, and apply countif and sumif to analyze data by criteria.
Financial Functions9:38
Explore how to use Excel's financial functions PMT, FV, and PV to model auto loans, mortgages, and savings, including monthly rate conversion and optional arguments.
Text Functions15:43
Master text functions in Excel to clean, parse, and assemble data using proper, trim, left, right, concatenate, and exact, with paste values for final results.
Lookup Functions8:36

Applying Conditional Formats6:39
Learn to use conditional formatting and sparklines in Excel 2010 to visualize inventory data, flag trends, and highlight values below a threshold with icon sets like traffic lights.
Managing Conditional Formats5:05
Creating SparkLines4:33
Learn to create sparklines in Excel 2010 advanced to visualize trends inside cells, using line, column, or win/loss sparklines with data bars.
Modifying SparkLine Styles5:06
Learn to format spark lines in Excel 2010 by switching line types, adding high and low markers, adjusting colors, and grouping or ungrouping lines.

Data Validation5:22
Master data validation in Excel to manage large data lists, enforce entry rules, and use input and error messages to prevent invalid hours in tables.
Working with Tables4:26
Explore how to organize large lists in Excel as tables, enforce unique column headings, avoid blank rows, and use built-in sort features to manage data efficiently.
Sorting a List5:06
Master multi-level sorting in Excel 2010 with list data and tables, using home, data, and design tabs; apply reverse-order tricks and case-sensitivity options to organize by product, salesperson, and sales.
Filtering Data8:46
Learn to filter data in Excel using the data tab, applying auto filters with column dropdowns to display only matching rows, use number and custom filters, and reset or print.

Creating and a Pivot Table9:57
Learn to create and manipulate pivot tables in Excel to summarize data, filter and slice results, and visualize insights with pivot charts.
Filtering and Sorting16:40
Master pivot tables in Excel 2010 advanced by using filtering, sorting, report filters, and field settings to summarize and format data effectively.
Filtering with Slicers6:07
Learn how to use Excel 2010 slicers to filter pivot tables, create a panel of buttons, perform multi-select with control-click, format slicers to match pivot styles, and manage slicer settings.
Adding a PivotChart7:50
Learn to create and customize pivot charts linked to pivot tables, including inserting, selecting styles, and using slicers to interact with sales data.

Requirements

Basic Microsoft Windows and Intermediate Microsoft Excel 2010 training or equivalent experience

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.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.

This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:

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

Excel 2010 Advanced

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Using Advanced Functions5 lectures • 57min

Conditional Formatting and SparkLines4 lectures • 21min

Managing Data4 lectures • 24min

Using PivotTables, Pivot Charts, and Slicers4 lectures • 41min

Analyzing Data2 lectures • 21min

Importing and Exporting Data3 lectures • 19min

Conclusion1 lecture • 4min