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 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. The contents of this course include:
Video2Brain: Learn Excel 2010 (2013)
ISO | 1.28 GB | English | VIDEO2BRAIN | Incl. Project Files | Vídeo Training
Trainer: Chris Grover | Duration: 3 hrs 50 min
Publication date: Jan 31, 2013
Learn Excel 2010
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 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. The contents of this course include:
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.
The lessons are wrapped in a feature-rich interface that lets you jump to any topic and bookmark individual sections for later review. Full-Screen mode provides a hi-def, immersive experience, and Watch-and-Work mode shrinks the video into a small window so you can play the videos alongside your application. Also included are exercise files that give you an easy way to try out the techniques you learn.
System Requirements
Broadband internet connection
Up-to-date browser with Flash plug-in
Screen resolution 1024x768 or higher
Sound card with speakers or headphones attached
Pentium 4 2.6 GHz or higher, or Apple Mac G5
512 MB RAM
DESCARGAS/DOWNLOAD
Enlaces
Turbobit: | 01 | 02 | 03 | 04 |
Freakshare: | 01 | 02 | 03 | 04 |
Rapidgator: | 01 | 02 | 03 | 04 |
Uploaded: | 01 | 02 | 03 | 04 |
Contraseña/Password
www.descargasnsn.com
0 comentarios:
Publicar un comentario