• views: 187
• date: 24 August 2024
• posted by: voska89

What to Expect - How to get the best from each class, what you will need, basic assumption.
Introduction - Excel Workbook, Worksheet, Interface Explained (formula bar, rows, columns, name box ), Resizing rows and columns
Cell Referencing made easy - Relative Cell Referencing and Absolute Cell Referencing
Data Modelling Explained. Why is Excel Smart? Working with basic operators (+,*,/,-)
Conditional Formatting of Cells in Worksheet
Introduction to tables and charts - Design a budget template
Charts in Excel - Bar chart, Pie chart, Line chart, Scattered (Bubble) charts
Full chart customization, Chart elements explained, Chart styles, Format chart area
Introduction to excel functions - SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, COUNTBLANK
Working with Text functions I - "CONCATENATION" and "&" operator
Working with Text functions II - LEFT, RIGHT, UPPER, LOWER, PROPER, LEN, MID
Data Sorting, Data Filtering, Freeze Panes
Carry out Searches and Query in Excel
Smart Excel tips and skills to speed up workflow inthe work place
Lookup functions in Excel - Vertical lookup (VLOOKUP) and Horizontal lookup (HLOOKUP)
Logical Excel Functions - IF, OR, AND, Nested IF
Data summary in Excel - SUMIF, COUNTIF, SUMIFS, COUNTIFS
Using PIVOT tables as a tool to summarize data - Dicing and slicing
Data Sharing and Data Tracking in Excel - Working with comments and changes made
Budget Estimates, Financial modeling, Setting up payment schedule (loan amortization)
Requirements
You will need a Laptop or a PC with any version of Excel installed in it
No prior Excel knowledge is needed.
A relaxed mind because Excel is about to be made EASY...hahaha
Description
Some reasons why you should choose this Microsoft Excel Made Easy course
Carefully designed curriculum teaching you only the most used functionalities of Excel in school and office environments
You can complete this course within one weekend (it's just 4 hours )
Office-related and school-related examples and case studies with complementary tasks
More practical exercises because Excel requires practice
Downloadable resources
Your queries will be responded to by the
Homepage

https://www.udemy.com/course/excel-lessons-zero-to-hero-for-students-teachers-and-office-workers/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.