Excel in Microsoft Excel 1: beginner to Excel intermediate

Unlock Your Microsoft Excel Skills: Master Data Analysis & Become Certified

Ready to take your Excel skills to the next level? This comprehensive course equips you with the knowledge and abilities to excel in Microsoft Excel, preparing you for the official Microsoft Excel Specialist exam. While recorded on Excel 2016 and Excel 2010, the content is applicable to Excel 2013, Excel 2007, and even Excel 365.

Boost Your Resume & Career Prospects

Demonstrate your proficiency with a valuable certification. A strong Excel skillset is highly sought after by employers. This course helps you move beyond basic Excel functionality and achieve a higher level of expertise – going from Level 3 to Level 5!

What You'll Learn (11.5 Hours of Video Content)

• Worksheet & Workbook Management: Learn to create, manage, and organize your Excel files.
• Formatting & Customization: Master Excel formatting options to create professional-looking spreadsheets.
• Data Management: Efficiently insert data, format cells and ranges, and summarize data using Excel.
• Table Mastery: Create, manage, filter, and sort Excel tables for powerful data analysis.
• Formulas & Functions: Utilize essential Excel formulas and functions like COUNTIF, SUMIF, and MIN to perform calculations and analysis. Translations available in 15 languages!
• Charting & Object Insertion: Create compelling charts and insert objects to visualize your data effectively.
• Advanced Functions: Explore powerful functions like VLOOKUP, OFFSET, and INDIRECT.
• Pivot Tables & Sparklines: Discover the power of Pivot Tables and Sparklines for insightful data summaries.

Exam Preparation: Microsoft Certificate 77-602, 77-882, 77-420, 77-727

This course directly addresses the skills assessed in the Microsoft Certificate exams:

• 77-602 (Excel 2007)
• 77-882 (Excel 2010)
• 77-420 (Excel 2013)
• 77-727 (Excel 2016 Core)

Who Should Take This Course?

• Individuals seeking to enhance their Microsoft Excel skills.
• Those preparing for the Microsoft Office Specialist (MOS) Excel certification.
• Anyone wanting to leverage Excel for data analysis and reporting.
• Users of Excel 2007, 2010, 2013, 2016, or Excel 365.

Course Structure:

The course is structured with clear, sequential modules, each divided into concise 5-7 minute lectures. Allow approximately 11 hours to complete the core content, plus additional time for practice and self-assessment.

Why Choose This Course?

• Expert Instruction: Learn from an experienced instructor with in-depth Excel knowledge.
• Practical Exercises: Reinforce your learning with precise and well-designed exercises.
• Language Support: Benefit from language sheets for learners who prefer non-English versions.
• Proven Results: See what our students are saying! (See Reviews below)

Don't just use Excel – master it! Enroll today and unlock your potential.

Reviews:

"The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent" -- Daniel Sandberg

"This is super helpful to me. I'm learning things I didn't know existed in Excel." - Jimmy Thrower

"I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip's courses." - Rick Romero