- 2 Live Project
- Self-Paced/ Classroom
- Certification Pass Guaranteed
Ability to link out with multiple devices.
Analyzing the procedure of multi aspects.
Regarding analyzing the services applied.
Handling various technology junctures.
Maintaining our effectiveness in various matters.
Microsoft Office consists of multiple project management tools that can easily promote healthy proceedings throughout the organization.
The functional approach of Microsoft Technologies can stimulate new beginnings and easily shatter proceedings.
Microsoft is not used out by individuals gets to use by teams going to proceed out differential functions.
It is a move that can build out requests among the customer as well as the stakeholder which are going to serve out the initial markets.
Due to the recent trends in organizations, almost 32% to 48% of people are getting outhired by the top industrial networks going to surround us.
If we check out the matter of client perspective then it is clear that Microsoft Office helps out in gaining autonomous control over different things & modules.
Handling out the efficacies that can target malicious substances going through the needle for objections.
Microsoft also assists in pushing nature through control and making out its undeniable for the betterment of technical society.
Microsoft office also helps out in increasing work efficiency throughout the process of development which is going side by side.
It consists of lesser formulas which makes it more technology adaptable as well as frequent to learn & adapt things.
Learning & extracting the new responsibilities.
Getting a fair view of different elements.
Making & analyzing out new secrecy.
Handling out targeted operations.
Cooperating with customers & stakeholders.
By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy
20-Jul-2024*
22-Jul-2024*
17-Jul-2024*
20-Jul-2024*
22-Jul-2024*
17-Jul-2024*
Program fees are indicative only* Know more
We can set up a batch at your convenient time.
Trainer Profiles
Trained Students
Success Ratio
Corporate Training
Job Assistance
FOR QUERIES, FEEDBACK OR ASSISTANCE
Best of support with us
Presenting and Managing Data in Excel
Manage Workbook Options and Settings
Apply custom data formats and layouts
Create Advanced Formulas
Create advanced charts and tables
MIS Reporting and Dashboards
Basic Understanding Menu and Toolbar
Introduction to different category of functions
Creation of Excel Sheet Data
Range Name, Format Painter
Conditional Formatting, Wrap Text, Merge & Centre
Sort, Filter, Advance Filter
Different type of Chart Creations
Auditing, (Trace Precedents, Trace Dependents) Print Area
Data Validations, Consolidate, Subtotal
What if Analysis (Data Table, Goal Seek, Scenario)
Solver, Freeze Panes
Various Simple Functions in Excel (Sum, Average, Max, Min)
Real Life Assignment work
Save a workbook as a template,
copy macros between workbooks,
reference data in another workbook,
reference data by using structured references,
enable macros in a workbook,
display hidden ribbon tabs
Restrict editing,
protect a worksheet
configure formula calculation options
protect workbook structure
manage workbook versions
encrypt a workbook with a password
Create custom number formats
populate cells by using advanced Fill Series options
configure data validation
Create custom conditional formatting rules
create conditional formatting rules that use formulas
manage conditional formatting rules
Create custom color formats,
create and modify cell styles,
create and modify custom themes,
create and modify simple macros
insert and configure form controls
Display data in multiple international formats
apply international currency formats,
manage multiple options for Body and Heading fonts
Perform logical operations by using AND, OR, and NOT functions;
perform logical operations by using nested functions
perform statistical operations by using SUMIFS, AVERAGEIFS, COUNTIFS functions
Look up data by using the VLOOKUP function,
look up data by using the HLOOKUP function,
look up data by using the MATCH function,
look up data by using the INDEX function
Reference the date and time by using the NOW and TODAY functions,
serialize numbers by using date and time functions
Reference the date and time by using the NOW and TODAY functions
import, transform, combine, display, and connect to data
consolidate data
perform what-if analysis by using Goal Seek and Scenario Manager
use cube functions to get data out of the Excel data model
calculate data by using financial functions
Trace precedence and dependence
monitor cells and formulas by using the Watch Window
validate formulas by using error checking rules,
Evaluate formulas
Name cells,
name data ranges,
name tables,
manage named ranges and objects
VBA Basics.
Control Structures: Logical Expressions.
Control Structures: Loops.
Sub-Procedure and Functions.
Debugging.
Handling Text files, Pictures and charts.
VBA forms.
Database Connectivity:
Overview
The History of VBA
Why VBA
VBA Summary
Active sheet, Active cell, offset, sheet add, rename, etc.
Static & Dynamic
Array functions
Filter, cut, copy, paste, remove duplication, etc.
File system basics
Understanding file permissions
Setting file permissions
Accessing files
Writing to files
Deleting files
Reading files
Examining file details
Working with directories
Viewing directory content
If statements
Else and elseif statements
Logical operators
And. OR, Not. Go to Statements
Switch statements
While loops
For loops
For each loops
do while
do until
Continue
Break
Understanding array pointers
Subroutine
Passing value to sub- procedure
Message box
VBA Inbuilt functions
Passing values in functions
Workbook and worksheet functions
Keywords
Difference between sub-routines and functions
Creating own functions in VBA for Excel
Create and Manage a Database
Build Tables
Create Queries
Create Forms
Create Reports
Create new databases, create databases using templates, create databases in older formats, create databases using wizards
Edit references between tables, create and modify relationships, set primary key fields, enforce referential integrity, set foreign keys, view relationships
Navigate to specific records, set a form as the startup option, use navigation forms, set navigation options, change views
Compact databases, repair databases, back up databases, split data bases, encrypt databases with a password, merge databases, recover data from backups
Print reports, print records, maintain backward compatibility, save databases as templates, save databases to external locations, export to alternate formats
Create new tables, import external data into tables, create linked tables from external sources, import tables from other database, create tables from templates and application parts
Hide fields in tables, change data formats, add total rows, add table descriptions, rename tables
Update records, add new records, delete records, append records from external data, find and replace data, sort records, filter records, group records
Add fields to tables, add a validation rules to fields, change field captions, change field sizes, change field data types, configure fields to auto-increment, set default values, use input masks, delete fields
Run queries, create crosstab queries, create parameter queries, create action queries, create multi-table queries, save queries, delete queries
Rename queries, add new fields, remove fields, hide fields, sort data within queries, format fields within queries
RAdd calculated fields, add conditional logic, group and summarize data, use comparison operators, use basic operators
Create new forms, create forms with application parts, save forms,
delete forms
Move form controls, add form controls, modify data sources, remove
form controls, set form control properties, manage labels
Modify tab order in forms, format print layouts, sort records, apply
Modify tab order in forms, format print layouts, sort records, apply themes, change margins, insert backgrounds, auto-order forms, insert headers and footers, insert images, modify existing forms
Phone (For Voice Call):
+91-971 152 6942WhatsApp (For Call & Chat):
+91-8287060032Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals
Microsoft Office helps out in boosting productivity throughout the organizational network.
Microsoft Office helps out in smoothening out tasks that are going to deal with largely by corporate professionals.
The concepts involved in Microsoft Office led to the emergence of autonomous technologies get to hire almost everything.
If yes, Register today and get impeccable Learning Solutions!
The most traditional way to learn with increased visibility,monitoring and control over learners with ease to learn at any time from internet-connected devices.
Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.
Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.
Get Unlimited access of the course throughout the life providing the freedom to learn at your own pace.
With no limits to learn and in-depth vision from all-time available support to resolve all your queries related to the course.
Each certification associated with the program is affiliated with the top universities providing edge to gain epitome in the course.
For Voice Call
+91-971 152 6942For Whatsapp Call & Chat
+91-8287060032