課程資料
課程簡介
Sum, Max, Min, Count, Counta Function, Average, IF Function, Vlookup, Drop Down list, Concatenate, Flash Fill Function
What is Excel?
Excel is a Microsoft Office software that is used to create and edit spreadsheets and perform mathematical and statistical calculations. With various features such as formula writing, graphics, images, audio, and even compiling and printing reports, Excel is used as a basic tool in many fields of work.
What is the importance of learning Excel?
It can be said that Microsoft Excel is one of the best, most popular, and most powerful software in the field of organizing, analyzing, and monitoring data. With Excel, you can easily manage, control, and even visualize the data and information you want. Working in a networked, precise, and large-scale space, in a wide-screen format with many features, including charts, formulas, functions, programming space, and dozens of other features, makes it easy to monitor and control data. We can name many areas of use for Excel. From use at home or in a shop, as a simple accounting program or phone book, to use in large companies and organizations, for organizing and analyzing information, all are possible with Excel.
Considering the importance of using data and information in all professional and personal fields, learning Excel, as a simple, powerful, inexpensive, and always available tool, has a very high priority. By learning Excel and of course other Office software (Microsoft Office), in addition to being able to perform our daily tasks in the field of data control and analysis, there is the possibility of entering the job market and taking advantage of numerous job opportunities in institutions, companies, and public and private organizations.
Excel functions empower you to do more and save time for yourself. It doesn't matter if you are a manager or a fresher if you know the excel formulas and function you can increase your productivity exponentially. If you don't, you may not Finish your work on time. So yeah, Excel functions are great tools and they deserve to be learned.
In spite of the usefulness and easiness, not everyone is good with excel functions. Actually most people don't put effort. But believe me, it worths the effort.
If you are good with these functions, you can be exceptional among your colleagues. You will be able to solve problems in minutes that will take others hours.
The Excel functions work fantastically and increase your speed of working exponentially. You can learn about 11 important excel functions here.
My main goal in this training is to increase your awareness of the top tools and functions in Excel to help you solve complex problems.
Why You Should Learn these Excel Functions:
1: Simple Calculations
2: Get the work done faster
3: Automate the repetitive task
4: Design Impressive Dashboards
5: Allows you to Visualise Data
6: Be Exceptional at Workplace
7: Work Faster With Excel Shortcuts
課程章節
- 10 個章節
- 15 堂課
- 第 1 章 Introduction
- 第 2 章 SUM
- 第 3 章 MAX Function
- 第 4 章 MIN
- 第 5 章 Multiply and an easy way to copy the formula
- 第 6 章 COUNT
- 第 7 章 COUNTA
- 第 8 章 AVERAGE
- 第 9 章 IF FUNCTION
- 第 10 章 VLOOKUP
課程內容
- Learn Excel functions from zero.
- Identify formulas and functions and know the difference between the two.
- Reduce complexity of your spreadsheets.
- Use the 11 most important Excel functions in common spreadsheet computations.
- Use the SUM, AVERAGE, MAX, IF, MIN and DROP DOWN LIST functions in Excel.
- Use the FLASH FILL function in Excel.
- Use the COUNT, VLOOK UP, COUNTA and CONCATENATE functions in Excel.
此課程所涵蓋的技能
評價
-
BBrayan Tech
I enjoyed the section dealing with Pivot table the most as it was new for me. Great course for learning MS Excel in a short time.
-
RRaul Zarix
The Hands-on exercises were great. Good to have and to go back to reference. Thank you. I gained valuable knowledge from this course. Learnt a deeper understanding of Excel.
-
GGeorgia Fewsar
It’s an excellent course even for someone who has already worked on Excel for years, since it goes back to the absolutely basics of creating, navigating within worksheets and working on some of the most fundamental concepts and functions. I am very grateful for him for having created this course to share his knowledge and experience!
-
JJoe Youngernu
It teaches commonly used formulas in the best way