Microsoft Office Excel Level I , II & III

Microsoft Office Excel  Level I , II & III - Nigeria
Microsoft Office Excel  Level I , II & III - Nigeria
Microsoft Office Excel  Level I , II & III - Nigeria
  • Microsoft Office Excel  Level I , II & III - Nigeria
  • Microsoft Office Excel  Level I , II & III - Nigeria
  • Microsoft Office Excel  Level I , II & III - Nigeria
Description :

Microsoft excel : beginner, intermediate and advanced levels in lagos
Program types: i
( i=individual, c=corporate) - you may call for details on corporate training

• microsoft office excel: beginner (proficiency level)
• course objectives:
• this microsoft excel level 1 training organized by sgl technologies will introduce you to the features and power of microsoft excel, giving you a solid footing in a professional course that you will find very useful in your career and in your daily activities.
• sgl technologies will take you through all you need to know as a beginner. If you have been working with other spreadsheet programs, but you are yet to lay your hands upon microsoft excel, if you have been assigned a new role in your place of work, or if you suddenly discovered that you will need excel knowledge in your career, you are the one this training has been packaged for.
• course content
• lesson 1: getting started with excel
• topic 1 a: identify the elements of the excel interface
• topic 1 b: navigate and select cells in worksheets
• topic 1 c: customize the excel interface
• topic 1 d: create a basic worksheet
• lesson 2: performing calculations in an excel worksheet
• topic 2 a: create formulas in a worksheet
• topic 2 b: insert functions in a worksheet
• topic 2 c: reuse formulas
• lesson 3: modifying an excel worksheet
• topic 3 a: edit worksheet data
• topic 3 b: find and replace data
• topic 3 c: manipulate worksheet elements
• lesson 4: modifying the appearance of a worksheet
• topic 4 a: apply font properties
• topic 4 b: add borders and colors to cells
• topic 4 c: align content in a cell
• topic 4 d: apply number formatting
• topic 4 e: apply cell styles
• lesson 5: managing an excel workbook
• topic 5 a: manage worksheets
• topic 5 b: view worksheets and workbooks
• lesson 6: printing excel workbooks
• topic 6 a: define the page layout
• topic 6 b: print a workbook

• microsoft office excel : intermediate (specialist level)
• course objectives:
• the intermediate level will expand your knowledge of microsoft excel greatly. Microsoft excel level 2 has many capabilities, and there are lots to learn, which many professionals who thought they knew much about excel are not even aware of. this is one among the professional courses that has direct relevance to almost all careers, and a training that you can actually receive in a day.
• you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Course content
• lesson 1: calculating data with advanced formulas
• topic 1 a: apply cell and range names
• topic 1 b: calculate data across worksheets
• topic 1 c: use specialized functions
• topic 1 d: analyze data with logical and lookup functions
• lesson 2: organizing worksheet and table data
• topic 2 a: create and modify tables
• topic 2 b: format tables
• topic 2 c: sort or filter data
• topic 2 d: use functions to calculate data
• lesson 3: presenting data using charts
• topic 3 a: create a chart
• topic 3 b: modify charts
• topic 3 c: format charts
• lesson 4: analyzing data using pivot tables, slicers, and pivot charts
• topic 4 a: create a pivot table report
• topic 4 b: filter data using slicers
• topic 4 c: analyze data using pivot charts
• lesson 5: inserting graphic objects
• topic 5 a: insert and modify pictures and clip art
• topic 5 b: draw and modify shapes
• topic 5 c: illustrate workflow using smart art graphics
• topic 5 d: layer and group graphic objects
• lesson 6: customizing and enhancing the excel environment
• topic 6 a: customize the excel environment
• topic 6 b: customize workbooks
• topic 6 c: manage themes
• topic 6 d: create and use templates

• microsoft office excel : advanced (expert level )
• course objectives:
• the microsoft excel advanced level course will extend your basic and intermediate knowledge of excel, and develop more skills and knowledge that you need to produce worksheets as you require them. This training will expose you fully to the advanced level of microsoft excel, giving you the features and concepts that you will find to be relevant and beneficial to your career.
• you will automate some common excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share excel data with other applications.
• this course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data
Course content
Lesson 1: streamlining workflow
• topic 1 a: update workbook properties
• topic 1 b: create a macro
• topic 1 c: edit a macro
• topic 1 d: apply conditional formatting
• topic 1 e: add data validation criteria
Lesson 2: collaborating with other users
• topic 2 a: protect files
• topic 2 b: share a workbook
• topic 2 c: set revision tracking
• topic 2 d: review tracked revisions
• topic 2 e: merge workbooks
• topic 2 f: administer digital signatures
• topic 2 g: restrict document access
Lesson 3: auditing worksheets
• topic 3 a: trace cells
• topic 3 b: troubleshoot invalid data and formula errors
• topic 3 c: watch and evaluate formulas
• topic 3 d: create a data list outline
Lesson 4: analyzing data
• topic 4 a: create a trendline
• topic 4 b: create sparklines
• topic 4 c: create scenarios
• topic 4 d: perform a what-if analysis
• topic 4 e: perform a statistical analysis with the analysis tool pak
Lesson 5: working with multiple workbooks
• topic 5 a: create a workspace
• topic 5 b: consolidate data
• topic 5 c: link cells in different workbooks
• topic 5 d: edit links
Lesson 6: importing and exporting data
• topic 6 a: export excel data
• topic 6 b: import a delimited text file
• topic 6 c: import and export xml data
Lesson 7: integrating excel data with the web
• topic 7 a: publish a worksheet to the web
• topic 7 b: import data from the web
• topic 7 c: create a web query

Why sgl?
• over twenty five ( 25) highly experienced and certified consultants / trainers
• best rated training company on dealdey
• interactive learning experience
• optimized training budget
• content customization training solutions.
• both classroom and on-site training options
• capacity to deliver training at various locations across the country
• on-site training is also available to meet the need of our Clients. On-Site Training Outside Lagos Attracts Additional Logistics Charges.

Our safety tips

  • Listings with a "Shop" tag means that the publisher was curated by Jumia Deals.
  • At all costs, avoid paying before seeing the item.
  • Avoid sending money through untraceable methods such as Western Union or Mobile Money.
  • Thoroughly check the item to make sure it's matches the assumed condition.
  • If the seller doesn't have a shop, meet with him in a public place (Mall, Gas station, workplace ...).
  • Do not give personal details (bank details, credit card numbers ...).
  • Beware of offers that are too good to be true.

What do you have to sell?

Sell everything for free on Jumia Deals

Post a Free Ad Now!
Processing data