Master data entry and storage techniques using Microsoft Excel for efficient business operations
Apply Excel functions and formulas to verify and analyze business data accurately
Create and manage spreadsheets to support administrative and managerial tasks effectively
Utilize Excel for accounting, budgeting, and financial planning to enhance business financial health
Perform data analysis to identify trends, patterns, and insights for informed decision-making
Design professional reports and visualizations to communicate data findings clearly
Implement forecasting models in Excel to predict future business trends and outcomes
Use Excel tools to streamline business data collection and verification processes
Develop skills to automate repetitive tasks with macros and advanced functions in Excel
Enhance business productivity by integrating Excel with other Microsoft Office applications
Apply best practices for organizing and managing large datasets within Excel workbooks
Leverage Excel for strategic planning, scenario analysis, and operational efficiency
Course Content
المحتوى
-
Solving Real Life Problems in Excel
00:00 -
Excel Getting Started
00:00 -
Excel Creating and Opening Workbooks
00:00 -
Excel Saving and Sharing
00:00 -
Excel Cell Basics
00:00 -
Excel Modifying Columns Rows and Cells
00:00 -
Excel Formatting Cells
00:00 -
Excel Understanding Number Formats
00:00 -
Excel Working with Multiple Worksheets
00:00 -
Excel Using Find and Replace
00:00 -
Excel Page Layout and Printing
00:00 -
Excel Intro to Formulas
00:00 -
Excel Creating More Complex Formulas
00:00 -
Excel Relative and Absolute Cell References
00:00 -
Excel Functions
00:00 -
Excel Freeze Panes and View Options
00:00 -
Excel Sorting Data
00:00 -
Excel Filtering Data
00:00 -
Excel Groups and Subtotals
00:00 -
Excel Tables
00:00 -
Excel Charts
00:00 -
Excel Conditional Formatting
00:00 -
Excel Comments and Co authoring
00:00 -
Excel Inspecting and Protecting Workbooks
00:00 -
Excel Intro to PivotTables
00:00 -
Excel Doing More with PivotTables
00:00 -
Excel What if Analysis
00:00 -
Excel Quick Tip Add the Current Date to a Cell
00:00 -
Excel Quick Tip A Faster Way to Use the Fill Handle
00:00 -
Excel Quick Tip Two Ways to Use the Format Painter
00:00 -
Excel Quick Tip A Shortcut to AutoSum
00:00 -
Excel Quick Tip Quick Access Toolbar Shortcuts
00:00 -
Excel Quick Tip How to Quickly Duplicate a Sheet
00:00 -
Excel Quick Tip Jump to Any Sheet with a Shortcut
00:00 -
Excel Quick Tip Select an Entire Row or Column
00:00 -
Excel Quick Tip Find a Sum Without Using a Formula
00:00 -
Excel Quick Tip Why You Should Avoid Merging Cells
00:00 -
Excel Quick Tip Using the Quick Analysis Tool
00:00 -
Excel Quick Tip How to Make Charts Auto Update
00:00 -
Excel Quick Tip Use Transpose to Flip Data on its Side
00:00 -
Excel Quick Tip Absolute References with the F4 Key
00:00 -
Excel Quick Tip Add a New Row with a Shortcut
00:00 -
Excel Quick Tip Use an Entire Column as a Cell Range
00:00 -
Excel Quick Tip What are Named Ranges
00:00 -
Excel Quick Tip A Trick for Finding Inconsistent Data
00:00 -
Office Working with Icons
00:00 -
What s New in Office 2019
00:00 -
What is Office 365
00:00 -
Office Using the Draw Tab
00:00 -
Final Exam – Microsoft Excel

















































