Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Word Tutorial: Learn Word in 30 Minutes – Just Right for your Job Application

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

 

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Creating Professional Reports in Access

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

1 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Access 2016 Tutorial: How to Create and Modify Reports in an Access Database

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/access2016/ It is suggested that you continue to part 12 after completing this module.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Linking the Tables and Defining the Relationships

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/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: http://kaceli.com
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.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint 2016: Using the Screen Capture Option in PowerPoint

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Creating a Table from .csv File; Primary and Foreign Keys

This is part 6 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating tables by importing data from Excel and .csv files and understanding the primary and foreign keys. Learn more at http://learn.kaceli.com

In more detail, this session we will focus on:
– How to create a table by importing the data from a .csv file in Access 2016
– Learn about setting the primary key in a table in Access 2016.
– Learn the concepts related to the foreign keys keys in a table.

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/1jNnEdrFydE. 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/access2016/

It is suggested that you continue to part 7 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: http://kaceli.com
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.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Calculated Fields in a Query in Access Databases

This is part 12 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating a calculated field in a query in Access. Learn more at http://learn.kaceli.com

https://www.youtube.com/watch?v=Vqlum-QeoLg

In more detail, this session we will focus on:
Sometimes one needs to calculate two or more fields from a query and post the total or calculation in a new field. This video covers all the steps to do this calculation by using the Query Builder feature 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/Vqlum-QeoLg. 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/access2016/

It is suggested that you continue to part 7 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: http://kaceli.com
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.

1 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Access 2016 Tutorial: Using Queries in an Access Database (Comprehensive)

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

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

In more detail, this session we will focus on:
– Queries are a key concept for anyone whether in business or as a student when using any type of database. So learn:
-How to create a query from multiple tables in Access Database using both the Query Wizard and the Query Design tools in Access 2016.
– Learn how to customize a query by adding new fields, adding criteria, sorting options etc.

 

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/iG_HzKK8VoE. 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/access2016/

It is suggested that you continue to part 7 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: http://kaceli.com
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.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Finding and Filtering Records via a Form in Access

This is part 9 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to finding and filtering data in a database using a Form. Learn more at http://learn.kaceli.com

https://www.youtube.com/watch?v=90eOatOmHZA

 

In more detail, this session we will focus on:
– How to locate records via a Form in Access 2016.
– How to locate customer data/records by customer ID or other field.
– Learn how to filter records by a particular field.

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/90eOatOmHZA. 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/access2016/

It is suggested that you continue to part 7 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: http://kaceli.com
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.

1 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Microsoft Access 2016 Tutorial: Creating and Customizing Forms and Subforms in Access

This is part 8 of the Access 2016 tutorial. This session focuses on concepts related to creating and customizing forms and subforms in a database. Learn more at http://learn.kaceli.com
https://www.youtube.com/watch?v=7bEeo1yBFno
In more detail, this session we will focus on:
– How to create a form with fields from multiple tables in Microsoft Access 2016.
– How to customize a form in Access 2016.
– How to create a compound form in Access 2016

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint 2016: Inserting Sound and Audio Recordings in Slides

This is part 11 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert audio and multimedia in a slide. For more info. see also our website: http://learn.kaceli.com

In detail we cover:
How to insert audio from a file on your PC in PowerPoint 2016.
How to play audio files automatically in a slide in PowerPoint.
Learn how to play an audio or sound file across all the slides in a presentation.
How to customize the playback options for slides in a presentation.
How to apply timings to play audio files.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint 2016: Animation in a Presentation in PowerPoint

This is part 13 of the series of tutorials on PowerPoint 2016. In this session we will learn how to use animations in slides. For more info. see also our website: http://learn.kaceli.com
https://www.youtube.com/watch?v=aQdT5nVkDqY
In detail we cover:
How to apply animation to objects in a slide in PowerPoint 2016
To to customize animations in a slide presentation
How to group items in a slide and adjust the animation
How to use animation in SmartArt objects in PowerPoint 2016

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint Tutorial: Learn PowerPoint in 30 Minutes – Just Right for your New Job

Learn how to use PowerPoint in exactly 30 minutes starting with the very basics (for the complete beginner) and then move to more intermediate and advanced features and become a pro. in just 30 minutes. For more info. visit http://kaceli.com or http://learn.kaceli.com.

I have designed it to be a resource for anyone starting to learn PowerPoint or is applying for a job and wants to know how to use PowerPoint and enhance their resume with presentation skills. The tutorial is based on PowerPoint 2016 and most features also work in PowerPoint 2013, PowerPoint 2010 and 2007.

Learn how to get started with PowerPoint and create your first slides.
Learn how to change the layout of the sides
Learn how to apply a design theme to slides in a presentation.
Learn how to use Design Ideas
Learn how to use the Morph Transition Feature in PowerPoint
Learn how to insert and embed video, sound and YouTube videos in PowerPoint.
Learn how to insert charts and SmartArt in PowerPoint.
Learn how to apply and use animation in a presentation.
Learn how to customize the slide master in PowerPoint.
Learn how to use notes and the presentation view along with notes in PowerPoint.
Learn how to send your presentation in PDF.
And more….

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.

The full PowerPoint 2016 Tutorial is available from here: https://youtu.be/8lXerL3DHRw
URL to PowerPoint in 30 Minutes: https://youtu.be/q1CMxb90g7c

In more detail, as you can see below, it includes everything you would need to know to sharpen your skills for a new job application.

Keep in touch:
Website: http://kaceli.com
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

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint 2016 Tutorial: Part 2 of 2

This is part 2 of 2 of the PowerPoint 2016 Tutorial. Learn intermediate and advanced features of PowerPoint in just one hour. Enhance your resume and advance in your career. For more info. visit us at http://learn.kaceli.com. To take an actual self-paced course in PowerPoint, see https://docs.google.com/document/d/11E89B2VT883q9-dsux-bFtDaskPZfsEv3JJUm_SVMYg/edit?usp=sharing

This video has been recorded in 1080p. Open it in full screen for a better experience.
Part 1 of the PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=8ovm_…
URL to Part 2: https://youtu.be/y9Kib2Pco3c
Link to course on PowerPoint:
Here is what we cover in Part 2: https://docs.google.com/document/d/11…
03:44 Learn how to use Advanced Grouping and Animation – Advanced Features
20:57 Learn how to record a slide presentation
25:17 Learn how to customize the Slide Master in PowerPoint 2016
29:50 Learn Rehearse timings in PowerPoint
32:56 Learn how to use notes in slides
37:12 Learn how to use the Presentation View in PowerPoint 2016
40:00 Learn how to use Quick Styles in PowerPoint
42:14 Learn how to create a Photo Album
44:40 Learn how to email your presentation
46:04 Learn how to save in PDF
47:12 Learn how to save the presentation in .mp4 video
52:36 Learn how to use templates in PowerPoint
56:56 Setup a custom slideshow
59:06 Screenshot option in PowerPoint
1:02:35 Using the Tell Me feature in PowerPoint
1:04:32 Changing the Office theme
1:06:07 Tips and Guidelines on using PowerPoint

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

PowerPoint 2016: How to Insert and Embed a Video in a Presentation in PowerPoint (10/30)

This is part 10 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert and customize videos in a slide.

In detail we cover:
How to embed a video in a presentation from the computer in PowerPoint 2016.
How to embed a video in a presentation from the the web in PowerPoint 2016.
How to embed a video a presentation in PowerPoint 2016.

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

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Inserting and Customizing Shapes in PowerPoint

PowerPoint for the absolute beginner. This is part 9 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert and customize shapes in a slide.

In detail we cover:
How to insert shapes in PowerPoint 2016
How to customize shapes in PowerPoint 2016
How to change the text wrapping for shapes in PowerPoint 2016.


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

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Inserting and Customizing Charts in PowerPoint 2016

PowerPoint for the absolute beginner. This is part 8 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert charts in a slide and how to customize them.

In detail we cover:
How to insert charts in a slide in PowerPoint 2016
How to customize charts and the data in the chart
How to use contextual tools in charts in PowerPoint.
Full PowerPoint 2016 Tutorial: https://youtu.be/lbc1HX8Jccw
URL to this video: https://youtu.be/SjrJAFlgeQM

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Using SmartArt in PowerPoint 2016

PowerPoint for the absolute beginner. This is part 7 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert SmartArt in a slide and how to customize them. For more info. see also our website: http://kaceli.com

In detail we cover:
How to insert SmartArt in PowerPoint 2016
How to convert a regular slide into SmartArt
How to modify and customize SmartArt in PowerPoint
How to add components to SmartArtt


Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1H…
URL to this video: https://youtu.be/Xaje8evR-fk

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

PowerPoint 2016 Tutorial: Inserting Pictures and Objects in Slides (6 of 30)

PowerPoint for the absolute beginner. This is part 6 of the series of tutorials on PowerPoint 2016. In this session we will learn how to insert pictures and objects in a slide and how to customize them.

In detail we cover:
Learn how to insert a new slide in the presentation.
Learn how insert pictures in slides in PowerPoint 2016
Learn about the Design Ideas in PowerPoint.
Learn how to format images and pictures in slides.
Learn how to crop images and tweak them.


Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1HX8Jccw
URL to this video: https://youtu.be/U_1xaWzwgk4

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

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:
It is suggested that you continue to part x after completing this module. If you are in education, you might be able to get Office 2016 for free from your institution: https://www.youtube.com/watch?v=PeGB7cvOdvw.

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

0 Read More

Importing or Reusing Slides in a Presentation in PowerPoint 2016

There are times where you are designing a presentation and you want to reuse a slide or two from another one that you had prepeared. The following tutorial demonstrates how you can import and reuse slides in PowerPoint 2016. The process shows how to also preserve the formatting of the original slide if needed.  This is part 5 of the series of tutorials on PowerPoint 2016.

In detail we cover:
How to reuse slides from another presentation in PowerPoint 2016.
How to import the slides with or without the previous design.
How to keep the source formatting of the slides from the previous presentation.


Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1H
URL to this video: https://youtu.be/-bYgCcsWE_o

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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

Microsoft 2016 Tutorial: Creating Tables by Importing Data from Excel and .csv Files

This is part 5 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating tables by importing data from Excel and .csv files.

In more detail, this session we will focus on:
How to use the data files for the Access tutorial in order to create tables.
How to use the wizard to import data from Excel and .csv files to create table structures in Microsoft 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/gRmXY4TP5Y4. The full tutorial is coming soon. Stay tuned.
Link to the working files for the tutorial: https://kaceli.com/access2016/

It is suggested that you continue to part 6 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: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli

Read More

Using the Design Ideas Feature in PowerPoint 2016

PowerPoint for the absolute beginner. This is part 4 of the series of tutorials on PowerPoint 2016. In this session we will learn how to use the Design Ideas tool in your slides. For more info. see also our website: https://kaceli.com

We cover:
How to use Design Ideas in PowerPoint 2016.
Learn how to Apply Design ideas to an existing slide in PowerPoint.
Learn how to apply Design Ideas to images in PowerPoint.
Learn how to create professional looking slides in PowerPoint with just a few clicks.


Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1HX8Jccw
URL to this video: https://youtu.be/WlRcaMHsmPM

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
YouTube Channel: http://youtube.com/skaceli

Stay tuned for new videos every Monday.

0 Read More

How to Apply a Design Theme to Slides in PowePoint

PowerPoint for the absolute beginner. This is part 3 of the series of tutorials PowerPoint 2016. In this session we will learn how apply a design theme to a bunch of slides and change the design of your slides with just a few clicks.

We cover:
How to change the slide layout in PowerPoint 2016
Learn to apply a design theme to all the slides or some of the slides in a presentation.
Learn how to apply a particular theme to only certain slides
Learn how to set the default theme.
Learn about the Variants in PowerPoint 2016
Learn how to change the side format to 16×9 wide screen mode for your presentations.
Learn how to hide backgrounds in slides.


Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1HX8Jccw
URL to this video: https://youtu.be/oGG6BbGNqqA

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:
It is suggested that you continue to part 2 after watching this video.

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

Stay tuned for new videos every Monday.

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:
It is suggested that you continue to part x after completing this module. If you are in education, you might be able to get Office 2016 for free from your institution: https://www.youtube.com/watch?v=PeGB7cvOdvw.

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

 

 

0 Read More

PowerPoint for the Absolute Beginner – PowerPoint 2016

PowerPoint for the absolute beginner. This is part 2 of the series of tutorials PowerPoint 2016. In this session we will learn how create a presentation from scratch. For more info. see also our website: https://kaceli.com

https://www.youtube.com/edit?video_id=llUkjr7GZ1w

We cover:

The types of slide layouts.
Creating the title slide
Adding new slides in PowerPoint 2016
Changing the slide layout in PowerPoint 2016.
Inserting images from the web and resizing the images.
How to present a presentation in PowerPoint 2016
How to apply a design to your presentation in PowerPoint 2016
Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1HX8Jccw
URL to this video: https://youtu.be/llUkjr7GZ1w

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:
It is suggested that you continue to part 2 after watching this video.

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

https://www.youtube.com/edit?video_id=llUkjr7GZ1w

 

0 Read More

Microsoft Access 2016: Modifying Tables, Creating Forms, Queries and Reports

This is part 4 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to modifying a table, creating forms, reports and queries. For more info. see also https://kaceli.com

In more detail, this session we will focus on:
Learn how to modify an existing table in Microsoft Access 2016
Learn how to create queries in Access 2016
Learn how to create yes/no fields in a table
Learn how to insert design notes in the table design
Learn about primary keys in Access 2016
Learn how to create a form from a table in Access 2016
Learn how to use the Form Wizard in Acces 2016
Learn how to modify the Forms in Access Databases
Learn how to create queries in a database in Access 2016
Learn how to create reports 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/1r47z7YRYwM
It is suggested that you continue to part 5 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
YouTube Channel: http://youtube.com/skaceli

 

0 Read More

Getting Started with PowerPoint 2016 – PowerPoint for the Absolute Beginner

PowerPoint for the absolute beginner. This is part 1 of the series of tutorials PowerPoint 2016 tutorials. In this session we will learn how to get started with PowerPoint 2016, learn about the user interface, components of PowerPoint and how to get started the right way with PowerPoint 2016. For more info.

Full PowerPoint 2016 Tutorial: https://www.youtube.com/watch?v=lbc1HX8Jccw
URL to this video: https://youtu.be/7_9lppn6PJo

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:
It is suggested that you continue to part 2 after watching this video.

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

Stay tuned for new videos every Monday.

0 Read More

Access 2016: Creating a Database from Scratch

This is part 3 of a multiple part series of the Access 2016 tutorial. This session focuses on concepts related to creating a database from scratch and designing tables in Access.

In more detail, this session we will focus on:
Creating a database from scratch in Access 2016
Learn components of Microsoft Access and what various components do.
Learn about external data in Access
Database tools and database relationships
The Tell Me feature in Access 2016
Creating and designing tables in Access databases
Creating fields in a table in an Access database
Defining the data types in a table in Access 2016
Records and fields in an Access database
Defining types of fields in an Access database
Defining the primary key in a table
Saving the table
Changing the design of a table in Access 2016
Using the Design View to modify the structure of a table in Access 2016
Setting the field size length in a table.

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/FfmNqu0wP00
It is suggested that you continue to part 4 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
YouTube Channel: http://youtube.com/skaceli

0 Read More

Access 2016 for Beginners: Getting Started & Using Templates

Her is part 2 of a multipart series on Microsoft Access 2016 for beginners. In this session we go over how to get started with Access and how to access the templates.

In this session, we cover:
How to get started with Access 2016.
How to work with database templates.
How a database works via a template.

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.

Getting Started with Access 2016 video URL: https://youtu.be/8ncP_Wo0lwo

The full video on Access is coming. Stay tuned.

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

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:
It is suggested that you continue to part x after completing this module. If you are in education, you might be able to get Office 2016 for free from your institution: https://www.youtube.com/watch?v=PeGB7cvOdvw.

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

0 Read More

Microsoft Access 2016 for Beginners: Getting Started with the Absolute Basics

Did you ever want to learn how to use Microsoft Access and just feared getting started. Fear no more.  In this session we cover the most basic concepts related to Access databases. We go over tables, queries, forms and reports.

Learn:

  1. What is a database?
  2. What is Microsoft Access?
  3. Database components: Tables, Queries, Forms and Reports
  4. A brief overview of an actual database with a table, query, form and report.

 

The full video on Access is coming. Stay tuned.

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

0 Read More

Edwiser RemUI Theme for Moodle – Make your Moodle Site Look Great Again

I recently tested a new very nice theme on my Moodle site: http://learn.kaceli.com.  The Edwiser RemUI theme is a great improvement for Moodle.  It makes your Moodle site look modern again both on the desktop and mobile. RemUI is designed with the end-user in mind and it is very visually appealing allowing both Moodle users and administrators to customize the site to their liking. It also has options for a very fancy front page including a rotating banner along with a very cool dashboard. For more info. and a live demo,  click here.

I also put together a video on the features of RemUI. It is a great theme I highly recommend it.

 

 

0 Read More

PowerPoint 2016: Complete Tutorial on PowerPoint in Full HD

Below is my comprehensive 31 module tutorial (in Full HD 1080P) on PowerPoint 2016 for business professionals, students or anyone who wants to advance in their career. Learn how to use PowerPoint effectively. I start with the very basics and move into the more advanced features such as creating advanced designs and animations for impressive presentations. Checkout the table of contents below for the major topics covered here. If you like the work below, please also subscribe to my YouTube channel and use the share links below the video on YouTube to share the link with your friends. If you find it helpful and want to support this work, you can buy me a coffee from here: https://paypal.me/sali.

00:70 Welcome to PowerPoint 2016
01:00 Getting Started with PowerPoint – Understanding the User Interface in PowerPoint
05:07 Creating your first presentation from scratch in PowerPoint 2016
11:55 Applying a design theme to your PowerPoint presentation
17:58 Learn how to use the PowerPoint Designer: Design Ideas
20:43 Learn how to import and reuse slides in PowerPoint 2016
23:01 Learn how to insert pictures in a presentation
26:35 Learn how to insert images from the Internet and apply Design Ideas
28:46 Learn how to apply SmartArt in PowerPoint 2016
33:28 Learn how to insert charts in PowerPoint
37:22 Learn how to insert and customize shapes in PowerPoint
39:05 Learn how to insert videos and multimedia
44:10 Learn how to insert audio and music in slides
47:40 Learn how to use Screen Capture and embeding
50:47 Learn how to use the Morph Transition in PowerPoint 2016
56:31 Learn how to use animations in PowerPoint
1:03:44 Learn how to use Advanced Grouping and Animation – Advanced Features
1:20:57 Learn how to record a slide presentation
1:25:17 Learn how to customize the Slide Master in PowerPoint 2016
1:29:50 Learn Rehearse timings in PowerPoint
1:32:56 Learn how to use notes in slides
1:37:12 Learn how to use the Presentation View in PowerPoint 2016
1:40:00 Learn how to use Quick Styles in PowerPoint
1:42:14 Learn how ot create a Photo Album
1:44:40 Learn how to email your presentation
1:46:04 Learn how to save in PDF
1:47:12 Learn how to save the presentation in .mp4 video
1:52:36 Learn how to use templates in PowerPoint
1:56:56 Setup a custom slideshow
1:59:06 Screenshot option in PowerPoint
2:02:35 Using the Tell Me feature in PowerPoint
2:04:32 Changing the Office theme
2:06:07 Tips and Guidelines on using PowerPoint

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.

Microsoft PowerPoint 2016 Tutorial: https://youtu.be/lbc1HX8Jccw

Keep in touch:
Website: https://kaceli.com
YouTube Channel: http://youtube.com/skaceli
If anyone wants to help with the close captions, let me know.

0 Read More

Excel Tutorial 2016: Excel Part 2 of 2 – Intermediate to Advanced Tutorial

A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. This is part 2 of 2 of the Excel 2016 tutorial. Check it out. You will not be disappointed. Visit us also at https://kaceli.com for more info. The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.

 

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.

Microsoft Excel 2016 Tutorial URL: https://youtu.be/8lXerL3DHRw

Microsoft Excel 2016 Tutorial Part I: https://www.youtube.com/watch?v=xUM-GvJwTrw
Microsoft Excel 2016 Tutorial Part II: https://youtu.be/-wJBzxefr8k

The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https://kaceli.com/excel-2016-data-file/

Here is what is covered along with the times. The times might be a bit off. If someone is willing to update them, I can post them here.

00:05 Learn how to use Named References and Cross-sheet calculations in Excel 2016
1:02:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations
10:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016
22:21 Learn how to use the IF statement and logical functions in Excel 2016
28:29 Learn how to use One Click Forecasting in Excel 2016
30:03 Learn how to use the new and modern charts in Excel 2016
31:43 Learn how to use Pivot Tables in Excel 2016
38:06 Learn how to use Data Gathering in Excel 2016
40:14 Learn how to use the new Financial Charts in Excel 2016
39:45 Learn how to use the 3D Maps and Data Visualization Exel 2016
43:41 Learn how to use the Freeze Panes in Excel 2016
45:11 Learn how to Set the Print Area in Excel 2016
47:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016
48:14 Learn how to use data validation in Excel 2016
51:56 Learn how to link Excel Data to a Word Report
56:29 Learn how to import and export data in Excel 2016
58:47 Learn how to export an Excel file to PDF in Excel 2016

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

0 Read More

Excel 2016 Tutorial – Beginner to Intermediate

Want to learn Excel? Here is part 1 of a 2 part series tutorial on Excel 2016. I have designed it to be concepts-based and simple to follow. Check it out.

A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel.  The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.

Link to Excel 2016 Part I Tutorial: https://youtu.be/xUM-GvJwTrw
Full Excel 2016 Tutorial URL: https://youtu.be/8lXerL3DHRw

The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https://kaceli.com/excel-2016-data-file/

The following are covered in detail along with the starting times:
00:07 Getting Started with Excel 2016 – Learn the basics including the Tell Me feature.
11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT
21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016
25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016
32:41 Learn about the Quick Analysis Tools in Excel 2016
35:51 Learn about Data Sorting and Data Filtering in Excel 206
39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016
49:30 Learn how to create and use charts in Excel 2016
55:49 Learn how to use the Flash Fill Data feature in Excel 2016
Keep in touch:
Website: https://kaceli.com
YouTube Channel: http://youtube.com/skaceli

 

0 Read More

How to Mirror your Android Phone Screen to a Windows 10 PC Without Installing any Additional Apps

There are times where you would like to present a PowerPoint to your audience or mirror what is on your phone to a large monitor for convenience. This is now very doable in Windows 10 by using the Connect application. This allows you to roam around the room and even annotate on the screen  from your Android device all of this via a wireless connection.

The steps are pretty simple as also outlined in the video below

  1. Open up the Connect application from your Windows 10 laptop. Note, the computer must have the anniversary updates (August 2016 update) installed for this to work
  2. Then on your Android device go to Settings and locate screen sharing or mirroring and choose to enable it.
  3. Once your laptop is located, now connect to it and that is it. See the video below for more step-by-step details.

5 Read More

How to Free up and Reclaim 20+ GB of Storage when Using a Solid State Drive in Windows 10

 

Every time you upgrade from one version of Windows to another, the system retains a copy of your previous version in case you want to go back. This is true when upgrading Windows 8.x to Windows 10 or even Windows 10 to Windows 10 Anniversary Edition. When you do this, you will typically lose around 20GB of storage from your hard drive. So the question is how can you reclaim some of the lost storage?

This can be a problem particularly when using a Solid State Drive or you are already running out of space. In this case, the solution is to simply remove the backup copy of the previous Windows version. Do this only when you are sure the  upgrade was successful and you do not intend to go back.

If you are sure and want to reclaim your hard drive space, check out this brief 3 minute tutorial.

If you liked this video, check out also the other videos on Windows 10 subscribing to the YouTube channel. Feel free to also post comments below.

0 Read More

How to change the slide master or master slide in PowerPoint (2007, 2010, 2013, 2016)

If you want to save time with your PowerPoint presentations, consider modifying the slide master. You can make the change in one location and the changes will be automatically be applied to all the slides of the same kind in your presentation. Tweak your graphics, fonts, bullet lists, backgrounds or anything you want. It is that easy. See the video below on how it is done.

 

If you would like to learn more about PowerPoint, check the full tutorial from here.

1 Read More

PowerPoint 2013: Embedding Online Videos and Multimedia in a Presentation

Here is a quick tutorial on how to embed online videos even from YouTube in a presentation in PowerPoint 2013.

Learn how to embed a YouTube video into your presentation.
Learn how to play a YouTube video directly from a slide in your PowerPoint presentation.
Learn how to insert video into a slide from a file in your computer
Learn how to insert sound and control the playing in a slide or across multiple slides

 

Comments or questions, please post them below. Thanks for subscribing to https://kaceli.com.

2 Read More

Excel 2016 Basics: Learn the key function of Excel in just a few minutes

Learn the basics of Excel in just a few minutes and sharpen your skills for your new job and career. In this video I cover how to get started with the formulas and functions and learn particularly about key functions such as SUM, MIN, AVERAGE, COUNT etc. in Excel 2016.  These are key features of the application that anyone in the workplace should know. This is part 2 of 25 part series on Excel 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.

Excel 2016 Full Tutorial is available from here: https://www.youtube.com/watch?v=8lXerL3DHRw

In this video we cover the following:

  • Learn about cells, references and worksheets in Excel 2016.
  • Learn about formatting cells in Excel 2016
  • Learn about the various data types in a cell in Excel 2016
  • Learn about the basic key functions such as SUM, AVERAGE, COUNT, MIN, MAX that everyone should know in Excel 2016

Video URL: https://youtu.be/UNI4argFJvk
It is suggested that you continue to part 3 after completing this module. If you are in education, you might be able to get Office 2016 for free from your institution: https://www.youtube.com/watch?v=PeGB7cvOdvw.

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

0 Read More

Warning: imagecreatetruecolor(): Invalid image dimensions in /home3/kacelite/public_html/wp-includes/media.php on line 2836

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home3/kacelite/public_html/wp-includes/class-wp-image-editor-gd.php on line 183

Excel 2016 Tutorial: A Complete Guide to Excel 2016

Here is a comprehensive tutorial on using Excel 2016, whether you are a student, a business user or in a corporate environment. Learn Excel (including the new features) in just a couple hours from the basics to the advanced features such as financial formulas to recharge your career and resume. Visit us also at https://kaceli.com for more info. The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.

https://www.youtube.com/watch?v=8lXerL3DHRw

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.

Excel 2016 Tutorial URL: https://youtu.be/8lXerL3DHRw

The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https://kaceli.com/word2016files/

The following are covered in detail along with the starting times:
00:07 Getting Started with Excel 2016 – Learn the basics including the Tell Me feature.
11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT
21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016
25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016
32:41 Learn about the Quick Analysis Tools in Excel 2016
35:51 Learn about Data Sorting and Data Filtering in Excel 206
39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016
49:30 Learn how to create and use charts in Excel 2016
55:49 Learn how to use the Flash Fill Data feature in Excel 2016
58:17 Learn how to use Named References and Cross-sheet calculations in Excel 2016
1:04:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations
1:12:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016
1:24:21 Learn how to use the IF statement and logical functions in Excel 2016
1:30:29 Learn how to use One Click Forecasting in Excel 2016
1:32:03 Learn how to use the new and modern charts in Excel 2016
1:33:43 Learn how to use Pivot Tables in Excel 2016
1:40:06 Learn how to use Data Gathering in Excel 2016
1:42:14 Learn how to use the new Financial Charts in Excel 2016
1:53:45 Learn how to use the 3D Maps and Data Visualization Exel 2016
1:45:41 Learn how to use the Freeze Panes in Excel 2016
1:47:11 Learn how to Set the Print Area in Excel 2016
1:49:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016
1:50:14 Learn how to use data validation in Excel 2016
1:53:56 Learn how to link Excel Data to a Word Report
1:58:29 Learn how to import and export data in Excel 2016
2:02:47 Learn how to export an Excel file to PDF in Excel 2016

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

1 Read More

Getting Started with Excel 2016 – Part 1 for the Absolute Beginner

Here is a step-by-step tutorial on getting started with Excel 2016 for the absolute beginner. This tutorial is part of a series of short tutorials on Excel 2016. The same concepts outlined here apply to earlier versions of Excel too.

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.

Learn how to get started with Excel 2016.
Learn how to access and use Excel templates
Learn about the Tell Me feature in Excel 2016
Learn about concepts navigating the application such as the Ribbon and various groupings. Get started on the right foot.
Learn about cell cells, rows, columns, active cells in Excel 2016,
Learn about formatting cells and various data types in Excel 2016
Learn about formulas and functions in Excel 2016
Video URL: https://youtu.be/c-1hCw-ncCg
It is suggested that you continue to part 2 after completing this module. If you are in education, you might be able to get Office 2016 for free from your institution: https://www.youtube.com/watch?v=PeGB7cvOdvw.

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

2 Read More
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap. Thank you, Sali Kaceli

No part of the content posted on this site may be downloaded or distributed without permission. Contact us if you have such a need.