Library

Course: Excel Certification - Pass the 727 Exam & Start your Career in Data Analytics!

Excel Certification - Pass the 727 Exam & Start your Career in Data Analytics!

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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.

There's a reason why Brian's Microsoft Office courses are among the best-selling on the planet. Here's what others are saying:

"Excellent content! Just what I was looking for to enhance productivity at the office." -Paige Popejoy

"Great personality and explained things well. Felt like he was at my desk explaining it to me." -William Potts

"I can't believe how much I learned. The instructor is great and the lessons were so easy to follow." -Sherie L.

"Very precise, clear and constructive." -Forent Sidler

"Perfect." -Yvonne Belo

In short, Excel is the most in commonly used and in-demand tool for making sense of data. And when you start to master that data analysis power, you'll be a sought-after employee, which ultimately means that you can EARN MORE MONEY!.

Plus, you're always covered by the full refund policy.

If you're ready to chart a course for new opportunities, enroll now, and I'll see you in class!

Brian.

Basic knowledge
  • It is not necessary, but students will be best served by having an install of Project on their PC
  • Either the Standard or Professional editions will do for this course
What you will learn

The topics of this Microsoft Excel course map to the 77-727 objectives, meaning that the following tasks are covered:

  • Creating, navigating, and formatting worksheets and workbooks
  • Configuring views, print options, and worksheet security
  • Managing data in cells and ranges
  • Using sparklines and conditional formatting
  • Using tables to quickly sort and filter data
  • Performing basic data analysis with functions and formulas
  • Adding charts and modifying chart elements
  • Inserting text boxes and other graphical elements
Curriculum
Number of Lectures: 23
Total Duration: 02:21:29
Excel 77-727: Learn Core Data Analysis and Data Presentation Skills
  • Tour the Excel Interface  
  • Create and Manage Workbooks  
  • Data Entry Essentials  
  • Shortcut Guide and Other Course Resources  

    Attached you'll find the shortcut guide and a starting spreadsheet you can use for following along.


    (Note that the beginning spreadsheet will need to first be un-archived from its .zip file.)

  • Navigate Worksheets and Workbooks  
  • Manage Columns, Rows, and Sheets  
  • Change Sheet Order, Headers and Footers  
  • Hide and Unhide Columns, Rows, and Sheets  
  • Change Views, Zoom, and Workbook Properties  
  • Print Area, Repeating Rows  
  • Inspect a Workbook  
  • Insert Data in Cells and Ranges  
  • Format Cells and Ranges  
  • Sparklines and Subtotals  
  • Conditional Formatting  
  • Create and Manage Tables  
  • Filter and Sort a Table  
  • Analyze Data with Formulas and Functions  
  • Use the IF, SUMIF, AVERAGEIF Functions  
  • Use the UPPER, CONCAT, RIGHT Functions  
  • Create a Chart  
  • Format Charts  
  • Insert and Format Objects  
Reviews (0)