Available courses

Basic Excel

Microsoft Excel is a widely used spreadsheet program that is used to organize, create, and manipulate text, charts, and numbers. Although there are several spreadsheet programs, Microsoft Excel is a leading program among all spreadsheet programs.

Many people are overwhelmed by the powers of Excel, but these can be easily manipulated to your advantage, and this course helps you do just that.

In this course, you will be getting your hands dirty with the following topics:

1.  FUNDAMENTAL SKILLS

      a.  Overview of Microsoft Excel

      b.  Entering, Editing, and Managing Data

      c.  Formatting and Data Analysis

      d.  Printing

2.  MATHEMATICAL COMPUTATIONS

      a.  Formulas

      b.  Introductory Statistical Functions

      c.  Functions for Personal Finance

3.  FORMULAS, FUNCTIONS, LOGICAL AND LOOKUP FUNCTIONS

      a.  More on Formulas and Functions

      b.  Logical and Lookup Functions

      c.  Conditional Formatting

WITH LOTS OF PRACTICAL EXERCISES

MySql Database

MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL). A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or a place to hold the vast amounts of information in a corporate network. In particular, a relational database is a digital store collecting data and organizing it according to the relational model. In this model, tables consist of rows and columns, and relationships between data elements all follow a strict logical structure. An RDBMS is simply the set of software tools used to actually implement, manage, and query such a database

Advanced Excel

Microsoft Excel is a tool that can be used in virtually all careers and is valuable in both professional and personal settings. Whether you need to keep track of medications in inventory for a hospital or create a financial plan for your retirement, Excel enables you to do these activities efficiently and accurately

In this course, we will be learning the following topics:

1.  SORTING & FILTERING

      a.  Sorting Data

2.  ADVANCED EXCEL TOOLS

      a.  Nested Functions & Macros

      b.  Conditional Formatting

 3. PRESENTING DATA WITH CHARTS

      a.  Choosing a Chart Type

      b.  Formatting Charts

      c.  Using Charts With Microsoft Word and Microsoft Powerpoint

4.  TABLES

      a.  Table Basics

      b.  Intermediate Table Skills

5.  MULTIPLE SHEET FILES

      a.  Multiple Sheet Basics

      b.  Formulas With 3-D References

      c.  Templates

6.  EXCEL PIVOT TABLES, POWER PIVOT & POWER QUERY

      a.  Excel Pivot Tables

      b.  Power Pivot & Power Query

      c.  Data Modelling

WITH LOTS OF PRACTICAL EXERCISES


Site announcements