Udemy - Mastering Excel 2019 - Basics
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.
Bu kurs kimler için uygun:
- 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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.
