2024-04-23 13:04
https://youtu.be/v4XFtAkFO_A
Learn expert tips for creating an Excel timeline using a Gantt chart in this video tutorial. Perfect for project managers and those looking to visualize deadline… Read More
Blog Directory > Business Blogs > Steve Saxton's Blog | 1st for training in Newcastle business Blog >
Steve Saxton's Blog | 1st For Training In Newcastle Blog
stevesaxton.wordpress.com
Tags:
microsoft
excel
microsoft excel
style
pivot tables
headings
vlookup function
microsoft lists
microsoft visio
excel spreadsheet creation
1st for training in Newcastle
2024-04-18 10:09
https://youtu.be/-a3mi7XELlY
Automatically add borders and item numbers with these two great tips. Use conditional formatting to automatically add your borders as you type. Use the SEQUENCE… Read More
2024-04-17 11:27
https://youtu.be/RDo4xqf_xgM
Learn the secrets to customizing headers on multiple pages in Writer with this helpful tutorial. Master the art of unique headers for each page effortlessly!
To… Read More
2024-04-16 11:35
https://youtu.be/QzC1M45nDvM
Adding a table of contents (TOC) in Microsoft Word is a straightforward process that enhances the navigation of your document. To begin, place your cursor at the… Read More
2024-04-16 11:00
https://youtu.be/tmcBn5sebz8
Learn how to create a table of contents easily with this simple tip. Say goodbye to typing out a table of contents and save time with this alternative method!
Ad… Read More
2024-04-12 16:28
https://youtu.be/6tVb1FvlQS8
Learn how to use vlookup in just 60 seconds with this quick and easy tutorial. Master this Microsoft Excel function in no time! #itseasytraining #microsoft #exce… Read More
2024-04-12 15:48
https://youtu.be/PVqzT1UKqrw Read More
2024-04-11 11:30
https://youtu.be/xUdcHUO1uEI
Learn how to enhance your Microsoft Lists with additional views in this tutorial video. Optimizing your lists with different views can help you better organize a… Read More
2024-04-10 04:03
https://youtu.be/k4afLCDOFQY
Learn the secrets to safeguarding sheets and cells in Microsoft Excel to protect your data and ensure security. Keep your information safe with these tips! Secre… Read More
2024-04-09 11:16
https://youtu.be/1sFcDD8bvDE
Learn how to master pivot tables in LibreOffice Calc with this tutorial session! Discover how to create a simple pivot table, calculate percentage differences, a… Read More
2024-04-04 17:01
https://youtu.be/B3lusXSJlHE
In this tutorial, we will show you how to efficiently use AutoText in Microsoft Word to quickly generate documents with just a few clicks. AutoText is a powerful… Read More
2024-04-03 15:29
https://youtu.be/x5WfF1rwwjY
Creating summary tasks in Microsoft Project is a fundamental skill for effective project management. Summary tasks help organize and structure your project by gr… Read More
2024-04-02 14:17
https://youtu.be/N0UVbHCEZCg
Ready to transform your skills with ITs Easy Training? Our tutorials cover Microsoft Office, LibreOffice, Google, and more! Start learning today.
Join this chann… Read More
2024-04-02 11:02
https://youtu.be/tU9Z2dTNR1U
Welcome to our Microsoft Access tutorial where we explore the functionality of calculation fields in queries. Follow along as we demonstrate how to design a quer… Read More
2024-03-28 10:28
https://youtu.be/nH-CFEM2MEU
To multiply figures in Excel using the Paste Special feature, you can follow these steps: First, enter the number by which you want to multiply (the multiplier)… Read More
2024-03-27 12:02
https://youtu.be/iSKLgDxn7jI
Creating your own stencils in Visio can significantly enhance your productivity and efficiency when working on diagrams. Custom stencils allow you to tailor your… Read More
2024-03-25 14:03
https://youtu.be/tOaJT4bUzdc
To automatically adjust the width of cells in Excel without using VBA, you can utilize the ‘AutoFit’ feature. This feature can be accessed after reco… Read More
2024-03-21 11:14
https://youtu.be/ScI-vYNf2Sc
To create a report with grouping in Access, begin by selecting the table or query that contains the data you want to include. Open the Report Wizard, and choose… Read More
2024-03-20 08:57
https://youtu.be/KjsVenymv0k
To utilize the % difference from feature in a pivot table, begin by selecting your pivot table and choosing the value you wish to analyse. Right-click on it and… Read More
2024-03-19 12:36
https://youtu.be/YLMlKse0e5Q
To utilize the ‘consolidate’ feature in Excel, begin by selecting a cell in a new sheet where you wish the consolidated data to appear. Navigate to t… Read More
2024-03-14 12:32
https://youtu.be/l-dB8GVxHZY
To animate slides using the animation pane in PowerPoint, start by opening your presentation and selecting the slide you want to animate. Then, go to the “… Read More
2024-03-13 10:55
https://youtu.be/_9oqH1ADFTk
Learn how to create a database in Microsoft Access with this step-by-step tutorial! Follow along as we show you how to easily set up a simple database from scrat… Read More
2024-03-12 12:28
https://youtu.be/n8ZWH4zGvHk
– Select the column or range of cells that contain the numbers you want to add a prefix to.
– Go to Format – Number – More Formats &ndash&hell…Read More
2024-03-06 10:30
https://youtu.be/qQrWLPOzfaE
Multilevel lists are useful for organizing and presenting information in a hierarchical way. You can create multilevel lists in Microsoft Word by following these… Read More
2024-03-05 12:23
https://youtu.be/Z27kZwrL5II
One of the powerful features of Excel is the ability to create Pivot tables from multiple data sources using relationships. Relationships are connections between… Read More
2024-02-29 12:18
https://youtu.be/9sEd1_8qG-U
How to use Text functions in Excel. This is a Microsoft Excel tutorial covering text functions. The functions explained in this video are: Left, Right, Len, Fi… Read More
2024-02-28 13:36
https://youtu.be/68B0c5NJS3I
Microsoft Project (MSP) is a project management software developed and sold by Microsoft. It is designed to assist project managers in developing plans, assignin… Read More
2024-02-27 11:54
https://youtu.be/EPf3jXC5HkE
Microsoft Visio is a powerful tool for creating professional diagrams and flowcharts. It allows you to transform complex information into visual representations… Read More
2024-02-22 12:30
https://youtu.be/DYgqWMEn410
Certainly! Data validation in Excel is a powerful feature that allows you to control the type of data entered into a cell. By setting rules, you can maintain acc… Read More
2024-02-21 12:33
https://youtu.be/dytkUe6hMzU
Goal Seek is a powerful built-in what-if analysis tool in Microsoft Excel that allows you to simulate the input needed to achieve a specific output. It’s p… Read More
2024-02-20 14:06
https://youtu.be/DRMldiOieTg
In Microsoft Project, you have two ways of scheduling tasks: manual scheduling and automatic scheduling. Let’s explore the difference between these two app… Read More
2024-02-15 11:00
https://youtu.be/u9HyBp81MWo
OneNote is a powerful note-taking app that can help you organize your thoughts, ideas, and projects. But did you know that OneNote also has some hidden features… Read More
2024-02-14 15:58
https://youtu.be/zoaH0GJu7hY
Legal blackline is a feature in Microsoft Word that allows you to compare two documents and see the differences between them. It is useful for lawyers, editors… Read More
2024-02-13 14:01
https://youtu.be/V8CaYOCPcPI
The FILTER function and the XLOOKUP function are both useful tools for extracting data from a range or table based on certain criteria. However, they have some k… Read More
2024-02-08 12:31
https://youtu.be/hiuz0ZvxGeg
One of the features of Microsoft Project is the ability to track the progress of your tasks by comparing the actual hours worked against the planned hours. This… Read More
2024-02-07 13:24
https://youtu.be/EiEJcwmBBws
Relationship types in Microsoft Access are ways of defining how data in one table is related to data in another table. There are three main types of relationship… Read More
2024-02-06 12:17
https://youtu.be/3vBpNU3_GT0
Return multiple rows with a VLOOKUP function. Step 1 – create a helper column using a COUNTIF function. Step 2 – create a concatenated column as part… Read More
2024-02-01 17:02
https://youtu.be/i7Xex3oZhB8
One way to return multiple rows of data without using a Lookup function is to use the filter function. The filter function allows you to specify a range of cells… Read More
2024-01-30 15:57
https://youtu.be/Ed80cgrjYxk
The tracking Gantt and tracking table in Microsoft Project are useful tools for monitoring the progress of your project and comparing it with the original plan… Read More
2024-01-25 13:36
https://youtu.be/59JKOwXxZys
One of the features of Microsoft Word is the ability to insert and calculate formulas in a table. This can be useful for creating invoices, budgets, reports, and… Read More
2024-01-24 14:04
https://youtu.be/GKOpZh3eUQk
A style in Excel is a collection of formatting options that can be applied to a cell or a range of cells. Styles can help you create consistent and attractive wo… Read More
2024-01-23 11:51
https://youtu.be/jA3LY_7nJ5E
The DROP and TAKE functions in Excel are useful for extracting or excluding a portion of an array or range of cells. The syntax for both functions is similar, bu… Read More
2024-01-18 12:36
https://youtu.be/yivY-bHsn5Q
Concatenation is a process of combining two or more text values into one. In Microsoft Access, you can use an expression that uses the ampersand (&) operator… Read More
2024-01-17 12:54
https://youtu.be/2ry5isw1Hds
Free slack and total slack are two concepts that are used in project management to measure the amount of time that a task can be delayed without affecting the pr… Read More
2024-01-11 14:01
https://youtu.be/JI3WEAj5KpE
Hand gestures are a form of nonverbal communication that can convey various meanings and intentions depending on the context and culture. However, the same gestu… Read More
2024-01-10 12:09
https://youtu.be/zUq4hP6xqGw
Sum, average and count are some of the most commonly used functions in LibreOffice Calc. They allow you to perform basic calculations on a range of cells or a si… Read More
2024-01-08 13:23
https://youtu.be/oYk1tRsyRa0
One possible function that you can use in Excel to remove text strings in the middle of a sentence is the REPLACE function. The REPLACE function allows you to sp… Read More
2024-01-04 14:05
https://youtu.be/NZNs462_Wj4
Bookmarks are a useful feature in Microsoft Word that allow you to mark a specific location or a range of text in your document. You can use bookmarks to create… Read More
2024-01-03 14:03
https://youtu.be/cuUNrYeTuOo
A parameter query is a type of query that prompts the user for input when it is run. This allows the query to be more flexible and dynamic, as it can adapt to di… Read More
2023-12-19 13:27
https://youtu.be/_uufsk42-G8
The difference between edays and duration in project management is that edays are the estimated number of days (time elapsed) required to complete a task (includ… Read More
2023-12-14 02:03
https://youtu.be/jSIxMlrE57A
A project plan is a document that outlines the scope, objectives, deliverables, and resources of a project. It also defines the tasks, milestones, dependencies… Read More
2023-12-13 05:02
https://youtu.be/MY6vQcl2LD0
The team planner is a feature in Microsoft Project that allows you to assign and manage resources for your project tasks. You can use the team planner to view th… Read More
2023-12-12 17:01
https://youtu.be/awLF4Gom-ug
How to create simple measures in Power BI
Measures are calculations that you can use to analyse your data in Power BI. They are dynamic and can change depending… Read More
2023-12-07 15:28
https://youtu.be/6fDy5VMTK7U
If you want to combine tables in Microsoft Excel, you can use Power Query to merge or append them. Power Query is a data transformation and analysis tool that al… Read More
2023-12-06 16:17
https://youtu.be/kwHwmmixWKI
Linked notes are a feature in Microsoft Word that allows you to link your notes to a Word document, a PowerPoint presentation or another OneNote page. Linked not… Read More
2023-12-05 16:15
https://youtu.be/tAEUGYAUaLw
In Microsoft Access, tables are the basic objects that store data. However, sometimes you may want to perform calculations on the data in the tables, such as add… Read More
2023-11-30 16:16
https://youtu.be/qZR7XaIf8Bk
A validation list is a feature in Excel that allows you to restrict the values that can be entered in a cell and provide a drop-down list of options for the user… Read More
2023-11-29 16:19
https://youtu.be/-sI3D4Ajyfc
If you want to create diagrams or flowcharts in Visio that are based on data from Excel, you can link and automatically update Excel charts into Visio. This way… Read More
2023-11-28 16:17
https://youtu.be/ps8-9jWMEs0
A SmartArt diagram is a graphical way of presenting information in a PowerPoint, Word, or Excel. You can use a SmartArt diagram to show relationships, processes… Read More
2023-11-23 16:18
https://youtu.be/iV0FFrG3y58
In this tutorial, we will learn how to create a simple HR database part 4 using forms. Forms are a convenient way to enter, edit, and view data in a database. Th… Read More
2023-11-22 15:56
https://youtu.be/I7RJTX1Ir_I
If you want to work with a split screen in Microsoft Project, you can follow these steps:
– On the View tab, in the Split view group, select the Details ch… Read More
2023-11-21 16:09
https://youtu.be/puMnD3krtR8
Excel is a powerful and versatile tool that can help you organize, analyse and present data in various ways. However, many users are not aware of some of the hid… Read More
2023-11-16 14:06
https://youtu.be/wbVEo1BXL8U
A relationship in Access is a connection between two tables that defines how the data in those tables are related. Creating a relationship can help you ensure da… Read More
2023-11-14 00:02
https://youtu.be/EQeB2sifEjs
A lookup list is a feature in Microsoft Access that allows you to select a value from a predefined list of choices, rather than typing it manually. This can help… Read More
2023-11-09 16:20
https://youtu.be/PcKHQbxfBWk
To add an image into the background of a chart in PowerPoint, you need to follow these steps:
1. Select the chart that you want to modify. You can do this by cli… Read More
2023-11-08 15:58
https://youtu.be/nGGQtO0hOMY
This is an Access database tutorial covering how to create a simple HR database. One of the ways to create a table in Access is using the table design view. Thi… Read More
2023-11-07 12:26
https://youtu.be/32dXyLa56aM
This is a Microsoft Excel tutorial, covering how to find a record in one column, sort it and match it with the same record details in a second column. In this vi… Read More
2023-11-02 16:19
https://youtu.be/rb4lfWzyyTY
This is a Microsoft Excel tutorial covering Pivot tables and how to create your own slicer and group it with a Pivot chart. A slicer is a tool that allows you to… Read More
2023-11-01 14:42
https://youtu.be/bcmTTzuu8I8
The Resource usage or Task usage views in Microsoft Project are useful for displaying the work and cost information for each resource or task in your project. Yo… Read More
2023-10-31 16:06
https://youtu.be/WzSHDOx3bm4
This is a Microsoft Project tutorial covering how to change the default Gantt chart view. By changing the default Gantt view, you can customize how your project… Read More
2023-10-26 15:06
https://youtu.be/MaR2aiDEtfI
One of the ways to create a link that opens an email client is to use the hyperlink function with mailto. The mailto protocol allows you to specify the recipient… Read More
2023-10-25 14:59
https://youtu.be/r25NHGmKezA
This is a Microsoft Excel tutorial on how to create an automatic calendar. The tutor uses the Sequence function, with Date, Month and Year functions to achieve a… Read More
2023-10-23 16:05
https://youtu.be/0N0Ey37NGFc
This is a Microsoft Visio tutorial covering, how to add your own logo page and set it as a background page so that it appears on every page within your diagram… Read More
2023-10-18 11:22
https://youtu.be/zFfEf7hm-Io
One of the features of Microsoft Project is the ability to manage budget resources for your project. Budget resources are cost values that you assign to the proj… Read More
2023-10-17 13:06
https://youtu.be/SK6wK71_6oM
To create a flowchart in LibreOffice Draw, follow these steps:
– Open LibreOffice Draw and create a new document.
– From the menu, click View –… Read More
2023-10-12 15:12
https://youtu.be/lZSJi4TAHKU
Use report connections to link your slicer and timeline to multiple Pivot tables. This is a Microsoft Excel tutorial covering, how to control multiple Pivot tabl… Read More
2023-10-11 15:11
https://youtu.be/8PkOn0xRTEo
Create a simple list in Excel and use the concatenate feature to link the folder names to a MD text string. Copy all the concatenated data into a text document a… Read More
2023-10-10 15:49
https://youtu.be/nNoE-e4V-a0
If you want to create stunning presentations that will impress your audience, you need to learn how to use video effects inside text boxes in Microsoft PowerPoin… Read More
2023-10-05 15:16
https://youtu.be/sderAtPfl3A
One way to create option buttons in Microsoft Excel without using VBA is to use the Form Controls feature. Option buttons, also known as radio buttons, allow the… Read More
2023-10-04 15:04
https://youtu.be/cR6Fta8d-D4
If you want to create a mail merge document that contains different text or formatting depending on the data source, you can use the If Then Else field. This fie… Read More
2023-10-03 15:12
https://youtu.be/-It9ssZ3_rM
This is a Microsoft PowerPoint tutorial covering how to create a theme, save it and set it as a default theme. There are two main ways to create a theme. The fir… Read More
2023-09-28 15:16
https://youtu.be/bE9bXC0dKhk
This is a Microsoft Project tutorial covering how to use Text styles. Text styles are a way to apply consistent formatting to different elements of your project… Read More
2023-09-27 15:14
https://youtu.be/dnw-KfIP6oM
The navigation pane in Word is a useful tool that allows you to quickly navigate through your document, find text or objects, and reorganize your headings. Here… Read More
2023-09-26 14:22
https://youtu.be/MTTebSlgkV4
Microsoft Access tutorial covering Tab controls. Tab controls are useful for organizing the information on a form. They allow you to create multiple pages within… Read More
2023-09-21 15:18
https://youtu.be/WKxnmxhzIrE
The sum, average, max and min functions are some of the most commonly used functions in LibreOffice Calc. They allow you to perform basic calculations on a range… Read More
2023-09-20 14:46
https://youtu.be/8KHCUlG4YvU
Microsoft Visio is a powerful tool for creating diagrams, such as flowcharts, organisation charts and Gantt charts. Here are some steps to help you get started w… Read More
2023-09-19 07:19
https://youtu.be/bmSDh4jZfkc
One way to rank a list in Excel is to use the sort and take functions. The sort function can arrange the values in a list in ascending or descending order, based… Read More
2023-09-14 07:28
https://youtu.be/CpefAYki9PE
Creating and saving a theme in Microsoft Access can help you customize the appearance of your database and make it more appealing. A theme consists of a set of c… Read More
2023-09-13 07:21
https://youtu.be/xM3xImsLZXw
Priority is a feature in Project that allows you to assign a numerical value to each task, indicating how important or urgent it is. Priority can help you to pla… Read More
2023-09-12 15:15
https://youtu.be/FokWGHgJDJk
The drawing canvas is a feature in Microsoft Word that allows you to create and manipulate shapes, diagrams, and other graphics. You can use the drawing canvas t… Read More
2023-09-07 14:56
https://youtu.be/w0vX3lhGVc4
To use stack and scale in an Excel column chart, you need to format the data series in a specific way. First, you need to select the data series that you want to… Read More
2023-09-06 15:34
https://youtu.be/UiHa3aUYm6I
If you want to create a PowerPoint presentation from a Word document, you can use the Send to PowerPoint feature. This feature allows you to send the heading sty… Read More
2023-09-05 14:36
https://youtu.be/BhDdKRd7kL4
Presentation views are different ways of displaying a PowerPoint presentation on your computer screen or a projector. They allow you to edit, rehearse, and prese… Read More
2023-08-31 13:02
https://youtu.be/Gdoz442ZCrM
This is a Microsoft Visio tutorial on how to use Text Boxes. Text boxes are useful for adding text to a Visio drawing that is not part of a shape or connector. Y… Read More
2023-08-30 12:39
https://youtu.be/oWrZfB_nEr4
One way to link and automatically update Excel and Project data is to use the Paste Special command. This allows you to create a dynamic link between the two app… Read More
2023-08-29 13:03
https://youtu.be/D0lJgU34PTE
Option groups are useful for creating multiple choice questions or selecting one option from a list of alternatives in Microsoft Access forms. To create an optio… Read More
2023-08-24 07:02
https://youtu.be/SRuIzsUKjuE
One of the features of Microsoft Word is the ability to combine two or more documents into one. This can be useful for merging different versions of a document… Read More
2023-08-23 11:31
https://youtu.be/dywZIfpcreU
There are different ways to insert files in Microsoft Access, depending on the type and size of the file, and the purpose of storing it. Here are some common met… Read More
2023-08-22 10:48
https://youtu.be/X77lBXDhDoQ
OneNote is a powerful tool for organizing and managing your projects. In this video, you will learn how to use OneNote to create project notebooks, add notes, ta… Read More
2023-08-17 07:23
https://youtu.be/4susQLFxyOI
Hello and welcome to this video tutorial on how to share a Visio diagram with a colleague. Visio is a powerful tool that allows you to create and edit diagrams o… Read More
Subscribe to Steve Saxton's Blog | 1st For Training In Newcastle
Get updates delivered right to your inbox!