This course is designed for those interested to learn about the basics of Excel 2007. Read more.
Lisa Newton, BA, MSc, FMAAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- This is for those who are beginners in Excel and want to take it further to higher intermediate level – using Excel 2007
- You should know the “basics” in Excel and we take it from near-beginner, to higher intermediate
What you’ll learn:Â
- Know how to work with Formulas and Functions
- Copy data and formats
- Learn how to use excel lists
- Know how to create charts
- Present worksheets nicely
- Save and print worksheets
Requirements:Â
- Students will need to have Excel 2007 installed, as this is the system used in the teaching
This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics – to reach a higher-intermediate level. With shortcuts, tricks and tips – you will be able to work smarter and faster.
If you want to be fairly competent on the software, then this course will be very handy. It’s a lot quicker to be shown things, than to try and muddle through and work things out by yourself. Guaranteed, there’ll be some items which we cover, that you have no idea that Excel was capable of doing!
We don’t want you to spend a day of your life in the classroom… learn quick and very useful, practical things which you can apply on your job or on your projects.
We’ll cover:
- Working with Data – using series, symbols and special characters, hide rows and freeze panels
- Formulas and Functions – Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums
- Copying Data – transposing rows into columns and paste specials
- Using Excel lists – sort and filter a list, remove duplicate records, count filtered records, look up information in a list
- Data Patterns – Pivot tables, pivot charts, what-if analysis
- Creating charts – histogram, trend lines, pie charts, error bars
- Presenting data – formatting columns and numbers
- Saving and printing worksheets – printing multiple worksheets, area, cell ranges, repeat headings of a row or column
- Extending excel – hyperlinks, embed a chart, importing a worksheet
- Customizing Excel – custom workspace, custom view, macros
The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn’t too dissimilar from 2010.
Where necessary, we provide a spreadsheet – but as long as you have Excel 2007, you’ll be able to copy and do exactly what you see on the screen by pausing the video and following along.
Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.
Our Promise to You
By the end of this course, you will have the knowledge about Excel 2007.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Excel 2007!
Course Curriculum
| Section 1 - Data | |||
| Enter Numbers And Fractions | 00:00:00 | ||
| Dates And Times | 00:00:00 | ||
| Name Cells And Ranges | 00:00:00 | ||
| Validate Data Entry Using A Pick List | 00:00:00 | ||
| Extend A Series Of Dates With Autofill | 00:00:00 | ||
| Add A Symbol Or Special Character | 00:00:00 | ||
| Compare Multiple Spreadsheets Using Freeze Panels | 00:00:00 | ||
| Hide Rows | 00:00:00 | ||
| Keyboard | 00:00:00 | ||
| Speak Cells | 00:00:00 | ||
| Find And Replace Data | 00:00:00 | ||
| Section 2 - Formulas And Functions | |||
| Add Values | 00:00:00 | ||
| Function Wizard | 00:00:00 | ||
| Formulas With Comments | 00:00:00 | ||
| OneNote | 00:00:00 | ||
| Define A Constant | 00:00:00 | ||
| Apply Names In Functions | 00:00:00 | ||
| Figure Out The Best Loan Terms | 00:00:00 | ||
| Internal Rates Of Return | 00:00:00 | ||
| Nth Largest Value | 00:00:00 | ||
| Large, Small, Max, Min | 00:00:00 | ||
| Conditional Formula | 00:00:00 | ||
| Conditional Formula With Names | 00:00:00 | ||
| Count If | 00:00:00 | ||
| Conditional Sum | 00:00:00 | ||
| Inner Calculator | 00:00:00 | ||
| Square Roots | 00:00:00 | ||
| Calculate The Duration Between Two Times | 00:00:00 | ||
| Calculate Days Between Two Dates | 00:00:00 | ||
| Section 3 - Copying Data, Formats, Etc. | |||
| Copy A Range | 00:00:00 | ||
| Transpose A Row Into A Column | 00:00:00 | ||
| Copy Styles To Another Workbook | 00:00:00 | ||
| Chart Formatting | 00:00:00 | ||
| Paste Special And Copying Worksheets | 00:00:00 | ||
| Track Changes While Editing | 00:00:00 | ||
| Section 4 - Lists | |||
| Enter List Data Using A Form | 00:00:00 | ||
| Searching Through A Data List | 00:00:00 | ||
| Import A Word List Into Excel | 00:00:00 | ||
| Sort A List | 00:00:00 | ||
| Filter A List | 00:00:00 | ||
| Sort By Multiple Criteria | 00:00:00 | ||
| Find Averages On A Sorted Group | 00:00:00 | ||
| Filter By Multiple Criteria | 00:00:00 | ||
| Remove Duplicate Records From A List | 00:00:00 | ||
| Count Filtered Records | 00:00:00 | ||
| Filter By Multiple Criteria In The Same Column | 00:00:00 | ||
| Chart A Filtered List | 00:00:00 | ||
| Look Up Information In A List | 00:00:00 | ||
| Section 5 - Data Patterns | |||
| Create A PivotTable | 00:00:00 | ||
| Modify A PivotTable And Layout | 00:00:00 | ||
| Find The Average Of A Field | 00:00:00 | ||
| Create A Calculated Field | 00:00:00 | ||
| Calculated Fields And Charts | 00:00:00 | ||
| Hide Rows And Columns On A Pivot Table | 00:00:00 | ||
| AutoFormat A PivotTable | 00:00:00 | ||
| Create A Pivot Chart | 00:00:00 | ||
| Turning On The Data Analysis Function So That Statistical Information Can Be Run | 00:00:00 | ||
| Describe Data With Statistics | 00:00:00 | ||
| Discover Associations Within Your Data | 00:00:00 | ||
| Product Numbers | 00:00:00 | ||
| What-If Analysis | 00:00:00 | ||
| Goal Seek | 00:00:00 | ||
| Section 6 - Creating Charts | |||
| Create A Chart | 00:00:00 | ||
| Modify Chart Details | 00:00:00 | ||
| Change The Chart Type | 00:00:00 | ||
| Add A Trendline To A Chart | 00:00:00 | ||
| Remove Chart Data | 00:00:00 | ||
| Add Chart Data | 00:00:00 | ||
| Missing Chart Data | 00:00:00 | ||
| Error Bars | 00:00:00 | ||
| Pull A Slice From A Pie Chart | 00:00:00 | ||
| Label Slices Of A Pie Chart | 00:00:00 | ||
| Histogram | 00:00:00 | ||
| Paste A Chard Into Word | 00:00:00 | ||
| Amending A Chart In Word | 00:00:00 | ||
| Paste-Link A Chart Into Word | 00:00:00 | ||
| Section 7 - Worksheets | |||
| Format Numbers As Percentages | 00:00:00 | ||
| Format Currencies In Currency And Accounting Formats | 00:00:00 | ||
| Format Column Headings | 00:00:00 | ||
| Format Quickly With Format Painter | 00:00:00 | ||
| Insert A Background Image Into Your Worksheet | 00:00:00 | ||
| Create A Transparent Image | 00:00:00 | ||
| Section 8 - Saving And Printing Worksheets | |||
| Save A Workbook As A Template | 00:00:00 | ||
| Save A Workbook As An XML Spreadsheet | 00:00:00 | ||
| Print Multiple Cell Ranges On One Page | 00:00:00 | ||
| Page Set Up, Header, Footer, Margins - 1 Page Printing | 00:00:00 | ||
| Print Multiple Areas Of A Workbook | 00:00:00 | ||
| Print Multiple Worksheets Of A Workbook | 00:00:00 | ||
| Repeat Headings Of A Row Or Column | 00:00:00 | ||
| Print Functions To Show Calculations And Comments | 00:00:00 | ||
| Section 9 - Extending Excel | |||
| Hyperlink A Worksheet To Another Office Document | 00:00:00 | ||
| Embed A Chart Within Powerpoint | 00:00:00 | ||
| Publish An Interactive Workbook | 00:00:00 | ||
| Importing Data From A Website Or Access Database | 00:00:00 | ||
| Import A Worksheet Into Access | 00:00:00 | ||
| Use Excel Data To Create Labels In Word | 00:00:00 | ||
| Section 10 - Customizing Excel | |||
| Launch A Specific Workbook When Excel Opens | 00:00:00 | ||
| Save Time By Creating A Custom View | 00:00:00 | ||
| Create A Custom Number format | 00:00:00 | ||
| Changing Text To Columns | 00:00:00 | ||
| Create A Macro To Format Numbers | 00:00:00 | ||
About This Course
Who this course is for:
- This is for those who are beginners in Excel and want to take it further to higher intermediate level – using Excel 2007
- You should know the “basics” in Excel and we take it from near-beginner, to higher intermediate
What you’ll learn:Â
- Know how to work with Formulas and Functions
- Copy data and formats
- Learn how to use excel lists
- Know how to create charts
- Present worksheets nicely
- Save and print worksheets
Requirements:Â
- Students will need to have Excel 2007 installed, as this is the system used in the teaching
This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics – to reach a higher-intermediate level. With shortcuts, tricks and tips – you will be able to work smarter and faster.
If you want to be fairly competent on the software, then this course will be very handy. It’s a lot quicker to be shown things, than to try and muddle through and work things out by yourself. Guaranteed, there’ll be some items which we cover, that you have no idea that Excel was capable of doing!
We don’t want you to spend a day of your life in the classroom… learn quick and very useful, practical things which you can apply on your job or on your projects.
We’ll cover:
- Working with Data – using series, symbols and special characters, hide rows and freeze panels
- Formulas and Functions – Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums
- Copying Data – transposing rows into columns and paste specials
- Using Excel lists – sort and filter a list, remove duplicate records, count filtered records, look up information in a list
- Data Patterns – Pivot tables, pivot charts, what-if analysis
- Creating charts – histogram, trend lines, pie charts, error bars
- Presenting data – formatting columns and numbers
- Saving and printing worksheets – printing multiple worksheets, area, cell ranges, repeat headings of a row or column
- Extending excel – hyperlinks, embed a chart, importing a worksheet
- Customizing Excel – custom workspace, custom view, macros
The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn’t too dissimilar from 2010.
Where necessary, we provide a spreadsheet – but as long as you have Excel 2007, you’ll be able to copy and do exactly what you see on the screen by pausing the video and following along.
Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.
Our Promise to You
By the end of this course, you will have the knowledge about Excel 2007.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Excel 2007!
Course Curriculum
| Section 1 - Data | |||
| Enter Numbers And Fractions | 00:00:00 | ||
| Dates And Times | 00:00:00 | ||
| Name Cells And Ranges | 00:00:00 | ||
| Validate Data Entry Using A Pick List | 00:00:00 | ||
| Extend A Series Of Dates With Autofill | 00:00:00 | ||
| Add A Symbol Or Special Character | 00:00:00 | ||
| Compare Multiple Spreadsheets Using Freeze Panels | 00:00:00 | ||
| Hide Rows | 00:00:00 | ||
| Keyboard | 00:00:00 | ||
| Speak Cells | 00:00:00 | ||
| Find And Replace Data | 00:00:00 | ||
| Section 2 - Formulas And Functions | |||
| Add Values | 00:00:00 | ||
| Function Wizard | 00:00:00 | ||
| Formulas With Comments | 00:00:00 | ||
| OneNote | 00:00:00 | ||
| Define A Constant | 00:00:00 | ||
| Apply Names In Functions | 00:00:00 | ||
| Figure Out The Best Loan Terms | 00:00:00 | ||
| Internal Rates Of Return | 00:00:00 | ||
| Nth Largest Value | 00:00:00 | ||
| Large, Small, Max, Min | 00:00:00 | ||
| Conditional Formula | 00:00:00 | ||
| Conditional Formula With Names | 00:00:00 | ||
| Count If | 00:00:00 | ||
| Conditional Sum | 00:00:00 | ||
| Inner Calculator | 00:00:00 | ||
| Square Roots | 00:00:00 | ||
| Calculate The Duration Between Two Times | 00:00:00 | ||
| Calculate Days Between Two Dates | 00:00:00 | ||
| Section 3 - Copying Data, Formats, Etc. | |||
| Copy A Range | 00:00:00 | ||
| Transpose A Row Into A Column | 00:00:00 | ||
| Copy Styles To Another Workbook | 00:00:00 | ||
| Chart Formatting | 00:00:00 | ||
| Paste Special And Copying Worksheets | 00:00:00 | ||
| Track Changes While Editing | 00:00:00 | ||
| Section 4 - Lists | |||
| Enter List Data Using A Form | 00:00:00 | ||
| Searching Through A Data List | 00:00:00 | ||
| Import A Word List Into Excel | 00:00:00 | ||
| Sort A List | 00:00:00 | ||
| Filter A List | 00:00:00 | ||
| Sort By Multiple Criteria | 00:00:00 | ||
| Find Averages On A Sorted Group | 00:00:00 | ||
| Filter By Multiple Criteria | 00:00:00 | ||
| Remove Duplicate Records From A List | 00:00:00 | ||
| Count Filtered Records | 00:00:00 | ||
| Filter By Multiple Criteria In The Same Column | 00:00:00 | ||
| Chart A Filtered List | 00:00:00 | ||
| Look Up Information In A List | 00:00:00 | ||
| Section 5 - Data Patterns | |||
| Create A PivotTable | 00:00:00 | ||
| Modify A PivotTable And Layout | 00:00:00 | ||
| Find The Average Of A Field | 00:00:00 | ||
| Create A Calculated Field | 00:00:00 | ||
| Calculated Fields And Charts | 00:00:00 | ||
| Hide Rows And Columns On A Pivot Table | 00:00:00 | ||
| AutoFormat A PivotTable | 00:00:00 | ||
| Create A Pivot Chart | 00:00:00 | ||
| Turning On The Data Analysis Function So That Statistical Information Can Be Run | 00:00:00 | ||
| Describe Data With Statistics | 00:00:00 | ||
| Discover Associations Within Your Data | 00:00:00 | ||
| Product Numbers | 00:00:00 | ||
| What-If Analysis | 00:00:00 | ||
| Goal Seek | 00:00:00 | ||
| Section 6 - Creating Charts | |||
| Create A Chart | 00:00:00 | ||
| Modify Chart Details | 00:00:00 | ||
| Change The Chart Type | 00:00:00 | ||
| Add A Trendline To A Chart | 00:00:00 | ||
| Remove Chart Data | 00:00:00 | ||
| Add Chart Data | 00:00:00 | ||
| Missing Chart Data | 00:00:00 | ||
| Error Bars | 00:00:00 | ||
| Pull A Slice From A Pie Chart | 00:00:00 | ||
| Label Slices Of A Pie Chart | 00:00:00 | ||
| Histogram | 00:00:00 | ||
| Paste A Chard Into Word | 00:00:00 | ||
| Amending A Chart In Word | 00:00:00 | ||
| Paste-Link A Chart Into Word | 00:00:00 | ||
| Section 7 - Worksheets | |||
| Format Numbers As Percentages | 00:00:00 | ||
| Format Currencies In Currency And Accounting Formats | 00:00:00 | ||
| Format Column Headings | 00:00:00 | ||
| Format Quickly With Format Painter | 00:00:00 | ||
| Insert A Background Image Into Your Worksheet | 00:00:00 | ||
| Create A Transparent Image | 00:00:00 | ||
| Section 8 - Saving And Printing Worksheets | |||
| Save A Workbook As A Template | 00:00:00 | ||
| Save A Workbook As An XML Spreadsheet | 00:00:00 | ||
| Print Multiple Cell Ranges On One Page | 00:00:00 | ||
| Page Set Up, Header, Footer, Margins - 1 Page Printing | 00:00:00 | ||
| Print Multiple Areas Of A Workbook | 00:00:00 | ||
| Print Multiple Worksheets Of A Workbook | 00:00:00 | ||
| Repeat Headings Of A Row Or Column | 00:00:00 | ||
| Print Functions To Show Calculations And Comments | 00:00:00 | ||
| Section 9 - Extending Excel | |||
| Hyperlink A Worksheet To Another Office Document | 00:00:00 | ||
| Embed A Chart Within Powerpoint | 00:00:00 | ||
| Publish An Interactive Workbook | 00:00:00 | ||
| Importing Data From A Website Or Access Database | 00:00:00 | ||
| Import A Worksheet Into Access | 00:00:00 | ||
| Use Excel Data To Create Labels In Word | 00:00:00 | ||
| Section 10 - Customizing Excel | |||
| Launch A Specific Workbook When Excel Opens | 00:00:00 | ||
| Save Time By Creating A Custom View | 00:00:00 | ||
| Create A Custom Number format | 00:00:00 | ||
| Changing Text To Columns | 00:00:00 | ||
| Create A Macro To Format Numbers | 00:00:00 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved