9007116752
c3creativedomain@gmail.com
C-Cube
Centre of Computer Education
MS-Office Training Course
in Office Management.
2) Learn to use the new advanced language query features
in Excel, get writing and research assistance, better lists
and presentations in PowerPoint.
3) Learn to present data in impactful visual format,
use embedded links & objects , macros.
Need for MS-Office Training
Microsoft Office training is essential for enhancing productivity in various professional settings, as it equips users with the skills to efficiently manage documents, data, and presentations. Learning tools like Microsoft Word can improve document creation and formatting skills, enabling users to create polished reports, proposals, and letters. Similarly, Microsoft Excel provides powerful tools for data analysis, financial modeling, and reporting, making it indispensable for individuals in finance, data management, and administrative roles. Excel’s advanced features, such as pivot tables and complex formulas, help users perform deep data analysis and automate repetitive tasks.
Additionally, training in Microsoft PowerPoint is crucial for those needing to create impactful presentations, allowing users to communicate ideas more clearly and effectively. Mastering these tools can greatly increase efficiency and improve collaboration, as the suite integrates seamlessly with cloud services like OneDrive, enabling real-time document sharing and co-authoring. Overall, proficiency in Microsoft Office is a vital skill for both personal and professional success, as it supports a wide range of business functions and projects.
- Getting writing assistance from Editor.
- Using the Resume Assistant in Word.
- Turning data into maps in Excel.
- Setting access to linked files right within Outlook.
- Creating better PowerPoint lists with Designer.
- Using the math assistant in OneNote.
- Working with Microsoft To-Do and Forms.
- MS-Word.
- MS-Excel.
- MS-Power Point.
- Internet
- Opportunity to wok on live-projects as part of Internship on reputed Companies.
- Internship work certificate
- Certification on Computer Fundamentals from Central Govt. of India
Both the below mode of Training is available.
Online Mode – Live Class
Offline Mode
Microsoft Office Course (Basic to Advance)
Introduction to Word , Getting Familiar with Buttons , Tabs & Ribbons , Manipulating Text , Page Layout , Cut , Copy , Paste , Find & Replace , Formatting Text – Changing Font , Text Format Options , Bullets & Numbered Lists , Other Formatting Tools , Organizing Content – Creating and Formatting Tables , Converting Text to Tables , Table Borders & Shading , Headers & Footers , References , Bookmarks , Table of Contents , Mail Merge , Use of Tabs, Preparing CV , Taking Print out
Introduction to Excel: Understanding the Excel interface, workbook, and worksheets.
Formulas and Functions: Introduction to Excel formulas , and basic functions (e.g., SUM, AVERAGE, MAX, MIN etc) & Basic Formatting.
Cell Referencing: Understanding absolute and relative cell references.
Sorting and Filtering: Sorting data in Excel and using filters to view specific data.
Charts and Graphs: Creating simple charts and graphs to visualize data.
Printing: Adjusting print settings, page layout, and printing worksheets.
Creation of slider , Advance animation , motion effects , Inserting pictures , Movies , clips and sound.
Quick Contact Form
Excel Corporate Training
Basic Excel
- Excel Interface Overview: Ribbon, toolbar, workbook, worksheet basics
- Creating and Saving Workbooks: Starting a new workbook, saving options
- Basic Navigation: Moving between cells, worksheets, and using shortcuts
- Entering Data: Typing and editing text, numbers, dates, and special characters
- Basic Formatting: Changing font, color, cell alignment, and styles
- Basic Arithmetic Operations: Addition (+), subtraction (-), multiplication (*), division (/)
- AutoSum Function: SUM for adding values quickly
- Basic Functions: MIN, MAX, AVERAGE, COUNT, COUNTA
- Relative vs. Absolute References: Using $ for fixed cell references
- Basic Date Functions: TODAY, NOW, YEAR, MONTH, DAY
- Copy, Cut, and Paste: Moving and duplicating data
- AutoFill and Flash Fill: Filling series, dates, and patterns automatically
- Undo and Redo: Correcting mistakes quickly
- Find and Replace: Searching for data and replacing it
- Cell Formatting: Number, date, currency, and percentage formats
- Conditional Formatting: Highlighting cells based on criteria
- Borders and Shading: Enhancing cell visibility and organization
- Adjusting Row Height and Column Width: Customizing sheet layout
- Introduction to Charts: Types of charts (column, bar, line, pie)
- Creating Simple Charts: Selecting data and inserting charts
- Formatting Charts: Titles, legends, labels, colors
- Basic Data Visualization Tools: Sparklines, data bars, color scales
- Sorting Data: Sorting alphabetically, by number, or date
- Filtering Data: Using filters to view specific data
- Custom Sorting and Filtering Options: Sorting by multiple columns, filtering by conditions
- Data Validation Basics: Creating dropdown lists, restricting data entry
- Error Alerts: Customizing error messages for invalid data
- Basic Protection: Locking cells and protecting sheets to prevent editing
- Creating a Simple Pivot Table: Organizing and summarizing data
- Pivot Table Fields: Row, column, value, and filter fields
- Basic Pivot Table Customization: Sorting, filtering, and formatting in Pivot Tables
- Print Setup: Page orientation, scaling, and print area selection
- Headers and Footers: Adding titles, page numbers, and dates
- Print Preview: Reviewing layout before printing
- Page Layout Adjustments: Margins, fit to page, repeating headers
- Print Setup: Page orientation, scaling, and print area selection
- Headers and Footers: Adding titles, page numbers, and dates
- Print Preview: Reviewing layout before printing
- Page Layout Adjustments: Margins, fit to page, repeating headers
Advanced Excel
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT
- Logical Functions: IF, AND, OR, IFERROR, IFS, SWITCH
- Text Functions: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, FIND, SUBSTITUTE
- Math & Statistical Functions: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
- Date & Time Functions: DATE, TODAY, NETWORKDAYS, EOMONTH, YEAR, MONTH, DAY, DATEDIF, TIME
- Dynamic Array Functions: FILTER, SORT, UNIQUE, SEQUENCE, SORTBY
- Financial Functions: NPV, IRR, PMT, FV, PV
- Pivot Tables: Creating, modifying, grouping, and summarizing data
- Pivot Charts: Visualizing Pivot Table data, customizing, using slicers
- Data Tables: One-variable and two-variable data tables
- Goal Seek and Solver: Optimization and “what-if” analysis
- Scenario Manager: Creating, editing, and analyzing scenarios
- Data Validation: Dropdown lists, input restrictions, error messages
- Charts and Graphs: Line, bar, pie, area, scatter, combo charts, waterfall, funnel
- Conditional Formatting: Rules, icons, color scales, and data bars
- Sparklines: Inserting and customizing mini charts within cells
- Advanced Charting Techniques: Dynamic charts, combo charts, custom charts
- Interactive Dashboards: Using slicers, form controls, and hyperlinks for interactivity
- Text to Columns: Splitting data into separate columns
- Remove Duplicates: Identifying and removing duplicate entries
- Flash Fill: Automatic pattern recognition for data entry
- Power Query: Importing, cleaning, and transforming data from different sources
- Error Handling: IFERROR, ISERROR, ISNUMBER, and troubleshooting techniques
- Formulas / Function Creation with VBA Programming
- Advanced Formulas Method with VBA Programming
- String Function
- Number Function
- Date and Time Calculation using Date Time Formulas
- Information Formulas
- Look Up Method(VLookup,HLookup,Match,Index,Offset) with VBA
Advanced VLookup and VLookup Listing with VBA
Data Summarization Formulas
Database and list management Formulas with VBA
Financial Formulas
- Tableau Integration: Exporting data to Tableau, using Power Query with Tableau
- Microsoft Access Integration: Importing and exporting data between Access and Excel
- Excel with Word and PowerPoint: Linking, embedding, and dynamic data updating
- Using Excel with Google Sheets: Data sharing, co-authoring, and compatibility
- Keyboard Shortcuts: Common shortcuts for speed and efficiency
- Workbook Optimization: Reducing file size, improving performance
- Documentation and Commenting: Proper documentation of workbooks, comments, and notes
- Effective Troubleshooting: Formula auditing tools, error tracing, and debugging
Eligibility Criteria
- Graduates or Colleges Students from any discipline
- No prior work experience required
- No prior coding experience or tech know-how required
Best Suited For
- Professionals
- Recent Graduates
- College Students from any discipline
Central Govt. Certification for
MS-Office Course
National Board of Computer Education is a multi-award winning educational content portal. All the courses are launched after an initial survey. The courses fulfill the requirement of the students. To gain professional qualification, certification and extra classes in career orientation and self-development. After completion of each module the performance of the students is monitored through regular tests to develop their skills. That the students should appear successfully. In the Job market and handle the situation confidently.Our students are employed in reputed organization both in India and Abroad. The key to success in ensuring quality training by the experts. Provide education for the rural youth enabling him to play a part of the global development.
