Master Advanced Microsoft Excel with Excel Guru
4.5 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,319 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Advanced Microsoft Excel with Excel Guru to your Wishlist.

Add to Wishlist

Master Advanced Microsoft Excel with Excel Guru

This course is focused to make students experts in advanced Microsoft Excel & help them to enhance or start a new career
4.5 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,319 students enrolled
Created by QAEversity .
Last updated 1/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 29 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Master office productivity
Master advanced MS Excel
View Curriculum
Requirements
  • No prior MS Excel knowledge required
  • No prior office or data management skill required
Description

Here's a great opportunity to take your career and computing to the next level. This course will make you a full-expert in Microsoft Excel including the most advanced Microsoft Excel skills. The course is designed from scratch to give you hands-on idea of all basic and advanced MS Excel techniques including: Excel overview, entering data, formatting, formulas and advanced functions, security, graphics, charts, vlookups, pivot tables and excel macros. Microsoft Excel gives businesses the tools they need to make the most of their data. And when it comes to making the most of resources, and maximizing return on investment, this is becoming increasingly important. Firms are collecting ever-greater volumes of data from multiple sources, including in-store-transactions, online sales and social media. They need to be able to collate and analyse this information quickly and effectively.

Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

Excel spreadsheets are commonly used across business to display financial information and other data relevant to the running of the business. This could be information relevant to the customer relationship management department, sales, marketing or HR. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns, allowing it to be sorted and filtered, and then displayed in a visual presentation.(Top 5 Benefits of Microsoft Excel, Microsoft's website)

Who is the target audience?
  • Beginners and intermediate MS Access users should take this course
  • Individuals with great passion to enhance their career should take this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 9 Lectures Collapse All 9 Lectures 28:52
+
Advanced
3 Lectures 09:06
Formulas and functions
03:48

Working with security in MS Excel
01:47

Charts
03:31
+
Where to go from here?
2 Lectures 07:00
Where to start your freelance accounting/data research career?
01:50

Signing up on top freelancing platform
05:10
About the Instructor
QAEversity .
3.7 Average rating
1,256 Reviews
13,643 Students
25 Courses
Become an expert IT Professional

About the Company:

QAEversty is a New York based IT training company that specializes in IT and Software Testing. Our team of instructors are committed to create an excellent learning experience for users that can be both affordable and easily accessible. We are focused to make software testing concepts much more easier to the audience and produce expert software test professionals.

Additional details as requested:

As one of the leading instructor and CEO of QAEversity, I am Rayan Khan, always focused on developing better learning environment for students. My expertise developed over time with bachelors and masters degrees in Information Systems Management from State University of New York (SUNY) and Devry University. I have over 5 years of experience in working as a senior software engineer and instructor in top power management and insurance companies. Since its inception, QAEversity has got very good response and popularity among software testing communities and professionals. Thousands of students from over 110 countries around the world are already taught through our website and YouTube channel. Please note that we have a team of instructors for developing different courses with expertise and this is why we are signing up with the company name. We look forward to work with Udemy.