NewtonGATE Computer Training

Course Overview:

• Comprehensive guide to using Microsoft Word for document creation, formatting, and editing.
• Focus on both basic and advanced features to enhance productivity.

Highlights:

• Introduction to MS Word:
  • Overview of the interface and navigation.
  • Basic document creation and editing.
  • Understanding ribbons and toolbars.
• Document Formatting:
  • Applying styles and themes.
  • Working with fonts, paragraphs, and spacing.
  • Creating and managing headers, footers, and page numbers.
• Advanced Formatting Techniques:
  • Utilizing templates and building blocks.
  • Working with tables, charts, and SmartArt.
  • Inserting and formatting images and graphics.
• Document Collaboration:
  • Tracking changes and comments.
  • Using mail merge for mass document creation.
  • Protecting and securing documents with passwords and permissions.
• Advanced Document Features:
  • Creating and managing tables of contents and indexes.
  • Using macros to automate tasks.
  • Integrating Word with other Office applications.

Course Overview:

• In-depth training on Microsoft Excel, covering essential and advanced functionalities.
• Emphasis on data analysis, visualization, and automation techniques.

Highlights:

• Introduction to MS Excel:
  • Overview of the Excel interface.
  • Basic spreadsheet creation and navigation.
  • Understanding cells, rows, columns, and ranges.
• Data Entry and Formatting:
  • Techniques for efficient data entry.
  • Formatting cells, rows, and columns.
  • Conditional formatting for visual insights.
• Formulas and Functions:
  • Introduction to basic formulas and functions.
  • Advanced functions like VLOOKUP, HLOOKUP, INDEX, MATCH, and more.
  • Using logical functions (IF, AND, OR).
• Data Analysis:
  • Sorting, filtering, and data validation.
  • PivotTables and PivotCharts for data summarization.
  • Data analysis tools (What-If Analysis, Data Tables, Scenario Manager).
• Data Visualization:
  • Creating and customizing charts and graphs.
  • Utilizing Sparklines for mini-graph insights.
  • Advanced charting techniques and combination charts.
• Automation and Advanced Features:
  • Recording and using macros.
  • Introduction to VBA (Visual Basic for Applications).
  • Using Excel with other Office applications.

Course Overview:

• Detailed course on creating impactful presentations using Microsoft PowerPoint.
• Focus on design principles, animation, and interactivity to engage audiences.

Highlights:

• Introduction to MS PowerPoint:
  • Overview of the PowerPoint interface.
  • Basic slide creation and navigation.
  • Understanding slide layouts and themes.
• Slide Design and Layout:
  • Designing visually appealing slides.
  • Working with text, images, and multimedia.
  • Using master slides and custom templates.
• Advanced Slide Techniques:
  • Incorporating SmartArt and charts.
  • Designing interactive slides with hyperlinks and action buttons.
  • Using transitions and animations effectively.
• Presentation Delivery:
  • Best practices for presenting slideshows.
  • Using Presenter View for notes and controls.
  • Setting up and rehearsing slide timings.
• Collaboration and Sharing:
  • Co-authoring presentations in real-time.
  • Sharing presentations online and exporting to different formats.
  • Protecting presentations with passwords and permissions.
• Advanced Features:
  • Embedding and linking external content.
  • Creating custom slide shows and branching scenarios.
  • Integrating PowerPoint with other Office applications.