Chia sẻ link đăng ký 2 khóa học rất hay về chủ đề Excel và PowerPoint
Excel – Microsoft Excel Course Beginner to Expert 2022
Beginner to Expert Level – Fundamentals, Charts, Pivot Tables, Micro, Functions, Formula & More. MS Excel 2021
What you’ll learn
- “How to properly use Excel
- Excel From Beginner to Advanced course
- Make your work faster, better and more efficient
- How to create basic and advanced formulas
- Creating Charts from your data
- Most Frequently Used Excel Functions With Examples
How to land your first job as an Excel Expert
How to use Macros
PivotTable Made Easy
Advanced Pivot Table Techniques
Improve your Microsoft Excel Skills” Source: Udemy.com
Requirements
“There is no need for any knowledge or experience on Microsoft Excel.
A laptop or smartphone with Internet access
Experience with Microsoft Excel is beneficial but not required.
Description
Microsoft Excel Version 2021
In this course you will be able to make your own calculation excel sheet.
Here attached some Resource file for your practice. share your work with me so we can be able to discuss it and review it together.
First, you should watch promotional videos and watch the free preview lessons. I think they’re going to give you a good idea of the quality of the course content, pace, and what to expect from taking the course. Apart from that, Udemy offers a 30-day money-back guarantee with no questions asked!
This Course includes:
- Introduction
- What is Microsoft Excel
- Where Excel Is Used
- Microsoft Excel Marketplace
- Microsoft Excel Fundamentals
- Microsoft Excel Startup Screen
- Creating & Save Document in Excel
- Font Styles and Size
- Data Handling Basics – Cut, Copy and Paste
- Text Wrapping and Alignment
- Dates and Times Formats
- Numbers Format
- Find and Replace
- Working With Rows and Columns (Column & Row Cells Insert, Delete, Hide, Unhide, Merge)
- Freezing Rows and Columns
- Working With Multiple Worksheets
- Saving and Printing
- Relative, Absolute, & Mixed Cell References
- Ribbon & Quick Access Toolbar
- Cell Borders and Merging
- Allow Text/Numbers Only in Excel
- Protect Ranges & Worksheets in Excel
- Save Multiple Excel Sheets in one PDF File
- Filtering and Sorting Data
- Basic Filtering
- Advanced Filtering
- Data Sorting in Excel
- Creating Charts In Excel
- Creating Charts
- Create A Bar In Bar Chart In Excel
- Progress Circle Chart in Excel
- Create Pie Chart
- Create Line Chart
- Create Column Chart
- Format Charts in Excel
- Area Chart in Excel
- Waterfall Charts in Excel
- Combination Charts In Excel
- Multi-Color Scatter Plot Chart in Excel
- Import and Export Data
- Data from Text Files
- Import Data from Web to Excel
- Transpose Data in Excel
- Parse Data in Excel Using Various Functions
- Exporting Data to Text File
- Pivot Tables
- Create a Pivot Table
- Pivot Tables Filtering
- Pivot Table Slice
- Pivot Table Grouping
- Advanced Pivot Table Techniques
- Micro
- Create Macros in Excel
- Edit a Macro in Excel
- Create Macro Buttons in Excel
- Essential Excel Functions & Formulas
- IF Formula
- AND Formula
- OR Formula
- SUM, SUMIF, SUMIFS Functions
- PERCENTAGE Functions
- TODAY Function
- NOW Functions
- CHOOSE Function
- AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS Functions
MATCH Formula - ROUND, ROUNDUP, ROUNDDOWN Formulas
- COUNT, COUNTBLANK, COUNTIF, COUNTIFS Formulas
- UPPER, LOWER Formulas
- Conclusion & Thank You
- Get Start Career in Excel
- Top Three Freelancing Jobs Website
I am sure you can do it! all you have to do is follow the lessons step-by-step!
Feel free to share any problem you are facing and i will be here to review it.
To achieve everything mentioned in this piece of advice, please enroll in this course now!
Note: Lectures are updated promptly following any modifications in Microsoft Excel.
Who this course is for:
Anyone can do to develop their career in Microsoft Excel.” Source: Udemy.com
Link đăng ký miễn phí vĩnh viễn (100 enrolls):
PowerPoint – Microsoft PowerPoint For Beginners 2023
Microsoft PowerPoint presentation that are easy to apply at your work. Become a top PowerPoint user in your Office. Source: Udemy.com
What you’ll learn
- “Get comfortable with basic and advanced PowerPoint features
Become one of the top PowerPoint users in your team
Creating & Saving presentation files
Create engaging and well-designed slides and animations
Creating Slides, Textboxes and Formatting Text & Paragraphs
Build PowerPoint templates quickly
Preparing for a live presentation
Be able to animate any kind of object and slide in PowerPoint
Make an impression at work and achieve your professional goals” Source: Udemy.com
“This course will help you to acquire the skills, information, and tools that you require to achieve your goal in the questions above. Using this course, you will be able to produce PowerPoint slides and become a more efficient and well-rounded designer.
I will show you how to create great presentation templates and slides with confidence, and I will personally guide you every step of the way. Your final outcomes will be according to their highest quality.
Great presentations feature more than simply having some eye-catching PowerPoint slides. Instead, they determine your image, personal brand, and presentation skills. Thus, you have to make the very best of them.
First, you should watch promotional videos and watch the free preview lessons. I think they’re going to give you a good idea of the quality of the course content, pace, and what to expect from taking the course. Apart from that, Udemy offers a 30-day money-back guarantee with no questions asked!
After completing this course, you will:
Understand how to efficiently operate within PowerPoint without wasting your time.
Be prepared to take advantage of top slides (also known as slide shows) and presentations to the highest possible industry standards.
Create the animations you’d like to control to your preference.
This Course includes:
- Getting Started with PowerPoint
- PowerPoint Ribbon
- PowerPoint Presentation Interface
- Navigate a PowerPoint slide
- Create New PowerPoint slide
- Saving a PowerPoint slide
- Adding Hyperlinks to PowerPoint
- PowerPoint with Text
- How to Add Text and text box in PowerPoint Slides
- How to Work PowerPoint Slide Layouts
- How to Work PowerPoint Bullet Lists
- Back Ground Slide Formatting
- How to Add Color to Slides Background
- How to Work Gradients on PowerPoint
- How to Add Image on Slide Background
- How to Apply Background Image to all Slides
- Text Formatting in PowerPoint
- Formatting Text within PowerPoint
- How to format text into columns in PowerPoint
- Adding Action Buttons to PowerPoint
- Table Formatting in PowerPoint
- Table Style Options in PowerPoint
- Create a Table with Excel Sheet In PowerPoint
- Icons Formatting in PowerPoint
- How to create Editable Icons in PowerPoint
- Charts in PowerPoint
- How to Create a Chart in PowerPoint
- Insert Excel Chart with Link in PowerPoint
- PowerPoint SmartArt
- Create PowerPoint SmartArt
- Graphic Smart Art
- Multimedia Elements to PowerPoint
- How to Insert Audio to PowerPoint
- How to Insert Video to PowerPoint
- How to Insert YouTube Video in PowerPoint
- Slide Show Time Customizing in PowerPoint
- Automatic and Click Slide Show Settings in PowerPoint
- Secure Slide in PowerPoint
- How to Lock Presentation Slide in PowerPoint
- PowerPoint Animated Project
- Animated Infographic Slide Design in PowerPoint
- Make Animated Timeline Slide in PowerPoint
- Create Animated Sales Banner in PowerPoint with Video Format
Who this course is for:
Who wants to create outstanding slides
Who wants to build engaging presentations
I will explain all basics about PowerPoint in it, So we can smoothly start real work” Source: Udemy.com
Link đăng ký vĩnh viễn (150 enrolls) cập nhật 22.11.2022:
