Basics of Microsoft Excel
What Will I Benefit?
Provide the necessary knowledge and skills to deal with numbers, formulas, functions and graphs, using Microsoft Excel, so that you can take advantage of the capabilities and features of the program in the performing your daily work and tasks.
Course Objectives
-
At the end of this course, the participants should be able to
- Learn about the Excel interface and be able to use it
- Master the skill of designing and using workbooks and worksheets
- Working with tables and charts
- Master the skill of handling data using forms
- Designing formulas and using functions
- Print worksheets and workbooks
Target Audience
Individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.
Course Outline
5
5
Topics
-
Excel interface
- Excel interface look
- Create something
- Search for recent files
- keep connected
- Discover contextual tools
- Manage data using Excel tables
- Share work with others
- Insert functions and create formulas
- Find anything you want
- Find related information
- File tab
- Quick Access Toolbar
- The ribbon
- Design workbooks
- Status bar
- Create a workbook
- Close Excel
- Close an Excel workbook
- Save an Excel workbook
- Show and hide columns and rows
- Hide columns
- Show hidden columns
- Freeze columns and rows
- Unfreeze
- Worksheets Create and rename worksheets
- Create and rename worksheets
- Move the worksheet inside the workbook
- Enter data in the cell
- Cycle through worksheets in the same workbook
- Enter data for the cell
- Enter text or number in a cell
- Enter a fixed-decimal number
- Enter a date or time in a cell
- Enter the same data in multiple cells simultaneously
- Enter the same data on multiple worksheets simultaneously
- Better show your work (format worksheet)
- Align data within a cell
- Merge cells, rotate and wrap text
- Change the height and width of the cell
- Number format
- Format numbers as text
- Wrap text in a cell
- Enable text wrapping automatically
- Create and format tables
- Sort table data
- Steps to sort the table
- Filter data
- Data filtering
- Custom filter form
- Filter data using slicer
- Create a Chart
- Delete the chart
- Add a title and layout for the chart
- Change the layout of the outline
- Change the appearance of the layout (style)
- Add striking layout to your chart
- Reuse charts by creating charts templates
- Learn about data forms
- Add a form button to the bar
- Use a data template
- Add a new row of data
- Search for a row by navigating
- Search for a row by entering search criteria
- Change the data in a row
- Delete a row
- Close a data form
- Basic Mathematics in Excel
- Addition
- Subtraction
- Multiplication and division
- Using Functions
- Addition function
- There is no subtraction function
- Multiplication function
- There is no division function
- Sequence of arithmetic operations (priorities of arithmetic operations)
- An overview of advanced formulas
- To print your business on excel
- Select your printer type
- Select what you want to print
- Choose the page orientation
- Select the paper size
- How many copies do you want to print
- Adjust page margins
5
5
Target Competencies
- Basics of Excel
- Data Entry into Excel sheets
- Using Formulas in Excel
- Editing in Excel
5
5
Course Methodology
-
The trainer will apply the skills contained in the program, and
then the participants will work remotely to apply those skills,
each on his computer, and then the trainer will answer all the
participants' inquiries and solve the problems they face
Basics of Microsoft Excel (Virtual)
2300 SAR
3 Days
Course Dates & Locations
*Prices do not include value added tax.
For more information, do not hesitate to contact us
Find more topics about Computer Applications Courses
Advanced Microsoft Excel
(SPSS) Program Skills
Power BI