About This Course
Course Curriculum
-
Introduction to Microsoft Excel 2019 New Features00:07:00
-
CONCAT00:02:00
-
IFS00:01:00
-
MAXIFS00:01:00
-
MINIFS00:01:00
-
SWITCH00:02:00
-
TEXTJOIN00:01:00
-
Map Chart00:02:00
-
Funnel Chart00:01:00
-
Better Visuals00:06:00
-
Pivot Table Enhancements00:02:00
-
Power Pivot Updates00:01:00
-
Navigate the Excel User Interface00:28:00
-
Use Excel Commands00:10:00
-
Create and Save a Basic Workbook00:19:00
-
Enter Cell Data00:12:00
-
Use Excel Help00:05:00
-
Create Worksheet Formulas00:15:00
-
Insert Functions00:17:00
-
Reuse Formulas and Functions00:17:00
-
Insert, Delete, and Adjust Cells, Columns, and Rows00:10:00
-
Search for and Replace Data00:09:00
-
Use Proofing and Research Tools00:07:00
-
Apply Text Formats00:16:00
-
Apply Number Format00:07:00
-
Align Cell Contents00:09:00
-
Apply Styles and Themes00:12:00
-
Apply Basic Conditional Formatting00:11:00
-
Create and Use Templates00:08:00
-
Preview and Print a Workbook00:10:00
-
Set Up the Page Layout00:09:00
-
Configure Headers and Footers00:07:00
-
Manage Worksheets00:05:00
-
Manage Workbook and Worksheet Views00:07:00
-
Manage Workbook Properties00:06:00
-
Introduction to Microsoft Word 2019 New Features00:14:00
-
Inking Tools00:03:00
-
Inking Tools 100:07:00
-
Learning Tools00:07:00
-
Microsoft Translate00:03:00
-
LaTeX00:05:00
-
Smart Lookup00:04:00
-
Side to Side Scrolling00:02:00
-
Scalable Vector Graphics00:03:00
-
Navigate in Microsoft Word00:12:00
-
Create and Save Word Documents00:24:00
-
Manage Your Workspace00:06:00
-
Edit Documents00:16:00
-
Preview and Print Documents00:04:00
-
Customize the Word Environment00:08:00
-
Apply Character Formatting00:17:00
-
Control Paragraph Layout00:19:00
-
Align Text Using Tabs00:07:00
-
Display Text in Bulleted or Numbered Lists00:03:00
-
Apply Borders and Shading00:04:00
-
Make Repetitive Edits00:06:00
-
Apply Repetitive Formatting00:10:00
-
Use Styles to Streamline Repetitive Formatting Tasks00:14:00
-
Sort a List00:05:00
-
Format a List00:06:00
-
Inserting a Table00:06:00
-
Modify a Table00:06:00
-
Format a Table00:03:00
-
Convert Text to a Table00:04:00
-
Insert Symbols and Special Characters00:04:00
-
Add Images to a Document00:11:00
-
Apply a Page Border and Color00:03:00
-
Add Headers and Footers00:06:00
-
Control Page Layout00:05:00
-
Add a Watermark00:04:00
-
Check Spelling Grammar and Readability00:07:00
-
Use Proofing and Research Tools00:07:00
-
Check Accessibility00:03:00
-
Save a Document to Other Formats00:04:00
-
Workbooks – Microsoft Word 2016 (Beginner)
-
Introduction to Microsoft PowerPoint 2019 New Features00:06:00
-
Highlighting00:02:00
-
Morph Transition00:03:00
-
Zoom00:03:00
-
Vector Graphics00:03:00
-
SVG Icons to Shapes00:04:00
-
3D Modeling00:04:00
-
Background Removal00:03:00
-
4K00:03:00
-
Navigate the PowerPoint Environment00:28:00
-
View and Navigate a Presentation00:15:00
-
Create and Save a PowerPoint Presentation00:13:00
-
Use PowerPoint Help00:10:00
-
Select a Presentation Type00:08:00
-
Edit Text00:13:00
-
Build a Presentation00:27:00
-
Format Characters00:11:00
-
Format Paragraphs00:16:00
-
Format Text Boxes00:09:00
-
Insert Images00:10:00
-
Insert Shapes00:15:00
-
Edit Objects00:16:00
-
Format Objects00:06:00
-
Group Objects00:04:00
-
Arrange Objects00:07:00
-
Animate Objects00:07:00
-
Create a Table00:09:00
-
Format a Table00:03:00
-
Insert a Table from Other Microsoft Office Applications00:06:00
-
Create a Chart00:10:00
-
Format a Chart00:10:00
-
Insert a Chart from Microsoft Excel00:05:00
-
Review Your Presentation00:11:00
-
Apply Transitions00:05:00
-
Print Your Presentation00:05:00
-
Deliver Your Presentation00:08:00
-
Introduction to Microsoft Access 2019 New Features00:05:00
-
Window Resize00:01:00
-
Charts00:02:00
-
dbf00:01:00
-
Large Number00:01:00
-
Property Sorting00:01:00
-
Orientation to Microsoft Access00:39:00
-
Create a Simple Access Database00:10:00
-
Get Help and Configure Options in Microsoft Access00:06:00
-
Modify Table Data00:17:00
-
Sort and Filter Records00:05:00
-
Create Basic Queries00:15:00
-
Sort and Filter Data in a Query00:14:00
-
Perform Calculations in a Query00:08:00
-
Create Basic Access Forms00:07:00
-
Work with Data on Access Forms00:23:00
-
Create a Report00:28:00
-
Add Controls to a Report00:12:00
-
Enhance the Appearance of a Report00:05:00
-
Prepare a Report for Print00:03:00
-
Organize Report Information00:15:00
-
Format Reports00:12:00
-
Assignment – Microsoft Office Bundle08:26:00
-
Order Your Certificate