Advanced MS Excel 2010 Videos Tutorial
What you'll learn
- To make you awesome in MS Excel
- Over 80 lectures and 20 hours of content!
- Get solid understanding of the more powerful features and functions in Excel
- Learn to Use Excel in a Professional Environment
- Learn Excel basics from Scratch using an Excel Case Study Approach
Requirements
- Basic Internet Knowledge
- Basic Math Calculation
Description
In Advanced MS Excel 2010 Video Tutorial, I will demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel.
You can also visualize data and get new insights into your information with Excel's charts and graphs. Learn how to create and modify charts, graphs, tables, and SmartArt to enhance your spreadsheets or other Office documents. This course covers all of the essential features needed to get up and running with these valuable Excel tools.
The IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.
This tutorial has been designed for computer users who are willing to learn Microsfot Excel in simple steps and they do not have much knowledge about computer usage and Microsoft applications. This tutorial will give you enough understanding on MS Excel from where you can take yourself at higher level of expertise.
Who this course is for:
- Users with no knowledge of Excel can also take this course
- Students and Professionals
Course content
- Preview18:53
- Preview11:36
- Preview10:46
- Preview02:49
- 15:27Don't Get Tricked By Number Formatting (number Formatting As Façade)
- 05:55Math Order Of Operations & Formulas In Excel
- 10:15How To Search For And Use Excel Functions
- 14:18Relative And Absolute Cell References And Fill Handle And Angry Rabbit
- 06:39Summarize Formula Inputs, Formulas & Stylistic Number Formatting
- 09:14Writing Numbers As Words For Checks
Instructor
![Howard Simpson](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.1 Instructor Rating
- 33 Reviews
- 858 Students
- 2 Courses
Hello! I’m Howard Simpson, a 25-year-old Electrical & Electronics Engineer, Computer expert, Blogger.
As an Electrical & Electronics Engineer, I have done several simulations and hardware projects. To name a few,
“Portable heart beat calculator” in 2008
“MPPT based solar charge controller” in 2010
"Hybrid & Intelligent Power Supply Unit for PCs" in 2012
Moreover, I helped several students in their projects to write coding for micro-controllers. My areas of interest are 'Applied electronics' and 'Micro-controllers programming and interfacing'.
As a Computer expert, I help people to troubleshoot software issues, repair / replace hardware issues by themselves and to use simple softwares for complex tasks. I’m doing this across oceans from my home using Chrome remote desktop.
As a Blogger I help my followers to manage WordPress blogs, optimize SEO, design logos, create animations, customize the look of their themes, secure their websites and ultimately to monetize them.
As a Chartered Accountant, I have been presenting so many mind-blowing presentations. They used to speak for themselves and that’s my secret of keeping my audience engaged. I'm specialized in 'Financial Management' and 'Indian Taxation'.
Above all I’m a teacher of examples. My teaching style is, breaking-down complex concepts through simple examples and animations. I go deep in whatever I learn & whatever I teach. I derive immense satisfaction in teaching the concepts, I'm expert in.
That’s why, my students call me a VERSATILE teacher! For my consistent support to my students in Udemy, I got "Lightening responder" badge.