During this excellent Excel 2007: Advanced course is intended to take your knowledge of Excel to the next level! If you’re an intermediate user of Excel 2007, or if you’ve just updated to Excel 2007, then this course contains all the information you need, and it will help you to get up to speed with all the advanced features and functions of Excel 2007. Learners of this Excel 2007: Advanced course will be taught by an expert instructor who has years of experience and tons of insider tips and tricks to share with you. Be guided through all the more advanced features of Excel 2007, like creating pivot tables and macros, and understand how to streamline your next data analysis project.
Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).
Bill Jelen is the host of MrExcel.com and the author of sixteen books about Microsoft® Excel® including Special Edition Using Excel 2007, Excel 2007 Miracles Made Easy, Pivot Table Data Crunching for Excel 2007, VBA & Macros for Microsoft Excel, Excel for Marketing Managers and Guerilla Data Analysis Using Microsoft Excel. He has made over 50 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
Those who successfully pass this course will be awarded a Excel 2007: Advanced certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.
This excellent Excel 2007: Advanced course will qualify you to be an Executive Assistant. As an Executive Assistant you’ll usually be working in an office as part of a team, you’ll work under more senior members of staff and can work your way up the company, so pay will go up with experience. The average salary of an Executive Assistant in the UK is £30,627, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:
1: Summarizing Data | |||
1. Advanced Subtotals | |||
2. Formatting the Subtotal Rows | |||
3. Adding and Copying with Subtotals | |||
4. Consolidating Data | |||
5. Introducing the SUMIF Command | |||
6. Working with the SUMIF Command | |||
7. Using Array Formulas | |||
8. Looking at AutoSum Tricks | |||
9. Utilizing Fill Handle Tricks | |||
2: Working With Pivot Tables | |||
1. Creating a Pivot Table | |||
2. Rearranging Fields in a Pivot Table | |||
3. Explaining the Report Layout Options | |||
4. Using the Report Filters Feature | |||
5. Using Top 10 & Date Filters | |||
6. Handling Blank Cells | |||
7. Drilling Down in the Pivot Table | |||
8. Sorting a Pivot Table | |||
9. Formatting a Pivot Table | |||
10. Creating Custom Formats | |||
11. Explaining the Grouping Options | |||
12. Adding Formulas to a Pivot Table | |||
13. Changing a Calculation in a Pivot Table | |||
14. Replicating a Pivot Table | |||
15. Counting with a Pivot Table | |||
16. Using Pivot Charts | |||
3: Charting In Excel | |||
1. Charts Refresher | |||
2. Moving, Sizing & Copying Charts | |||
3. Formatting Charts | |||
4. Formatting a Series | |||
5. Exploring the Home & Format Ribbons | |||
6. Deciding What Chart Format to Use | |||
7. Show a Time Series with Column or Line Charts | |||
8. Using Combination Charts | |||
9. Using Line Chart Accessories | |||
10. Using Bar Charts to Show Comparisons | |||
11. Using Component Charts | |||
12. Using Correlation Charts | |||
13. Exploring Other Charts | |||
14. Chart Lies Revealed & Advanced Chart Types | |||
15. Creating a Custom Layout | |||
4: Getting Visual | |||
1. Using Conditional Formatting | |||
2. Using Advanced Conditional Formatting | |||
3. Highlighting, Sorting & Filtering Columns | |||
4. Using SmartArt Functions | |||
5. Using Different SmartArt Graphics | |||
6. Embedding a Formula into a Shape | |||
5: Creating Powerful Formulas | |||
1. Using Goal Seek to Find an Answer | |||
2. Auditing Formulas | |||
3. Shrinking the Formula Bar | |||
4. Understanding Errors | |||
5. Joining Text Columns | |||
6. Using Custom Formatting Codes | |||
7. Pasting Values | |||
8. Using Paste Special | |||
9. Breaking Apart Text | |||
10. Converting Text to Numbers | |||
11. Using Date Functions | |||
12. Using Bizarre Date Functions | |||
13. Using Exponents | |||
14. Using the VLOOKUP Function | |||
15. Using Index Match | |||
16. Using the Offset Function | |||
17. Using the Convert Function | |||
18. Looking at Interesting but Obscure Functions | |||
19. Using the Rand Function | |||
20. Working with Regression | |||
21. Ranking & Sorting Formulas | |||
6: Recording Macros | |||
1. Displaying the Developer Tab | |||
2. Recording a Simple Macro | |||
3. Simplifying the Macro | |||
4. Recording Using Relative References | |||
7: Tips & Tricks | |||
1. Showing Off New Tips in Excel 2007 | |||
2. Tips for Handling Worksheets | |||
3. Using Excel as a Word Processor | |||
4. Miscellaneous Tips | |||
5. Validating Data | |||
6. Changing Text Entry Direction | |||
7. Using Speak Cells | |||
8. Final Comments & Credits |