Tin học ứng dụng nâng cao

Advanced Applied Computing: Key Features in Microsoft Office Suite

Welcome to this comprehensive course designed for students and professionals who want to master the most useful functions of PowerPoint, Microsoft Project, Excel, and Word. The material is organized around real‑world quiz questions, providing clear explanations, practical tips, and SEO‑friendly keywords that help you find the information quickly when searching online.

1. Adding Slide Numbers in PowerPoint 2010

Slide numbers are essential for navigation, especially during large presentations. In PowerPoint 2010 the correct command is:

• Insert → Slide Number

When you select this option, a dialog box appears where you can choose to display the number on all slides, start numbering from a specific slide, or exclude the title slide. Remember that the Bullets and Numbering commands under the Insert tab are meant for list formatting, not for slide numbering.

2. Understanding Animation Timing: With Previous vs. After Previous

PowerPoint animations can be synchronized in three main ways:

• With Previous – the effect starts at the same moment as the preceding effect.
• After Previous – the effect begins only after the previous effect finishes.
• Start On Click – the effect waits for a manual trigger.

Consider three objects with the following settings:

• A – With Previous
• B – With Previous
• C – After Previous

The correct sequence is:

• A and B appear simultaneously because both are set to With Previous.
• After the combined A‑B animation ends, C appears because it is set to After Previous.

Using this knowledge, you can create smooth, professional‑looking transitions without manually clicking between each element.

3. Critical Path (Đường Găng) in Microsoft Project

The critical path, known in Vietnamese as đường găng, is the longest sequence of dependent tasks that determines the earliest possible project completion date. Key points to remember:

• The critical path has the maximum total duration among all possible paths.
• Any delay on a critical‑path task directly pushes the project finish date forward.
• Non‑critical tasks have "float" (or slack) and can be delayed without affecting the overall schedule.

When you view the Gantt chart in Microsoft Project, the critical tasks are highlighted in red by default. Use the View → Critical Path option to filter and focus on these tasks.

4. Shortening Project Duration: Focus on Critical Tasks

To accelerate a project, concentrate on the tasks that lie on the critical path. Strategies include:

• Fast‑tracking: Overlap tasks that were originally scheduled sequentially, provided they are not mutually exclusive.
• Crashing: Add resources (people, equipment) to critical tasks to reduce their duration, acknowledging the increased cost.
• Scope reduction: Remove or simplify deliverables that belong to the critical path.

Attempting to speed up tasks that are not on the critical path usually has little impact on the final delivery date, unless those tasks have zero slack and become part of a new critical path after adjustments.

5. Horizontal Lookup in Excel: HLOOKUP

Excel offers two primary lookup functions: VLOOKUP (vertical) and HLOOKUP (horizontal). HLOOKUP works as follows:

• It searches for a value in the top row of a specified array.
• Once the match is found, it returns the value from the row you specify, staying within the same column.

Syntax:

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Example: =HLOOKUP("Q2",A1:D4,3,FALSE) looks for "Q2" in the first row of the range A1:D4 and returns the value from the third row of the same column. This function is ideal for financial models where periods are arranged horizontally.

6. Summing Visible Cells After Filtering: SUBTOTAL

When you filter a dataset, the regular SUM() function still adds hidden rows, which can lead to inaccurate totals. The SUBTOTAL() function solves this problem by automatically ignoring rows that are hidden by a filter.

• Function number 9 corresponds to SUM within SUBTOTAL.
• Use =SUBTOTAL(9, range) to get the sum of only the visible cells.

Additionally, SUBTOTAL can perform other calculations (average, count, max, etc.) by changing the function number. This makes it a versatile tool for dynamic reports and dashboards.

7. Inserting a Mandatory Page Break in Word 2010

Page breaks force the following content to start on a new page, regardless of the current layout. The shortcut for inserting a mandatory page break is:

• Ctrl + Enter

Unlike a simple Enter key press, which creates a new paragraph, Ctrl+Enter creates a hard page break, ensuring that the next paragraph begins at the top of the next page. This shortcut is essential for formatting reports, theses, and any document that requires precise pagination.

8. Text Wrapping Options for Images in Word

Word provides several wrapping styles that control how text interacts with inserted graphics. The option that places an image in line with the text is:

• In Line With Text

When an image is set to In Line With Text, it behaves like a large character within the paragraph. This means the image moves with the surrounding text and respects paragraph indentation and spacing. Other options such as Tight, Behind Text, or In Front Of Text create floating objects that can be positioned independently of the text flow.

9. Recap and Best Practices

Below is a quick reference table summarizing the key commands and concepts covered in this course:

• PowerPoint Slide Number: Insert → Slide Number
• Animation Timing: With Previous = simultaneous; After Previous = sequential
• Critical Path: Longest duration path; focus on these tasks to shorten project time
• Excel HLOOKUP: Horizontal lookup in the top row
• Excel SUBTOTAL: Use function number 9 for visible‑row sum after filtering
• Word Page Break: Ctrl + Enter
• Word Image Wrapping: In Line With Text for inline placement

By mastering these shortcuts and concepts, you improve efficiency, reduce errors, and enhance the professionalism of your documents and projects. Keep practicing each feature in its native application, and you’ll quickly notice the productivity boost.