Complete Microsoft Word - CPD Certified

Academy for Health & Fitness

CPD Accredited Digital Certificate

Digital certificate - Included

CPD Accredited Hard Copy Certificate

Hard copy certificate - £29.99

Assessment

Included in course price

Start your learning journey straight away with this Bundle course and take a step toward a brighter future!

****Course Curriculum****

➽ Course 01: Learn Microsoft Word, PowerPoint & Outlook

Microsoft Word Essentials

• New Word Document and Templates
• Tabs, Ribbons and Groups
• Zoom and Rulers in Word
• Editing the Word Document
• Insert Pictures with Word
• Insert Shape and Text Box in Word
• Review Tab in Word
• Layout in Word
• File Options in Word
• Closing and Reopening in Word

➽ Course 02: Complete Microsoft Word

Manipulating Images

• Integrate Pictures and Text
• Adjust Image Appearance
• Insert Other Media Elements

Using Custom Graphic Elements

• Create Text Boxes and Pull Quotes
• Add WordArt and Other Text Effects
• Draw Shapes
• Create Complex Illustrations with SmartArt

Collaborating on Documents

• Prepare a Document for Collaboration
• Mark Up a Document
• Review Markups
• Merge Changes from Other Documents

Adding Document References and Links

• Add Captions
• Add Cross References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Add Citations and a Bibliography

Securing a Document

• Suppress Information
• Set Formatting and Editing Restrictions
• Restrict Document Access
• Add a Digital Signature to a Document

Using Forms to Manage Content

• Create Forms
• Modify Forms

Automating Repetitive Tasks with Macros

• Automate Tasks by Using Macros
• Create a Macro

➽ Course 03: Microsoft Excel Complete Course

Microsoft Excel 2019 New Features

• Introduction to Microsoft Excel 2019 New Features
• CONCAT
• IFS
• MAXIFS
• MINIFS
• SWITCH
• TEXTJOIN
• Map Chart
• Funnel Chart
• Better Visuals
• Pivot Table Enhancements
• Power Pivot Updates

Getting Started with Microsoft Office Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

Performing Calculations

• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Formatting a Worksheet

• Apply Text Formats
• Apply Number Format
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

Printing Workbooks

• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers

Managing Workbooks

• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Working with Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Analyzing Data

• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Creating Sparklines and Mapping Data

• Create Sparklines
• MapData

Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends

Excel Templates

• Excel Templates

=========>>>>> And 5 More Courses <<<<<=========

How will I get my Certificate?

After successfully completing the course, you will be able to order your Certificates as proof of your achievement.

• PDF Certificate: Free (Previously it was £12.99*8 = £103)
• CPD Hard Copy Certificate: £29.99

Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for:

• Students
• Graduates
• Admin Staff
• Business Professionals
• Entrepreneurs
• Freelancers

You will not need any prior background or expertise to enrol in this bundle.

After completing this bundle, you are to start your career or begin the next phase of your career.

• Office Manager
• Virtual Assistant
• Data Analyst
• Project Manager
• Marketing Specialist
• Business Analyst

Currently there are no Q&As for this course. Be the first to ask a question.