IT Computer Institute

BASIC OFFICE PACKAGE COURSE [90 HRS/3 MONTHS CERTIFICATE COURSE]

  • Typeshala                                            
  • Free Typing in WordPad/Notepad           
  • Fundamental of Computer           
  • Knowledge about Computer System
  • Microsoft Windows Using Technique and Personalization, File Management
  • Microsoft Office Word 2013
    • Introduction/Uses/Advantages
    • Formatting Manage Text, Paragraph, Document and Techniques
    • Using Table, Technique with Practical
    • Using Picture, Technique with Practical
    • Using Shape, Technique with Practical
    • Using Smart Art, Technique with Practical
    • Using Chart, Technique with Practical
    • Hyperlink, Bookmark, Reference, Technique with Practical
    • Header/Footer, Page Number Technique with Practical
    • Design WordArt, Drop cap, Signature Level Creation Technique with Practical
    • Making Mathematical Equation Technique with Practical
    • Inserting Symbol, Technique with Practical
    • Design Documents, Create Resume
    • Format and Setting Document Pages
    • Mail Merge
    • Footnote note and All about Using MS Word
    • Print, Create Document extension
  • Microsoft Office Excel 2013
    • Getting started with Excel 2013
      • Identifying the different Excel 2013 programs
      • Identifying new features of Excel 2013
      • Working with the ribbon
      • Customizing the Excel 2013 program window
      • Zooming in on a worksheet
      • Arranging multiple workbook windows
      • Adding buttons to the Quick Access Toolbar
      • Customizing the ribbon
      • Maximizing usable space in the program window
      • Creating workbooks
      • Modifying workbooks
      • Modifying worksheets
      • Inserting rows, columns, and cells
      • Merging and unmerging cells
      • Key points
    • Working with data and Excel tables
      • Entering and revising data
      • Managing data by using Flash Fill
      • Moving data within a workbook
      • Finding and replacing data
      • Correcting and expanding upon worksheet data
      • Defining Excel tables
      • Key points
    • Performing calculations on data
      • Naming groups of data
      • Creating formulas to calculate values
      • Summarizing data that meets specific conditions
      • Working with iterative calculation options and automatic workbook calculation
      • Using array formulas
      • Finding and correcting errors in calculations
      • Key points
    • Changing workbook appearance
      • Formatting cells
      • Defining styles
      • Applying workbook themes and Excel table styles
      • Making numbers easier to read
      • Changing the appearance of data based on its value
      • Adding images to worksheets
      • Key points
    • Focusing on specific data by using filters
      • Limiting data that appears on your screen
      • Filtering Excel table data by using slicers
      • Manipulating worksheet data
      • Selecting list rows at random
      • Summarizing worksheets by using hidden and filtered rows
      • Finding unique values within a data set
      • Defining valid sets of values for ranges of cells
      • Key points
    • Reordering and summarizing data
      • Sorting worksheet data
      • Sorting data by using custom lists
      • Organizing data into levels
      • Looking up information in a worksheet
      • Key points
    • Combining data from multiple sources
      • Using workbooks as templates for other workbooks
      • Linking to data in other worksheets and workbooks
      • Consolidating multiple sets of data into a single workbook
      • Key points
    • Analyzing data and alternative data sets
      • Examining data by using the Quick Analysis Lens
      • Defining an alternative data set
      • Defining multiple alternative data sets
      • Analyzing data by using data tables
      • Varying your data to get a specific result by using Goal Seek
      • Finding optimal solutions by using Solver
      • Analyzing data by using descriptive statistics
      • Key points
    • Creating charts and graphics
      • Creating charts
      • Customizing the appearance of charts
      • Finding trends in your data
      • Creating dual-axis charts
      • Summarizing your data by using sparklines
      • Creating diagrams by using SmartArt
      • Creating shapes and mathematical equations
      • Key points
    • Using PivotTables and PivotCharts
      • Analyzing data dynamically by using PivotTables
      • Filtering, showing, and hiding PivotTable data
      • Editing PivotTables
      • Formatting PivotTables
      • Creating PivotTables from external data
      • Creating dynamic charts by using PivotCharts
      • Key points
    • Printing worksheets and charts 333
      • Adding headers and footers to printed pages
      • Preparing worksheets for printing
      • Previewing worksheets before printing
      • Changing page breaks in a worksheet
      • Changing the page printing order for worksheets
      • Printing worksheets
      • Printing parts of worksheets
      • Printing charts
      • Key points
    • MS Powerpoint
      • Introduction and Useful Technique about Power Point
      • Create Slide/Remove/Duplicate and Manage
      • Animation
      • Page Setup
      • Printing and Create Documentation
      • Project Practical
    • Email Internet
      • Introduction and Useful Idea, How to Use
      • Creating Using Email
      • Google Drive/Ondrive
      • Downloading/Uploading/Sharing/Printing
      • Zip/Unzip/Archive Document/File Sharing
    • Create Blog /Using and Technique
    • Adobe Photoshop
      • Introduction
      • Tools Explain and using all Tools
      • Technique All about Color Grading and Graphic Designing
Register Now!