4.9
78
269
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023
Original price was: ₵350.00.₵250.00Current price is: ₵250.00.
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023
Requirements
- No Prior Excel Knowledge Required
- Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel loaded on a computer to follow along with Instructor Lectures is Recommended
What you'll learn
- Build a solid understanding of the Basics of Microsoft Excel
- Learn some of the common basic Excel functions used in the Office
- Learn how to format Data in an Excel Worksheet
- Create Basic Charts in Excel
- Learn how to work with Excel Templates
- Access to a Professional Trainer with 10+ years of Excel Training
Who this course is for:
- This Microsoft Excel course will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced, and Macros/VBA).
- If you're looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
This course includes:
- 21 hours of on-demand video
- 15 articles
- 54 downloadable resources
- Access on PC and mobile
- Full lifetime access
- Certificate of completion
Description
Microsoft Excel all-in-one Package
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023
This Microsoft Excel course combines 4 different courses.
- Microsoft Excel 101 - An Introduction to Excel
- Microsoft Excel 102 - Intermediate Level Excel
- Microsoft Excel 103 - Advanced Level Excel
- Master Microsoft Excel Macros and VBA in 6 Simple Projects
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics.
At the completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more...)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day-to-day Excel tasks by mastering the power of Macros and VBA
What's Included?
- 21+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)
- Downloadable Exercise Files to follow along and practice with
- Additional Exercise Files are provided at the end of each major section (101, 102, 103, and VBA) that you can download and practice the skills you've learned
- Section Quizzes to Test Your Knowledge of the Lecture Topics
- Forum where you can post questions, and screenshots of your progress and communicate with the instructor and fellow students in the course.
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!
Course Currilcum
-
- 4. Launching Excel Details 00:02:00
- 5. Microsoft Excel Startup Screen Details 00:03:00
- 6. Introduction to the Excel Interface Details 00:07:00
- 7. Customizing the Excel Quick Access Toolbar Details 00:03:00
- 8. More on the Excel Interface Details 00:04:00
- 9. Understanding the Structure of an Excel Workbook Details 00:04:00
- 10. Saving an Excel Document Details 00:04:00
- 11. Opening an Existing Excel Document Details 00:02:00
- 12. Common Excel Shortcut Keys Details 00:03:00
- Quiz 1: Excel Fundamentals 00:08:00
- 13. Entering Text to Create Spreadsheet Titles Details 00:08:00
- 14. Working with Numeric Data in Excel Details 00:08:00
- 15. Entering Date Values in Excel Details 00:09:00
- 16. Working with Cell References Details 00:06:00
- 17. Creating Basic Formulas in Excel Details 00:09:00
- 18. Relative Versus Absolute Cell References in Formulas Details 00:13:00
- 19. Understanding the Order of Operation Details 00:11:00
- Quiz 2: Entering and Editing Text and Formulas 00:08:00
- 29. Moving and Copying Data in an Excel Worksheet Details 00:07:00
- 30. Inserting and Deleting Rows and Columns Details 00:07:00
- 31. Changing the Width and Height of Cells Details 00:05:00
- 32. Hiding and Unhiding Excel Rows and Columns Details 00:05:00
- 33. Renaming an Excel Worksheet Details 00:03:00
- 34. Deleting an Excel Worksheet Details 00:05:00
- 35. Moving and Copying an Excel Worksheet Details 00:00:00
- Quiz 4: Modifying Worksheets Quiz 00:08:00
- 58. Viewing your Document in Print Preview Details 00:04:00
- 59. Changing the Margins, Scaling and Orientation Details 00:08:00
- 60. Excel Worksheet Margins Details 00:03:00
- 61. Working with Page Layout View Details 00:03:00
- 62. Adding Header and Footer Content Details 00:06:00
- 63. Printing a Specific Range of Cells Details 00:03:00
- Quiz 7: Printing an Excel Worksheet 00:08:00
- 67. Excel 101 – Practice What You’ve Learned67. Details 00:01:00
The lessons were very practical and easy to comprehend and follow as well.
This course was easy to understand
The lesson are very helpful.
Much detailed in a really simplified approach.
Great course!
I have completed EXCEL 101 and found it to be highly effective. The hands-on exercises were valuable for reinforcing the concepts.