Канал: Beauty of the Life

Replace and Substitute Text Manipulation

Replace and Substitute Text Manipulation

Lower Case, Upper Case, Title Case

Lower Case, Upper Case, Title Case

Concatenate and Left Function in Text Manipulation

Concatenate and Left Function in Text Manipulation

Find and Mid Text Manipulation

Find and Mid Text Manipulation

Trim and LEN Functions

Trim and LEN Functions

Adding Custom Views to Ribbon

Adding Custom Views to Ribbon

Editing Custom Views

Editing Custom Views

Auto Outlines and Custom Views

Auto Outlines and Custom Views

Custom Views

Custom Views

Scenario Summary

Scenario Summary

Merge and Delete Function in Scenario Manager

Merge and Delete Function in Scenario Manager

Scenario Manager Tips

Scenario Manager Tips

Using The Scenario Manager

Using The Scenario Manager

Scenario Manager

Scenario Manager

Editing Outlines

Editing Outlines

Manual Outling

Manual Outling

Auto Outlines

Auto Outlines

34 131 Loan Elements Calculations Rate, Nper, PV

34 131 Loan Elements Calculations Rate, Nper, PV

Loans and Savings Calculations

Loans and Savings Calculations

The RAND Function

The RAND Function

MOD and INT Functions

MOD and INT Functions

The Rounding Function in Excel

The Rounding Function in Excel

Excel Time and Date Functions

Excel Time and Date Functions

Time Calculation in Excel

Time Calculation in Excel

Time in Excel

Time in Excel

Removing Sparklines

Removing Sparklines

Comparing Sparlines in a Sparkline Group

Comparing Sparlines in a Sparkline Group

Sparklines and Empty Cells

Sparklines and Empty Cells

Sparkline Tool

Sparkline Tool

Sparklines

Sparklines

Managing Lookup Tables

Managing Lookup Tables

Dealing with Errors in Lookup Syntax

Dealing with Errors in Lookup Syntax

Near Match lookup with Vlookup

Near Match lookup with Vlookup

Hlookup in real life

Hlookup in real life

Vlookup in real life

Vlookup in real life

Vlookup Syntax

Vlookup Syntax

FormulaText

FormulaText

Not Operator within AND and OR Statements

Not Operator within AND and OR Statements

OR Operator with the IF Syntax

OR Operator with the IF Syntax

AND Operator with If Syntax

AND Operator with If Syntax

Nested If Syntax

Nested If Syntax

IF Syntax

IF Syntax

Area and Volume calculations

Area and Volume calculations

Multiple criteria CountIFS, SumIFS, AverageIFS

Multiple criteria CountIFS, SumIFS, AverageIFS

More AverageIf Functions

More AverageIf Functions

More CountIF Functions

More CountIF Functions

More SUMIF Functions

More SUMIF Functions

MODE, MEDIAN, MEAN AVERAGE Functions

MODE, MEDIAN, MEAN AVERAGE Functions

SUM, COUNT, MIN, MAX Functions

SUM, COUNT, MIN, MAX Functions

Microsoft Account

Microsoft Account

Managing Rules

Managing Rules

New Formatting Rule

New Formatting Rule

Top Bottom Rules

Top Bottom Rules

Data Bars, Color Scales, Icon Sets

Data Bars, Color Scales, Icon Sets

Cell Conditional Formatting

Cell Conditional Formatting

Rank Function

Rank Function

SumIF, CountIF,AverageIF Functions

SumIF, CountIF,AverageIF Functions

Text Function to Format Numbers

Text Function to Format Numbers

Using the datedif Function

Using the datedif Function

Using the IF Function to hide Error Messages

Using the IF Function to hide Error Messages

The IF Function

The IF Function

Text To Column Wizard

Text To Column Wizard

Sort and Subtotal Function

Sort and Subtotal Function

Remove Duplicates

Remove Duplicates

Filtering Data

Filtering Data

Freeze Panes

Freeze Panes

Sparklines

Sparklines

Pie Charts

Pie Charts

Trend lines

Trend lines

Formatting Chart Elements

Formatting Chart Elements

Change Chart types

Change Chart types

Customizing Charts

Customizing Charts

Other methods of creating Charts

Other methods of creating Charts

Recommended Charts

Recommended Charts

Graphical Objects and Mathematical formulas

Graphical Objects and Mathematical formulas

Grouping Images, Screenshots and Smart Objects

Grouping Images, Screenshots and Smart Objects

Stacking order

Stacking order

Formatting Objects in Excel

Formatting Objects in Excel

Inserting Shapes, Screen Shots and Screen Clipping

Inserting Shapes, Screen Shots and Screen Clipping

Inserting Smart Objects

Inserting Smart Objects

Inserting online Images

Inserting online Images

How to create Excel Templates

How to create Excel Templates

Excel Templates

Excel Templates

Workbook protection

Workbook protection

Using the Unlocked cells function together with the Protect Sheet function

Using the Unlocked cells function together with the Protect Sheet function

Protect worksheet and Protect Workbook function

Protect worksheet and Protect Workbook function

Using the Format as a Table function

Using the Format as a Table function

Using the Custom Autofill function

Using the Custom Autofill function

Using Excel Comments

Using Excel Comments

Excel Themes

Excel Themes

Using Named Cells and Ranges

Using Named Cells and Ranges

3D Referencing

3D Referencing

Coping Formulas across Multiple Worksheets

Coping Formulas across Multiple Worksheets

Absolute Referencing

Absolute Referencing

The Count Function

The Count Function

Using the Copy Formulas and Functions Feature

Using the Copy Formulas and Functions Feature

The AutoSum Function

The AutoSum Function

Print Section

Print Section

Spell Checker

Spell Checker

Printing Different Range Selections

Printing Different Range Selections

Page Break Preview and Page Layout

Page Break Preview and Page Layout

Headers and Footers

Headers and Footers

Print Titles and Print Area

Print Titles and Print Area

Modifying Multiple Worksheets at the same time

Modifying Multiple Worksheets at the same time

Hide and Un Hide Worksheets

Hide and Un Hide Worksheets

Viewing and Scrolling Multiple Workbooks

Viewing and Scrolling Multiple Workbooks

Move or Copy Worksheets between the same Workbook or New Workbook

Move or Copy Worksheets between the same Workbook or New Workbook

Worksheet navigation and worksheet tab colors

Worksheet navigation and worksheet tab colors

Clearing Cell Contents Vs Clearing Cell Formats

Clearing Cell Contents Vs Clearing Cell Formats

Find and Replace Formats

Find and Replace Formats

The Format Painter

The Format Painter

Date Formatting

Date Formatting

Adding and Removing Borders

Adding and Removing Borders

Content Alignment and Orientation

Content Alignment and Orientation

Number Formating

Number Formating

Wrap Text and Merge and Center Function

Wrap Text and Merge and Center Function

Modifying Font Size Color

Modifying Font Size Color

Selecting cells for formatting

Selecting cells for formatting

Displaying Formulas in worksheets

Displaying Formulas in worksheets

Copying Functions and Formulas

Copying Functions and Formulas

Sum Function

Sum Function

BODMAS

BODMAS

Basic Math

Basic Math

Hide and Un Hide Function

Hide and Un Hide Function

Increasing Column Width and Row Height

Increasing Column Width and Row Height

Inserting Rows Columns and Deleting Cells

Inserting Rows Columns and Deleting Cells

Fill Function

Fill Function

Drag and Drop cells

Drag and Drop cells

Cut Copy and Paste

Cut Copy and Paste

Undo and Redo Shortcuts

Undo and Redo Shortcuts

Editing Cell Contents

Editing Cell Contents

Input Numbers as Text

Input Numbers as Text

Text Dates Numbers

Text Dates Numbers

Rename Move and Duplicate worksheets

Rename Move and Duplicate worksheets

Adding and Removing Worksheets

Adding and Removing Worksheets

Navigating Excel

Navigating Excel

Exercise Files

Exercise Files

Creating and saving a workbook

Creating and saving a workbook

Customize the Quick Access Toolbar

Customize the Quick Access Toolbar

Orientation

Orientation

The Power BI Interface & Workflow

The Power BI Interface & Workflow

Downloading Power BI & Adjusting Settings

Downloading Power BI & Adjusting Settings

Meet Power BI

Meet Power BI

Introduction

Introduction

Setting Expectations

Setting Expectations

Introducing the Course Project

Introducing the Course Project

Course Structure & Outline

Course Structure & Outline

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) -7. Single vs Double Quotes

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) -7. Single vs Double Quotes

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 6. Comments

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 6. Comments

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 5. Constants

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 5. Constants

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 4. Variables

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 4. Variables

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 3. Differences between Echo and Print

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 3. Differences between Echo and Print

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 2. Echo

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 2. Echo

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 1. Basic Syntax

PHP for Beginners - LESSON 3 (Basic Syntax and First Steps) - 1. Basic Syntax

PHP for Beginners - LESSON 2 (Installation) - 2. Installing Sublime

PHP for Beginners - LESSON 2 (Installation) - 2. Installing Sublime

PHP for Beginners - LESSON 2 (Installation) - 1. Installing Xampp

PHP for Beginners - LESSON 2 (Installation) - 1. Installing Xampp

PHP for Beginners - LESSON 1 (Introduction) - 1. Introduction

PHP for Beginners - LESSON 1 (Introduction) - 1. Introduction

P6 PPM - LESSON 9 (Earned Value Management with P6) - 4. Summary

P6 PPM - LESSON 9 (Earned Value Management with P6) - 4. Summary

P6 PPM - LESSON 9 (Earned Value Management with P6) - 3. Estimate to Complte, Activity Usage S-Curve

P6 PPM - LESSON 9 (Earned Value Management with P6) - 3. Estimate to Complte, Activity Usage S-Curve

P6 PPM - LESSON 9 (Earned Value Management with P6) - 2. Earned Value and Actual Costs

P6 PPM - LESSON 9 (Earned Value Management with P6) - 2. Earned Value and Actual Costs

P6 PPM - LESSON 9 (Earned Value Management with P6) - 1. Performance Measurement Baseline and PV

P6 PPM - LESSON 9 (Earned Value Management with P6) - 1. Performance Measurement Baseline and PV

P6 PPM - LESSON 8 (Utilities) - 6. Summary

P6 PPM - LESSON 8 (Utilities) - 6. Summary

P6 PPM - LESSON 8 (Utilities) - 5. Check In and Check Out, UN_CEFACT XML format, Online HTML Help

P6 PPM - LESSON 8 (Utilities) - 5. Check In and Check Out, UN_CEFACT XML format, Online HTML Help

P6 PPM - LESSON 8 (Utilities) - 4. Project Import and Export

P6 PPM - LESSON 8 (Utilities) - 4. Project Import and Export

P6 PPM - LESSON 8 (Utilities) - 3. Excel Import and Export Tool

P6 PPM - LESSON 8 (Utilities) - 3. Excel Import and Export Tool

P6 PPM - LESSON 8 (Utilities) - 2. Reflection Projects, Advanced Scheduling Options, Audit Trail Cls

P6 PPM - LESSON 8 (Utilities) - 2. Reflection Projects, Advanced Scheduling Options, Audit Trail Cls

P6 PPM - LESSON 8 (Utilities) - 1. Introduction

P6 PPM - LESSON 8 (Utilities) - 1. Introduction

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 5. Summary

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 5. Summary

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 4. Restoring Baselines for Multiple Projects

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 4. Restoring Baselines for Multiple Projects

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 3. F5 a& F10 for Multiple Projects

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 3. F5 a& F10 for Multiple Projects

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 2. Multiple Projects in a P6 Project

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 2. Multiple Projects in a P6 Project

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 1. Introduction

P6 PPM - LESSON 7 (Multiple Project Scheduling) - 1. Introduction

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 6. Summary

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 6. Summary

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 5. Summarizing Projects, Job Services

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 5. Summarizing Projects, Job Services

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 4. Project Codes, Filtering

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 4. Project Codes, Filtering

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 3. EPS, Project Portfolios, OBS, Urs, SP

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 3. EPS, Project Portfolios, OBS, Urs, SP

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 2. Multiple User Data Display Issues

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 2. Multiple User Data Display Issues

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 1. Introduction

P6 PPM - LESSON 6 (Managing the Enterprise Environment) - 1. Introduction

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 5. Activity Codes and UDF

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 5. Activity Codes and UDF

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 4. Summary

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 4. Summary

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 3. Activity Codes, UDFs, WBS, RCs, CA

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 3. Activity Codes, UDFs, WBS, RCs, CA

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 2. Understanding PBS

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 2. Understanding PBS

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 1. Introduction

P6 PPM - LESSON 5 (Other Methods Of Organizing Project Data) - 1. Introduction

P6 PPM - LESSON 4 (Global Change) - 5. Workshop – Global Change

P6 PPM - LESSON 4 (Global Change) - 5. Workshop – Global Change

P6 PPM - LESSON 4 (Global Change) - 4. Global Change - Summary

P6 PPM - LESSON 4 (Global Change) - 4. Global Change - Summary

P6 PPM - LESSON 4 (Global Change) - 3. More Advanced Examples of Global Change

P6 PPM - LESSON 4 (Global Change) - 3. More Advanced Examples of Global Change

P6 PPM - LESSON 4 (Global Change) - 2. Basic Concepts & Specifying the Change Statement

P6 PPM - LESSON 4 (Global Change) - 2. Basic Concepts & Specifying the Change Statement

P6 PPM - LESSON 4 (Global Change) - 1. Global Change - Introduction

P6 PPM - LESSON 4 (Global Change) - 1. Global Change - Introduction

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 6. Summary

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 6. Summary

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 5. Miscellaneous Defaults

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 5. Miscellaneous Defaults

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 4. Admin Preferences

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 4. Admin Preferences

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 3. Admin Menu

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 3. Admin Menu

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 2. User Preferences

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 2. User Preferences

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 1. Introduction

P6 PPM - LESSON 3 (User Preferences and Admin Preferences) - 1. Introduction

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 7. WBS, LOEs and Setting the BL

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 7. WBS, LOEs and Setting the BL

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 6. Summary

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 6. Summary

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 5. Limitations on Viewing BL Data

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 5. Limitations on Viewing BL Data

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 4. Setting the Baseline

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 4. Setting the Baseline

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 3. Scheduling Options – General Tab

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 3. Scheduling Options – General Tab

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 2. Understanding Date Fields

P6 PPM - LESSON 2 (Scheduling Options and Setting a Baseline) - 2. Understanding Date Fields