COURSES

Microsoft Excel: Problem Solving

Course Code

116940

Review
5/5

$120

Spreadsheets are surprisingly helpful when given mathematical problems are faced, in everyday life situations. The ribbon is a command bar that organises the features of an application into a series of tabs at the top of the application window known as the toolbar menus in Excel.

If your workbook contains a lot of content, it can sometimes be difficult to compare different sections. Excel includes additional options to make your workbooks easier to view and compare. Formulas in Excel are useful to perform various mathematical, statistical, and logical operations. You can type in a formula, or you can use Excel’s pre-set formulas called functions. Applying effects as borders and fill colours and different cell styles to a spreadsheet to improve the presentation of thereof.

What you will learn in this course!

  • Prepare and produce a spreadsheet to provide a solution to a given problem.
  • Adjust settings to customise the view and preferences of the spreadsheet application.
  • Work with multiple worksheets.
  • Apply formulas to worksheets to provide alternative solutions to a problem.
  • Apply simple built-in functions of the spreadsheet application to the given problem.
  • Apply formatting to a spreadsheet applicable to the given problem.
  • Use special effects to improve the presentation of the spreadsheet.
  • Evaluate a spreadsheet.

Who this course is for?

This is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

INTRODUCTION

  • Outcomes
    • Prepare and produce a spreadsheet to provide a solution to a given problem.
    • Adjust settings to customise the view and preferences of the spreadsheet application to suit the solution created for the given problem.
    • Work with multiple worksheets to suit the solution to the given problem.
    • Apply formulas to worksheets to provide alternative solutions to the given problem.
    • Apply simple built-in functions of the spreadsheet application to the given problem.
    • Apply formatting to a spreadsheet applicable to the given problem.
    • Use special effects to improve the presentation of the spreadsheet.
    • Evaluate a spreadsheet to comply with the given problem.

 

PREPARE AND PRODUCE A SPREADSHEET BY ADDING FORMULA TO PROVIDE A SOLUTION TO A PROBLEM

  • Outcome
    • Prepare and produce a spreadsheet to provide a solution to a given problem.
  • Introduction to Spreadsheets

 

ADJUST SETTINGS TO CUSTOMISE THE VIEW AND PREFERENCES OF THE SPREADSHEET APPLICATION

  • Outcome
    • Adjust settings to customise the view and preferences of the spreadsheet application to suit the solution created for the given problem.
  • Adjusting the toolbar menus in Excel
  • Changing the size of view in Excel
  • Changing the view of your spreadsheet
  • Freezing cells, rows, and columns
  • Changing file location
  • Changing the username and altering properties

 

WORK WITH MULTIPLE WORKSHEETS TO SUITE THE SOLUTION TO THE GIVEN PROBLEM

  • Outcome
    • Work with multiple worksheets to suit the solution to the given problem.
  • Altering the view options
  • Why work with multiple worksheets?

 

APPLY FORMULA TO WORKSHEETS TO PROVIDE ALTERNATIVE SOLUTIONS TO THE GIVEN PROBLEM

  • Outcome
    • Apply formulas to worksheets to provide alternative solutions to the given problem.
  • Changing names and altering cells in a worksheet
  • Entering, altering, adjusting, and manipulating formulas in Excel to achieve a specific outcome.
  • Activity – On Your Own

 

APPLY SIMPLE BUILT-IN FUNCTIONS OF THE SPREADSHEET APPLICATION TO THE GIVEN PROBLEM

  • Outcome
    • Apply simple built-in functions of the spreadsheet application to the given problem.
  • Excel functions and their purpose
  • Examples of Functions

 

APPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM

  • Outcome
    • Apply formatting to a spreadsheet applicable to the given problem.
  • Formatting sheets in Excel
  • Formatting cells for numbers, currency and percentages as well as copying the formatting.

 

APPLY EFFECTS TO A SPREADSHEET TO IMPROVE THE PRESENTATION THEREOF

  • Outcome
    • Use special effects to improve the presentation of the spreadsheet.
  • Cell borders and fill colours
  • Cell styles
  • Centering and aligning texts.

 

EVALUATE THE SPREADSHEET TO COMPLY WITH REQUIRED PROBLEM

  • Outcome
    • Evaluate a spreadsheet to comply with the given problem.
  • Compliance and modification of the spreadsheet

 

Multiple Choice Assessment

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.