There are two kinds of people: Those who are masters at Excel, and those who wish they were

Description

There are two kinds of people: Those who are masters at Excel, and those who wish they were

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel 2019.

• People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 skills to create and modify spreadsheets.

Course content

• Getting Started
  • Introduction
  • Navigating the Interface
  • Selecting Data
  • Using Commands
  • Creating a New Workbook
  • Entering Cell Data
  • Using AutoFill
  • Using Flash Fill
  • using Excel Help
• Performing Calculations
  • Creating Formulas
  • Inserting Functions
  • Copying Formulas and Functions
  • Using Absolute Reference
• Modifying Worksheets
  • Inserting and Deleting Cells
  • Searching and Replacing
  • Using Proofing and Research Tools
• Formatting Worksheets
  • Applying Text Format
  • Applying Number Formats
  • Customizing Number Formats
  • Aligning Cell Contents
  • Applying Cell Styles
  • Applying Themes
  • Inserting Hyperlinks
  • Applying Conditional Formatting
  • Applying Conditional Formatting to Text and Dates
  • Applying Comparitive Analysis Formatting
  • Using Templates
• Printing Workbooks
  • Printing Workbooks
  • Setting the Page Layout
  • Inserting page Breaks
  • Configuring Headers and Footers, Part 1
  • Configuring Headers and Footers, Part 2
• Managing Workbooks
  • Managing Worksheets, Part 1
  • Managing Worksheets, Part 2
  • Creating a Custom View
  • Managing Worksheet Views
  • Managing Workbook Views
  • Managing Workbook Properties
• Customizing options
  • Customizing General Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar

Mastering_Excel_2019_-_Basics.part1.rar

Mastering_Excel_2019_-_Basics.part2.rar

Mastering_Excel_2019_-_Basics.part3.rar

Mastering_Excel_2019_-_Basics.part4.rar