Explanation course of the Excel program at the basic and intermediate level

Welcome to the course of explanations of the Excel program at the basic and intermediate level

This course is registered using Microsoft Excel 2019

Requirements to benefit from this course

• You must have computer knowledge
• It is preferable to have a copy of Microsoft Excel 2019 or Excel 365 and later in order to be able to apply what you are studying

Course Outcomes

This course will introduce you to the world of Excel in order to explore the great abilities that Excel possesses, which will help you organize your personal and practical life because the explanation will be in Arabic, and according to studies, a person understands in his mother tongue much more than any other language and mastered it

• Enable participants to create and manage Excel worksheets and pages
• Acquire the skills to customize the options and presentation of worksheets and pages and prepare them for printing
• Gain the ability to manage and insert cells and data as well as format charts and Excel tables
• Learn how to view data with tables and graphs
• Enable participants to edit images, highlight, filter, sort and group cells
• Enable participants to create formulas in Excel and generate reports using functions

Where Excel is one of the most important Microsoft Office programs in the practical field, Which creates and processes electronic tables in addition to making plans and drawings, The Excel course is designed at the basic and intermediate level “from start to professionalism” to include the principles to master all the skills to carry out various Excel operations and functions. Participants will learn data analysis, calculations, budgets, and billing. In addition to using graphical tables to perform basic and advanced calculations, Add and delete rows and columns, and prepare the worksheet for printing, and the use of functions, As well as creating matrix formulas, and make conditional formulas, Create forms and control buttons, In addition to creating and managing macros in a way that enables participants to carry out their practical tasks professionally and take full advantage of Microsoft Excel, So that he is able to create electronic tables in an easy and simplified way, know how to perform calculations on tables, and understand the program in general.

Who benefits from this course?

This course is directed to everyone who has data he wants to keep and analyze to help him make decisions, whether this data is for the home or the company in which he works or for his own business or whatever and is also directed to school and university students if they have materials about Excel within the study curriculum The language of explanation will be Arabic, but the Excel application (interfaces, screens) will be in English.

• Anyone who needs to save and analyze data on a daily basis for his personal purposes such as controlling house expenses for example
• Employees who need to make high quality reports to be presented to their managers
• Managers who need quick reports to help them make decisions
• Any human has a special work and needs to memorize and sweeten daily operations
• Students in schools and universities who take Excel related subjects

What will you learn in this course?

• Lesson One: A first look at Excel – Program Interface.
• Lesson two: Explain the Home menu in Excel.
• Lesson three: Explanation of page Layout list, Insert in Excel.
• Lesson Four: Explanation of the list of Formulas and Data in Excel.
• Lesson Five: Explanation of the Review, View and Developer menu in Excel.
• Lesson Six: Explain the basics of the worksheet in Excel.
  • • Introduction 00:00
    • Create a new workbook 00:56
    • Select Cells 02:10
    • Enter text, numbers and date in the worksheet 04:00
    • Edit cells 07:26
    • Moving between worksheets 08:04
    • Rename Worksheet 08:49
    • Preview and print the worksheet 10:19
    • Save and close the workbook 13:14
• Lesson Seven: Editing and Formatting Worksheets
  • • Edit and format worksheets 00:00
    • Digital data format (00:27 minute).
    • Insert and delete cells, rows and columns (1:01 min).
    • Cut, copy, paste and clear cells (minute 1:49).
    • Align the contents of cells (minute 2:54).
    • Adjust the size of rows and columns (12:41 min).
    • Find and replace cell contents (14:08 minute).
    • Hide and show columns, rows and workbooks (min. 15:58).
    • Create and apply conditional formats (17:37 min).
• Lesson Eight: Cell Formatting
  • • Text Formatting 00:12
    • Using Borders to Cells 00:32
    • Add shading to cells 01:30
    • Changing the Line 02:08
    • Format numbers as coins 02:36
    • Date format 03:39
    • Format Cell Borders 05:14
    • Using Format Copy 05:36
    • Add shading to cells 07:08
    • Use AutoFormat 8:5
    • Merge Cells 09:39
    • Create and apply styles 10:25

• Lesson Nine: Changing Print Options
  • • Add a header and footer to a worksheet 00:46
    • Change margins and center worksheet 05:02
    • Change the orientation and size of the worksheet 6:37
    • Add and delete page breaks 7:38
    • Set and clear print area 10:14
    • Set other printing options 11:37
    • Fixing wool and poles to appear during printing 13:09
• Lesson Ten: Using Rows, Columns, Worksheets and Workbooks
  • • Hide and show rows columns 00:16
    • Freeze columns and rows and unfreeze 02:17
    • Move between worksheets in a workbook 04:40
    • Add and delete worksheets to a workbook 06:05
    • Moving and arranging work pages or taking a copy of them 07:01
• Lesson Eleven: Performing Basic Arithmetic Operations
  • • Creating Formulas 00:12
    • Copy Formulas 01:29
    • Edit Formulas 03:53
    • Using the Sum function “AutoSum” 05:53
    • Using Date Functions
    • Automatically fill data in worksheet cells 06:19
    • Insert current date and time in cell 07:43
    • Collect or subtract dates 08:48
    • YEAR 09:48
    • MONTH 09:48
    • DAY09:48 function
    • Function TODAY09:48
• Lesson Twelve: Using Spreadsheets
  • • Create hyperlinks 00:1
    • Unhyperlink 04:35
    • Hyperlink Edit 5:11
    • Save Worksheets & Workbooks 05:45
    • Add comments to cells 06:40
    • View and edit comments 08:42
• Lesson Thirteen: Using Layouts
  • • Create charts
    • Move and resize charts 06:15
    • Edit chart titles and add labels to axes 09:30
    • Change layout types 09:50
    • Data Update & Theme Formatting 12:46
• Lesson Fourteen: Conditional Coordination
• Lesson Fifteen: Combine and merge data from several Excel files into one synchronous file.
• Lesson Sixteen: How to Use the VLOOKUP Search Function
• Lesson Seventeen : Difference between sum and subtotal sum functions
• Lesson Eighteen : Create a drop-down list in Excel Data Validation
• Lesson Nineteen: Delete Duplicates in Excel with One Click
• Lesson 20 : Uses of the SUMIF function
• Lesson Twenty One : IF function and installment alerts
• Lesson Twenty Two: Explanation of the CONCAT Text Addition Function
• Lesson Twenty Three: Search and Substitution
• Lesson Twenty Four: Using the AutoFilled Flash Fill feature in Excel
• Lesson Twenty Five: Record a macro to open specific workbooks or move between pages
• Lesson Twenty Six : Split text into different columns with Convert Text to Columns Wizard
• Lesson Twenty Seven: A new skill of Excel skills for Excel speaking professionals.
• Lesson Twenty Eight: The skill of deleting empty rows using Delete Empty Rows with these
• Lesson Twenty-Nine: The skill of locking cells in Excel to protect your formulas How to Lock Cells in Excel to Protect your Fo
• Lesson 30: Explanation of the YEARFRAC function to calculate years worked or age

• Money back guarantee.
• Access on mobile phone and TV.
• Certificate of completion.
• Full lifetime access hopefully.

WhatsApp 0096597484057
Email info@aact-web.com
——————————————————————
Follow the Arab Accountant Center for Training and Information Technology www.aact-web.com

https://www.facebook.com/aactit
Our account is on thetoy ter https://twitter.com/a_actit

Our Telegram channel https://t.me/aactit