Microsoft Excel Like a Boss - 727 and 728 Certification Prep
The Excel masterclass. Get started in data analysis by getting certified in Excel.
Watch PromoLifetime access & Excel mastery - guaranteed.*
(Plus LAB's famous ongoing support.)
"Very detail oriented. Nice explanation on all topics."
- Saunak Desai
Want the recognition (or salary increase) that comes with Microsoft certification?
Looking for a career in data and wondering where to begin?
Then start here.
Join author, Microsoft Certified Trainer, and bestselling instructor Brian Culp for a comprehensive look at the skills that will get you up to speed on Microsoft Excel, and get you ready for the 77-727 exam: Excel Core Data Analysis, Manipulation, and Presentation.
Your Instructor
Over the course of 15 years, Brian has authored over 30 titles for publishers like O’Reilly, McGraw-Hill and Addison-Wesley. As a Microsoft Certified Trainer, he's taught individuals and Fortune 500 companies like Microsoft, Sprint, Sony Pictures Entertainment, and Budweiser.
His courses on Office 365 administration are featured by Microsoft on the Office 365 admin page.
Course Curriculum
-
StartNavigate Worksheets and Workbooks (8:24)
-
StartManage Columns, Rows, Sheets (4:44)
-
PreviewChange Sheet Order, Headers and Footers (4:42)
-
StartHide and Unhide Columns, Rows, Sheets (6:04)
-
StartChange Views, Zoom, Properties (6:15)
-
PreviewPrint Area, Repeating rows (5:04)
-
StartInspect a Workbook (5:50)
-
StartInsert Data in Cells and Ranges (6:49)
-
StartFormat Cells and Ranges (7:51)
-
StartSparklines and Subtotals (6:45)
-
StartConditional Formatting (7:04)
-
StartCreate and Manage Tables (7:40)
-
StartFilter and Sort a Table (5:52)
-
StartAnalyze Data with Formulas and Functions (6:41)
-
StartIF, SUMIF, AVERAGEIF (6:33)
-
StartUPPER, CONCAT, RIGHT (6:26)
-
StartCreate a Chart (6:27)
-
StartFormat Charts (6:18)
-
StartInsert and Format Objects (4:28)
Frequently Asked Questions
Another nice course. I am glad to buy courses by you. I enjoy them really. And appreciate about every single details that you give into your courses.
- Enes Karakas
*Course guarantee: For students who have completed the entire course, we guarantee certification in Excel. If you don't pass the 77-727 exam, we'll pay for your retake exam.
Thanks for considering the offer, and see you in class!