Excel 2007: Advanced

Rapid Skillz

Course

Online

£ 37.48 VAT inc.

*Indicative price

Original amount in USD:

$ 47

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

Now that you have your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Microsoft Excel 2007: Essentials, you’re ready to dive into the advanced capabilities.
Sit back and discover how to unleash the power of Excel with this in-depth video series, Microsoft Excel 2007: Advanced. While creating pivot tables and macros seems daunting, you’ll be at ease learning some new techniques that will streamline your next data analysis project.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by color.
Master pivot tables to summarize a million rows of transactional data into a flexible summary without writing a single formula.
Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don’t work and the one setting to change to allow many recorded macros to work.
See how to use the three new charting ribbon tabs to quickly format a chart or how to use the dialog boxes to coax charts out of Excel that don’t look like Excel charts. You’ll discover how to make charts in your company’s colors with one keystroke.
Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarize data and when to use each method.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Microsoft excel training
  • Microsoft Excel
  • Excel
  • Conditional Formatting
  • Data tables
  • Pivot tables
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Excel Productively
  • Simulations

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

Chapter I: SUMMARIZING DATA (58 min)
  • Advanced Subtotals
  • Formatting the Subtotal Rows
  • Adding and Copying with Subtotals
  • Consolidating Data
  • Introducing the SUMIF Command
  • Working with the SUMIF Command
  • Using Array Formulas
  • Looking at AutoSum Tricks
  • Utilizing Fill Handle Tricks
Chapter II: WORKING WITH PIVOT TABLES (52 min)
  • Creating a Pivot Table
  • Rearranging Fields in a Pivot Table
  • Explaining the Report Layout Options
  • Using the Report Filters Feature
  • Using Top 10 & Date Filters
  • Handling Blank Cells
  • Drilling Down in the Pivot Table
  • Sorting a Pivot Table
  • Formatting a Pivot Table
  • Creating Custom Formats
  • Explaining the Grouping Options
  • Adding Formulas to a Pivot Table
  • Changing a Calculation in a Pivot Table
  • Replicating a Pivot Table
  • Counting with a Pivot Table
  • Using Pivot Charts
Chapter III: CHARTING IN EXCEL (75 min)
  • Charts Refresher
  • Moving, Sizing & Copying Charts
  • Formatting Charts
  • Formatting a Series
  • Exploring the Home & Format Ribbons
  • Deciding What Chart Format to Use
  • Show a Time Series with Column or Line Charts
  • Using Combination Charts
  • Using Line Chart Accessories
  • Using Bar Charts to Show Comparisons
  • Using Component Charts
  • Using Correlation Charts
  • Exploring Other Charts
  • Chart Lies Revealed & Advanced Chart Types
  • Creating a Custom Layout
Chapter IV: GETTING VISUAL (28 min)
  • Using Conditional Formatting
  • Using Advanced Conditional Formatting
  • Highlighting, Sorting & Filtering Columns
  • Using SmartArt Functions
  • Using Different SmartArt Graphics
  • Embedding a Formula into a Shape
Chapter V: CREATING POWERFUL FORMULAS (85 min)
  • Using Goal Seek to Find an Answer
  • Auditing Formulas
  • Shrinking the Formula Bar
  • Understanding Errors
  • Joining Text Columns
  • Using Custom Formatting Codes
  • Pasting Values
  • Using Paste Special
  • Breaking Apart Text
  • Converting Text to Numbers
  • Using Date Functions
  • Using Bizarre Date Functions
  • Using Exponents
  • Using the VLOOKUP Function
  • Using Index Match
  • Using the Offset Function
  • Using the Convert Function
  • Looking at Interesting but Obscure Functions
  • Using the Rand Function
  • Working with Regression
  • Ranking & Sorting Formulas
Chapter VI: RECORDING MACROS (18 min)
  • Displaying the Developer Tab
  • Recording a Simple Macro
  • Simplifying the Macro
  • Recording Using Relative References
Chapter VII: TIPS & TRICKS (28 min)
  • Showing Off New Tips in Excel 2007
  • Tips for Handling Worksheets
  • Using Excel as a Word Processor
  • Miscellaneous Tips
  • Validating Data
  • Changing Text Entry Direction
  • Using Speak Cells
  • Final Comments & Credits

Additional information

LENGTH

Total Run Time: 6 hrs

See related categories

Excel 2007: Advanced

£ 37.48 VAT inc.

*Indicative price

Original amount in USD:

$ 47

The best Excel courses

See all

See all