MS Excel

MS Excel

advance-excel

Microsoft Excel is a software program included in the Microsoft Office suite. It is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc. It is compatible with multiple OS like Windows, macOS, Android and iOS.

It is used to create spreadsheets, which are documents in which data is laid out in rows and columns. A Excel spreadsheet can be understood as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.

Due to its extreme versatility and power, Excel has become one of the most-used software programs in the business world since its launch in 1985. Spreadsheets are extraordinarily powerful tools, and are used to store and manipulate data.

Why Should I Learn Microsoft Excel?

We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.

Who should attend?
People like Data Scientists, Administrative Assistant, Accountants, Retail Manager, Cost Estimator, Financial Analyst, Project Manager, Business Analyst, Data Journalist, etc, who desire to take their professional skills to the next level.

Objectives: At the end of this course, you will be able to:

  • Use Micorsoft Excel Proficiently
  • Sort statistics and related entries,
  • Apply proper Data validation,
  • Familiar with macros and VBA
  • Protect sheets and lock of cells
  • Work with payroll systems
  • do much more

Prerequisite: You must have acquired the following before enrolment

  • Basic Computer knowledge
  • Microosft Excel Software (we can help you with this at extra cost)
  • PC systems

Course Price: 10,000NGN

Duration: Approx 7.5 hrs to complete

Register Now Pay Later   Request Course Outline

Course Outline at a Glance
Part 1 (2D) Part 2 (3D)
  1. Understanding AutoCAD user interface
  2. Choosing a work process before you begin
  3. Customizing the drawing environment
  4. Creating of Objects
  5. Modifying Objects
  6. Talking with Drawing
  7. Utilizing AutoCAD Design Center
  8. Plotting
  1. Swtching from 2D to 3D Workspace
  2. Understanding the 3D workspace
  3. Creating 3D Models
  4. Modifying 3D Models
  5. Creating 2D Drawings form 3D Drawings
  6. Rendering of Models
  7. Modeling of MEP objects
Duration
Part 1: 2 hours per day for 21 days
Part 2: 2 hours per day for 25 days
Mode Of Study
Instructor-Led training. The course is taught by one of our experienced qualified trainer. Online or at your comfort.

 

Poor/No Internet Connection!