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
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
3. PRESENTING DATA WITH CHARTS
c. Using Charts With Microsoft Word and Microsoft Powerpoint
4. TABLES
a. Table Basics
5. MULTIPLE SHEET FILES
b. Formulas With 3-D References
c. Templates
6. EXCEL PIVOT TABLES, POWER PIVOT & POWER QUERY
WITH LOTS OF PRACTICAL EXERCISES