Financial Modeling with Microsoft Excel- Rawalpinidi

1 month ago Rawalpindi, Pakistan Ad Views:121 Ad ID: 19346

Description

Microsoft Excel for Accountants Diploma Certification-3035530865

Description

Benefitsof studying the Microsoft Excel Course

Thereare various advantages for those who work towards earning a Microsoft Excelcertificate online.

These include some of the following:

  • Build great charts. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells
  • Use conditional formatting
  • Help identify trends
  • Bring data together

Whatsapp:+923035530865, 03219606785, 3315145601,

03495021336IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Description

Lesson One: Openingthe Excel 2013 program, identifying the elements of the opening screen,creating a worksheet with text and numbers, entering addition formulas,adjusting column widths, using the SUM function in a formula, using the AutoSumfeature, editing text and numbers, navigating a workbook and worksheets,saving, naming and closing a workbook, opening an existing workbook, exitingExcel.

Lesson Two: Applyingbold, italic and underline formats, changing font type and size, using the minitoolbar, changing the font colour, selecting and formatting cells ranges,selecting columns and rows, aligning cell contents horizontally, using mergeand centre, applying number formats, printing the active worksheet, creating anew folder, saving a workbook with a different name and filetype, viewing files in the open dialog box, using AutoFill, entering formulasfor subtraction, multiplication, division and percentages.

Lesson Three: Inserting and deleting rows and columns, hiding andunhiding rows and columns, minimizing the ribbon, modifying column widths androw heights, aligning cell contents vertically, wrapping and indenting text,applying a fill colour, applying borders, undo and redo, moving and copyingcell contents using drag and drop, moving and copying cell contents using cut,copy and paste, copying formats using format painter, clearing formats.

Lesson Four:Using AutoComplete, changing text orientation, selecting non-adjacent data,freezing and unfreezing panes horizontally and vertically, using Zoom, pagebreak preview, page layout view, naming a worksheet, inserting and deleting aworksheet, repositioning worksheets, using the count function, saving aworkbook as a template, creating a workbook from a template, online templates.

Whatsapp:+923035530865, 03219606785, 3315145601,

03495021336IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

 

Location

19346