Category Archives: IT Training

Power BI Desktop Concepts and Main Features Data Sources compatible with Power BI Desktop Connecting to Data with Power BI Desktop Explore Data Visualizations Apply Common Query Tasks to Shape Data in Power BI Desktop Create and publish Reports Getting Started with Power BI Desktop Power BI Concepts and Overview Introduction to Main Features Imports Visualizations Filters and Queries Reports Connecting to Data Sources with Power BI Desktop Data Sources…

Read More »

     

Learning Outcomes Power BI Desktop Concepts and Main Features Data Sources compatible with Power BI Desktop Connecting to Data with Power BI Desktop Explore Data Visualizations Apply Common Query Tasks to Shape Data in Power BI Desktop Create and publish Reports Getting Started with Power BI Desktop Power BI Concepts and Overview Introduction to Main Features Imports Visualizations Filters and Queries Reports Connecting to Data Sources with Power BI Desktop…

Read More »

     

Sorting and Merging Text and Data Sorting Merging     Protect Document Working With Formulas, Worksheets, and Charts Calculating in Tables Using Formulas Using Worksheets Creating and Modifying Worksheets                                                                            Embedding Existing Excel Worksheets…

Read More »

     

Reviewing Documents Correcting Documents Performing a Spelling and Grammar Check Using the Thesaurus Using Autocorrect Options Setting and Deleting AutoCorrect Exceptions Hyphenating Documents Inserting Special Hyphens Using Quick Part Building Blocks Creating a Quick Part Inserting a Quick Part Deleting Quick Part Entries Creating Outlines Typing Outline Lists Assigning and Removing Paragraph Outline Levels Using the Navigation Pane File Search – To find a file Insert a Comment Insert a…

Read More »

     

Creating and Editing Documents Starting Documents Identifying Components of the Word Screen The Word Ribbon Creating and Opening Documents Moving the Insertion/Cursor Point Building and Editing Documents Selecting Text Replacing and Deleting Blocks of Text Moving and Copying Text Modifying Page Breaks Finishing Documents Previewing Documents Printing Documents Closing Documents Assignment Formatting Text Enhancing Text Applying Text Formatting Effects Removing Text Formatting Using Undo and Redo Using the Repeat Command…

Read More »

     

Creating and Modifying Styles Applying Styles Creating a Template Working with Stencils and Master Shapes Creating a Stencil Creating a Master Shape Protecting Shapes and Documents Changing Shape Behaviour Using Automatic Layout Merging Shapes Using the Union Command Using the Subtract Command Using the Fragment Command Using the Combine Command Using the Intersect Command Using Background Pages Creating a Background Page Assigning a Background Page Displaying and Modifying Background and…

Read More »

     

Using Visio Basics Using Visio Starting Visio Using Stencils Using Toolbars Using the Shape Explorer Moving Between Pages in a Drawing Adding, Reordering, and Deleting Pages Saving a Visio File Using Print Preview Using Page Setup Printing a Drawing Creating a Drawing Starting a Drawing Adding Master Shapes to a Drawing Selecting Shapes Zooming In and Out in the Drawing Connecting Shapes Understanding Shapes Components Using Connectors Connecting Shapes Automatically…

Read More »

     

Customising PowerPoint 2016 How to change the default format of the blank presentation    How to change the Default Language Setting How to change the default Display options   How to change the default Spelling option How to change Presentation Properties and Information           How to change the default Save and changing Default Folder options   About the Quick Access Toolbar      How to customize…

Read More »

     

Using Advanced Management Features Objectives Managing Items Setting Up AutoArchiving Archiving Manually Retrieving Archived Items Creating and Applying Categories Finding Items Grouping Items Creating and Clearing a Filter Customizing Outlook Setting Options Adding Shortcuts to the Outlook Bar Moving a Shortcut on the Outlook Bar Removing a Shortcut from the Outlook Bar Changing Your Password Optimizing Mail Functions Objectives Using Address Books Using an Address Book to Address a Message…

Read More »

     

Working with Lists Creating a List Maintaining a List Editing Records Using the Data Form Filtering a List Using Subtotals in a List          Assignment Working with Macros and User‑Defined Functions Recording and Using Macros Assigning Macros Using User‑Defined Functions Assignment Using Basic Analysis Tools Performing “What If” Analyses Working with Scenarios Assignment Using Advanced Analysis Tools and External Data Querying a Database Importing and Exporting Files…

Read More »