Blog

Here is a quick tutorial on how to use VLOOKUP in Excel along with a few scenarios and examples: https://youtu.be/sMeT-xuL2fQ.

Comments are welcome. 

Here is a quick tutorial on how to export data from Access tables, queries and reports to Microsoft Access. Just a couple clicks and you are done.

User input queries and reports are a powerful feature for any Access database user. This feature makes running reports and queries a breeze and allows you the flexibility to specify query parameters at any time you execute it. The following video demonstrates how to design a custom query or report where you can specify the date or the date range. And it is pretty easy and can do it with all kinds of fields and criteria.

Learn more by also checking the full Access 2016 tutorial or by taking the Access self-paced course.

I recently decided to give a try to Vimeo Pro and see how hosting videos works on the platform. I am finding it to be very user friendly and not too distracting for the viewer. I am actually now even hosting my Excel 2016 tutorial on this platform as it provides a rental option. This method of streaming would be helpful for training purposes for your employees etc. with no distractions.

Check it out. No ads, just learning.

Google Drive is a great tool for creating content, sharing the content and collaborating with others on projects. I have thus created a 30 minute video just for this. It starts with the very basics and proceed with the various aspects of creating content, uploading, proper sharing and managing the files. Check it out and comment below if you have questions.

https://youtu.be/o55y_2kLY3chttp://

A concise tutorial on Microsoft Word covering most features in a condensed way for a job application or to enhance the resume with tech. skills. For more info. visit http://learn.kaceli.com

https://www.youtube.com/watch?v=h30gwD0misA

For those of you who want to learn at a slower pace, please see the full tutorial on Word 2016 here: https://youtu.be/IaiZc0jomz4.

Word in 30 minutes URL: https://youtu.be/h30gwD0misA

This video covers the following areas:
00:10 Getting started with Word 2016 and templates
01:10 Starting with a blank document and the general user interface components. Getting to know Word.
03:57 Basic formatting features in Word: fonts, bullets, search and replace and format painter.
05:26 Formatting styles and applying heading 1, 2, 3 styles in a document.
07:58 Using the Format Painter tool
08:45 Using Search and Replace
09:16 Inserting media in a document.
10:27 Inserting pictures from the Web
11:10 Using SmartArt in a document
12:04 Inserting tables
12:36 Inserting charts in a document
13:32 Inserting media from the Web such as embedding videos in a document
14:00 Inserting hyperlinks in a document
14:31 Using comments in a document.
14:59 Using Headers and footers in a document
15:39 Changing margins in a document
16:15 Creating columns in a document
17:01 Creating a table of contents
18:36 Inserting footnotes and endnotes in a document
21:22 Creating a mail merge
26:17 Creating a label mail merge in Word 2016.
28:00 Using Macros in Word.

Keep in touch:
Website: https://kaceli.com/a
YouTube Channel: http://youtube.com/skaceli

[wysija_form id=”1″]

This is part 13 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating and customizing reports from multiple tables in Access 2016. Learn more at http://learn.kaceli.com

In more detail, this session we will focus on:
Learn how to create a report with data from multiple tables in Access 2016.
Learn how to customize reports using the Layout View and the Design View.
Learn how to create professional reports in Microsoft Access.
Learn how to add new fields in an existing report in Access.
Learn how to move fields in a report.
Learn how to change the control source for a field in a report.

https://www.youtube.com/watch?v=0LewmVdZZ7c

In more detail, this session we will focus on:

• Learn how to create a report in Access 2016.
• Learn how to select data fields from multiple tables in Access 2016.
• Learn how to customize a report in Access 2016.
• Learn how to use the Layout View and the Design view in Access 2016.
• Learn how to remove and add new fields in a report in Access 2016.

https://youtu.be/ve_opOuLNiI

Video URL: https://youtu.be/ve_opOuLNiI The full tutorial is coming soon. Stay tuned. Access 2016 Part I is here if you want to start from the beginning: https://youtu.be/1IA4SeajZRw Link to the working files for the tutorial: https://kaceli.com/a/access2016/ It is suggested that you continue to part 12 after completing this module.

This is part 7 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to linking Access tables in a database and properly defining the relationships. Learn more at http://learn.kaceli.com

In more detail, this session we will focus on:
– Understand what relational databases are and how to link the tables in the database.
– Understanding the use primary and foreign keys in Access 2016.
– Learn how to define the relationships between the tables.
– Learn how to save the defined relationships between the tables.
– Explore how to run a query from the linked tables in Access 2016.

If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Video URL: https://youtu.be/g4geW2Ybky8. The full tutorial is coming soon. Stay tuned. Access 2016 Part I is here if you want to start from the beginning: https://youtu.be/1IA4SeajZRw

Link to the working files for the tutorial: https://kaceli.com/a/access2016/

It is suggested that you continue to part 8 after completing this module.

Keep in touch and please spread the word by subscribing and using the share links below the video and commenting:
Website: https://kaceli.com/a
YouTube Channel: http://youtube.com/skaceli
If you want to take get a deeper understanding of Microsoft Access, take a look at http://learn.kaceli.com

Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

This is part 12 of the series of tutorials on PowerPoint 2016. In this session we will learn how to capture portions of your screen and use them in a slide. For more info. see also our website: http://learn.kaceli.com

In detail we cover:
How to use the screen capture feature in PowerPoint 2016
How to embed and utilize captured screens in slides in a presentation.

Full PowerPoint 2016 Tutorial: https://youtu.be/lbc1HX8Jccw
URL to this video: https://youtu.be/pePSR53sqX0

If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.

Keep in touch:
Website: https://kaceli.com/a
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.