Understand the more advanced features of Excel 2003, the spreadsheet program widely used for financial and data management purposes.
Understand the more advanced features of Excel 2003, the spreadsheet program widely used for financial and data management purposes. Learn how to use array formulas, special formatting, and VLOOKUP to make tasks easier.
Skills you’ll gain
Microsoft ExcelSpreadsheetsExcel FormulasExcel ServicesExcel SolverSpreadsheetMLWhat You'll Learn
- Use array formulas to perform calculations across ranges of cells
- Apply VLOOKUP and Find functions to retrieve and locate data
- Build an amortization schedule and use cost extension calculations
- Apply special formatting and conditional formatting to spreadsheets
- Use IF statements and other functions to automate tasks
- Sort data, protect cells, and display formulas in Excel 2003
Key Takeaways
- Excel 2003 is a spreadsheet program widely used for financial and data management purposes.
- The course covers advanced Excel features including array formulas, special formatting, and VLOOKUP.
- These advanced features are presented as ways to make spreadsheet tasks easier.
- Lessons span functions such as the IF statement, VLOOKUP, and Find functions, alongside formatting and cell-protection topics.
Frequently Asked Questions
What does this course cover?
It covers the more advanced features of Excel 2003, including array formulas, special formatting, and VLOOKUP, along with topics such as sorting, functions, an amortization schedule, the IF statement, showing formulas, Find functions, protecting cells, graphing, the drawing toolbar, cell orientation, and conditional formatting.
Who is this course for?
It is intended for learners who want to understand the more advanced features of Excel 2003, the spreadsheet program widely used for financial and data management purposes.
What skills will I gain?
You will work with Microsoft Excel, spreadsheets, Excel formulas, Excel Services, Excel Solver, and SpreadsheetML.
What is the goal of learning these advanced features?
To learn how to use array formulas, special formatting, and VLOOKUP to make tasks easier.
Transcript
Show transcript (free preview lesson)
Transcript of the free preview lesson. Remaining lessons unlock with the full course.
As an intermediate user of Microsoft's Excel, it's important to be reminded of the terminology that is critical in using an application as sophisticated as Excel. The top line is the title bar, which describes the fact that we are in the Excel product, and the title of the workbook that you've created and saved or opened. Then we have a menu bar, and then we have one or more toolbars depending on the way you've decided to display your toolbars. You could have one or more of them. You could have them stacked or you could have them horizontal. We have in the left corner the name box that describes the name of a cell, either B5, or the name you've given to that cell. There is the formula bar where the formulas are displayed or the contents of the cell if it has text or numeric information in it. Then of course we have the active cells that are surrounded by a dark border and the fill handle. The column widths can be changed by dragging the divider bar between the column letters or the divider bar between the row numbers. The sheet tabs are labeled at the bottom with accelerator buttons to move between them to the end one at a time or all the way back to the beginning. With a scroll bar on the right and a scroll bar down at the bottom, and in 2003 you have the capability of entering 65,536 rows and 256 columns out to column IV. In fact, I always remember that's the last column because if I had a spreadsheet that large I would probably need an IV just to handle the spreadsheet.
Learn on the Go
Take your learning anywhere — the KnowledgeCity mobile app lets you watch lessons on the go.