Join Jennifer McBee for an in-depth discussion in this video Solution: Cells and ranges, part of Cert Prep: Excel 2013 Microsoft Office Specialist (77-420).
- [Voiceover] Welcome to my Chapter Three…challenge solution file.…Our first step is to open the 03_09 challenge file,…so I'll go ahead and navigate to my desktop…where I have my exercise files.…So our first step is to save the file to my computer…as my 03_09 challenge exercise.…I'll go to File and do Save As.…Save it right back into Chapter 3.…Type the word My, click Save.…And that first step is done.…Create a new worksheet and rename the worksheet Vendors.…
I'll go down and click on the plus sign,…right-click on the Sheet1 tab and choose Rename.…And title it Vendors.…Go back to Instructions.…Looks good, I'm going to mark that one Done.…On my new Vendors worksheet, I'm going to import…that Vendors text file into cell A1.…Go back to my Vendors worksheet and go in and click in A1.…Go to my Data tab, under get External Data,…I'll click on From Text.…In my Chapter 3 folder, here's the 03_09 Vendor file,…I'll double-click on that,…brings me into my Text Import Wizard.…
The file's delimited, looks like it's separated…
Author
Jennifer McBee
Released
4/4/2016Disclaimer: Microsoft does not produce, provide, or endorse this video training course.
The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.
- Preparing for the exam
- Understanding the registration process
- Creating new Excel workbooks and worksheets
- Formatting data
- Inserting columns and rows
- Moving data
- Applying conditional formatting
- Creating tables
- Applying formulas and functions
- Summarizing data
- Creating charts
- Taking a full-length practice exam
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome48s
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 12s
-
2. Create and Manage Workbooks and Worksheets
-
Create new workbooks3m 20s
-
-
3. Create and Modify Cells and Ranges
-
Apply conditional formatting6m 32s
-
Create and use named ranges4m 50s
-
Use Find and Replace5m 28s
-
Solution: Cells and ranges5m 57s
-
4. Create and Modify Tables
-
Create tables6m 15s
-
Modify tables4m 51s
-
-
5. Apply Formulas and Functions
-
Format with text functions7m 49s
-
6. Create Charts and Objects
-
Format charts4m 44s
-
Solution: Charts and objects4m 44s
-
7. Final Practice Exam
-
Conclusion
-
Next steps22s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Solution: Cells and ranges