MS Excel: Manage and Report with Microsoft Excel (Basic)
Description
In today’s data-driven world, businesses and non-profits are inundated with a vast array of statistics and information that must be tracked, managed, analyzed, and interpreted. To navigate this challenge, you need a versatile tool that simplifies your data handling without the hassle of constant re-creation. Enter Microsoft Excel—the go-to software for effective data management.
This practical, step-by-step course is designed to equip you with the foundational skills needed to master Microsoft Excel. You’ll learn how to create meaningful documents and extract valuable insights from your data, empowering you to make informed decisions.
Throughout 26 engaging tutorials, you’ll explore:
- The Excel interface and its key menus, including File, Home, Insert, Layout, Formulas, Data, Review, and View.
- Essential elements for entering and manipulating data, including the use of Excel templates and basic calculations.
- Techniques to display your analysis clearly and efficiently.
By developing your Excel skills, you’ll gain the ability to generate data on demand, enhancing your decision-making process and creating knowledge for yourself and your colleagues. This course is licenced to us by LinCademy Ltd. Join us and unlock the full potential of Microsoft Excel!
What I will learn?
- Understanding MS Excel Interface
- Working with the File and Home menus.
- Working with the Insert and Page Layout menus.
- Working with the Formulas and Data menus.
- Working with the Review and View menus.
- Working with Excel templates.
- Working with dates in Excel.
- Working with numbers in Excel.
- Working with text in Excel.
- Working with calculations in Excel.
- Understanding how to set up pages in Excel.
- Understanding how to configure print settings in Excel.
Course Content
Topic 1: Introduction
Topic 2: MS Excel Interface and File Menu
-
02:24
-
Lecture 3: Excel Interface Understanding – Part 2
02:00 -
Lecture 4: Working with File Menu – Part 1
02:40 -
Lecture 5: Working with File Menu – Part 2
03:58
Topic 3: MS Excel Home and Insert Menus
-
Lecture 6: Working with Home Menu – Part 1
02:36 -
Lecture 7: Working with Home Menu – Part 2
02:42 -
Lecture 8: Working with Insert Menu – Part 1
02:20 -
Lecture 9: Working with Insert Menu – Part 2
02:27
Topic 4: MS Excel Page Layout and Formulas Menus
-
Lecture 10: Working with Page Layout Menu – Part 1
02:18 -
Lecture 11: Working with Page Layout Menu – Part 2
02:29 -
Lecture 12: Working with Formulas Menu – Part 1
02:28 -
Lecture 13: Working with Formulas Menu – Part 2
01:47
Topic 5: MS Excel Data, Review and View Menus
-
Lecture 14: Working with Data Menu – Part 1
02:04 -
Lecture 15: Working with Data Menu – Part 2
02:48 -
Lecture 16: Working with Review Menu
02:46 -
Lecture 17: Working with View Menu
02:39
Topic 6: MS Excel Templates, Dates, Numbers and Text
-
Lecture 18: Working with Excel Templates
02:34 -
Lecture 19: Working with Dates in Excel
03:31 -
Lecture 20: Working with Numbers in Excel
04:26 -
Lecture 21: Working with Text in Excel
01:25
Topic 7: MS Excel Calculations, Page Setup, Printing & File Saving
-
Lecture 22: Working with Calculations in Excel – Part 1
01:42 -
Lecture 23: Working with Calculations in Excel – Part 2
02:57 -
Lecture 24: Page Set Up in Excel
02:19 -
Lecture 25: Print Settings in Excel
01:52
Topic 8: Conclusion
-
Lecture 26: Conclusion
01:36
Earn a certificate.
Use this verifyable certificate to demonstrate your skills and increase your chances of getting noticed.
Ratings & Reviews
-
LevelBeginner
-
Duration5 hours 30 minutes
-
Last UpdatedDecember 5, 2024
-
CertificateCertificate of completion
Description
In today’s data-driven world, businesses and non-profits are inundated with a vast array of statistics and information that must be tracked, managed, analyzed, and interpreted. To navigate this challenge, you need a versatile tool that simplifies your data handling without the hassle of constant re-creation. Enter Microsoft Excel—the go-to software for effective data management.
This practical, step-by-step course is designed to equip you with the foundational skills needed to master Microsoft Excel. You’ll learn how to create meaningful documents and extract valuable insights from your data, empowering you to make informed decisions.
Throughout 26 engaging tutorials, you’ll explore:
- The Excel interface and its key menus, including File, Home, Insert, Layout, Formulas, Data, Review, and View.
- Essential elements for entering and manipulating data, including the use of Excel templates and basic calculations.
- Techniques to display your analysis clearly and efficiently.
By developing your Excel skills, you’ll gain the ability to generate data on demand, enhancing your decision-making process and creating knowledge for yourself and your colleagues. This course is licenced to us by LinCademy Ltd. Join us and unlock the full potential of Microsoft Excel!
Materials
- Screencasting Tutorial Videos
Requirements
- No prerequisites needed.
Target Learners
- All proffesionals