Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions

Curs 55143 Excel Basic Workbooks Formulas and Functions

Inregistreaza-te

Module 1: Getting Started with Microsoft Office Excel

Lessons

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

After completing this module, students will be able to:

• Navigate the Excel user interface.
• Use Excel commands.
• Create and save a basic workbook.
• Enter cell data.
• Use Excel Help.

Module 2: Performing Calculations

Lessons

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas

After completing this module, students will be able to:

• Create worksheet formulas.
• Insert functions.
• Reuse formulas.

Module 3: Modifying a Worksheet

Lessons

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

After completing this module, students will be able to:

• Insert, delete, and adjust cells, columns, and rows.
• Search for and replace data.
• Use proofing and research tools.

Module 4: Formatting a Worksheet

Lessons

• Modify Fonts
• Add Borders and Colors to Worksheets
• Apply Number Formats
• Align Cell Contents
• Apply Stlyes and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

After completing this module, students will be able to:

• Modify fonts.
• Add borders and colors to worksheets.
• Apply number formats.
• Align cell contents.
• Apply styles and themes.
• Apply basic conditional formatting.
• Create and use templates.

Module 5: Printing Workbooks

Lessons

• Preview and Print a Workbook
• Define the Page Layout

After completing this module, students will be able to:

• Preview and print a workbook.
• Define the page layout.

Module 6: Managing Workbooks

Lessons

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

After completing this module, students will be able to:

• Manage worksheets.
• Manage workbook and worksheet views.
• Manage workbook properties.

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti

Cine susține cursul?

Familiarity with Microsoft Office applications – particularly Excel

Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint – Curs 55103
Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel
Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User
Curs Excel 2013 – Advanced Microsoft Excel 2013
Curs Excel 2013 PowerPivot – PowerBI
Curs 50448 Maximizing PivotTable Microsoft Excel
Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions
Curs Microsoft Excel 2016 – Incepator
Curs Microsoft Excel 2016 – Mediu
Curs Microsoft Excel 2016 – Avansat
Curs Microsoft Excel 2013 – Incepator
Curs Microsoft Excel 2013 – Mediu
Curs Microsoft Excel 2013 – Avansat
Curs Microsoft Excel 2010 – Incepator
Curs Microsoft Excel 2010 – Mediu
Curs Microsoft Excel 2010 – Avansat
Curs Microsoft Excel 2007 – Incepator
Curs Microsoft Excel 2007 – Mediu
Curs Microsoft Excel 2007 – Avansat