video2brain - Learn Excel 2010
video2brain - Learn Excel 2010 | 1.12GB
Duration: 3h 52m | Video: AVC (.mp4) 1280x720 25fps | Audio: AAC 44.1KHz stereo
Genre: eLearning | Level: Beginner | Language: English
Duration: 3h 52m | Video: AVC (.mp4) 1280x720 25fps | Audio: AAC 44.1KHz stereo
Genre: eLearning | Level: Beginner | Language: English
Acquire Solid Spreadsheet Skills
Excel is the industry-standard spreadsheet program, and almost all of us find ourselves using it at one point or another. In this workshop veteran author Chris Grover teaches you the fundamental skills you need to work with Excel, starting with basics like entering and formatting numbers and text, then moving on to writing formulas and using Excel’s built-in functions. You’ll learn about sorting, filtering, and lookup, as well as charts, graphs and sparklines, and even advanced tools like goal seeking and pivot tables. Along the way, you’ll become familiar with the new features in Excel 2010 and learn techniques for troubleshooting your spreadsheet when something goes wrong.
In this course you’ll learn the fundamentals of Microsoft Excel 2010.
Understanding Excel and Its User Interface
In this chapter you’ll be introduced to Excel and its interface, including the Backstage view, the Ribbon, the Quick Access Toolbar, and more.
Getting Started with Basic Tasks in Excel
In this chapter you’ll learn how to perform basic tasks like creating a workbook from a template; adding, copying, and removing worksheets; moving around within your workbooks and worksheets; and more.
Developing Your Spreadsheet
This chapter gets into the nitty-gritty of working with content in your spreadsheet. You'll learn how to add and format text and numbers; use AutoSum and references; cut, copy, and paste; and more.
Creating More Complex Formulas
The real power of Excel comes from what you can do with formulas. This chapter looks at writing, using, formatting, and troubleshooting formulas.
Making Changes to Your Workbook
Sooner or later you’ll find that you want to make changes to your workbook, and this chapter will show you how. You’ll learn how to move, add, remove, and merge cells, rows, and columns, as well as how to add comments to your worksheets.
Visualizing Your Data with Color, Charts, and Graphics
If you’d like to jazz up your worksheets with colors, charts, photos, and graphics, this chapter will show you how.
Analyzing Data
Excel offers some powerful tools for data analysis. In this chapter we’ll look at creating a data table or pivot table, sorting and filtering data, importing data from an outside source, and more.
Printing and Sharing Your Worksheet
In this chapter you’ll learn about Excel’s options for printing your worksheets and sharing them with others via email.
Project files are not included
In this chapter you’ll be introduced to Excel and its interface, including the Backstage view, the Ribbon, the Quick Access Toolbar, and more.
Getting Started with Basic Tasks in Excel
In this chapter you’ll learn how to perform basic tasks like creating a workbook from a template; adding, copying, and removing worksheets; moving around within your workbooks and worksheets; and more.
Developing Your Spreadsheet
This chapter gets into the nitty-gritty of working with content in your spreadsheet. You'll learn how to add and format text and numbers; use AutoSum and references; cut, copy, and paste; and more.
Creating More Complex Formulas
The real power of Excel comes from what you can do with formulas. This chapter looks at writing, using, formatting, and troubleshooting formulas.
Making Changes to Your Workbook
Sooner or later you’ll find that you want to make changes to your workbook, and this chapter will show you how. You’ll learn how to move, add, remove, and merge cells, rows, and columns, as well as how to add comments to your worksheets.
Visualizing Your Data with Color, Charts, and Graphics
If you’d like to jazz up your worksheets with colors, charts, photos, and graphics, this chapter will show you how.
Analyzing Data
Excel offers some powerful tools for data analysis. In this chapter we’ll look at creating a data table or pivot table, sorting and filtering data, importing data from an outside source, and more.
Printing and Sharing Your Worksheet
In this chapter you’ll learn about Excel’s options for printing your worksheets and sharing them with others via email.
Project files are not included
video2brain - Learn Excel 2010
No mirrors below please.