Lynda - Excel 2013 Prepare for the Microsoft Office Specialist Certification Exam 77-420

1. 049 Solution - Full-length practice exam.mp4104.36MB
2. 042 Solution - Formulas and functions.mp432.13MB
3. 039 Utilize conditional logic in functions.mp429.8MB
4. 020 Solution - Worksheets and workbooks.mp424.62MB
5. 031 Create tables.mp424.32MB
6. 022 Move data between cells, worksheets, and workbooks.mp423.95MB
7. 033 Filter and sort tables.mp422.99MB
8. 026 Apply conditional formatting.mp422.77MB
9. 030 Solution - Cells and ranges.mp420.4MB
10. 024 Resize cells to accommodate text.mp420.32MB
11. 038 Summarize data using functions.mp419.09MB
12. 040 Use the CONCATENATE function to combine text.mp418.79MB
13. 043 Create charts and add data series.mp418.72MB
14. 023 Format worksheets using merge, cell styles, and number formats.mp418.63MB
15. 028 Use Find and Replace.mp417.67MB
16. 035 Solution - Create and modify tables.mp417.47MB
17. 032 Modify tables.mp417.36MB
18. 017 Configure worksheets and workbooks for printing.mp417.28MB
19. 045 Insert and format graphic objects.mp416.48MB
20. 025 Format cells using merge and align options.mp415.99MB
21. 018 Add values to workbook properties.mp415.31MB
22. 047 Solution - Charts and objects.mp415.24MB
23. 036 Use relative and absolute references in formulas.mp414.47MB
24. 021 Use Append to insert data into cells.mp414.25MB
25. 015 Insert headers and footers into worksheets.mp412.79MB
26. 044 Format charts.mp412.06MB
27. 027 Create and use named ranges.mp412.01MB
28. 009 Add, copy, and move worksheets.mp411.1MB
29. 013 Format using styles or themes.mp410.52MB
30. 011 Use named ranges in navigation and formulas.mp410.35MB
31. 014 Format using the Page Layout ribbon.mp49.49MB
32. 016 Insert columns and rows; hide and unhide data.mp49.08MB
33. 008 Create new workbooks.mp48.76MB
34. 012 Use Find and Replace for conditional formatting and data validation.mp48.47MB
35. 037 Understand the order of operations in formulas.mp48.19MB
36. 007 Exam format and registration process.mp47.04MB
37. 010 Use hyperlinks to navigate workbooks.mp46.55MB
38. 001 Welcome.mp46.03MB
39. 006 Prepare for the exam.mp45.19MB
40. 005 Compare the different Microsoft Office Specialist certifications.mp44.05MB
41. 019 Challenge - Worksheets and workbooks.mp43.68MB
42. 041 Challenge - Formulas and functions.mp43.11MB
43. 046 Challenge - Charts and objects.mp42.5MB
44. 048 Challenge - Full-length practice exam.mp42.2MB
45. 034 Challenge - Create and modify tables.mp41.58MB
46. 029 Challenge - Cells and ranges.mp41.39MB
47. 050 Next steps.mp41.17MB
48. 003 Using the exercise files.mp41.03MB
49. 004 Using the challenges.mp4779.81KB
50. 002 What you should know before watching this course.mp4625.67KB