The Essential Guide of Microsoft Excel 2013 for Beginners

Get up to speed with Excel - with plenty of sample exercises!
0.0 (0 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.
209 students enrolled
Instructed by Coach Sofi IT & Software / Other
$19
$35
46% off
Take This Course
  • Lectures 29
  • Length 4 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

Excel is a universal tool which allows you to organise data in an effective and efficient manner. Excel is used in investment banks to calculate the price of complex financial products, or in homes to track household expenses.

No matter what industry you are in, no matter what stage of life you are in, having knowledge in Excel will help you in some way. This course will enable and empower you to operate on Microsoft Excel with a high level of confidence.

Confused by the plethora of Excel courses on Udemy? Here is why you should take this course.

  • I am a professional coach with a decade of experience in training working adults in soft skills (such as leadership & effective communication) and hard skills (such as basic computer literacy & Microsoft Word/Excel)
  • My students consistently give high ratings for my course. Some of the feedback given is that my courses are "easy to follow", "delivered with high level of clarity".
  • I believe that the best way of learning is by doing - which is why I provide lots of sample data in this course and encourage my students to practice on these data

What are the requirements?

  • You will need Microsoft Excel 2013 installed

What am I going to get from this course?

  • Confidently and independently operate the essential features of Microsoft Excel 2013

What is the target audience?

  • This course is appropriate for for people across all industries and all levels with basic computer skills. This course is probably not for you if you're looking to learn the advanced features of Microsoft Excel 2013

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started with Excel
Pin to Taskbar and Desktop
06:07
Understanding Excel Screen
08:26
Template, Difference between workbook and worksheets and saving
14:09
Create 1st Excel Workbook, Autofit and Changing Data
07:50
Section 2: Simple Formatting
Autofill, Flashfill, Font Group
16:29
Adjust Rows and Columns, Hide and Unhide, Insert and Delete Rows and
08:28
Alignment Group
06:17
Number Format
10:03
Custom Format
12:56
Section 3: Simple Calculations
Simple Formula and Functions
Preview
10:40
Section 4: Organising Data
Copy and Paste, Cut and Paste
05:18
Sorting and Filtering
07:38
Find and Replace
08:01
Section 5: Formulas and Functions
Formulas (Add, Divide, Multiply) and Errors in Formula
09:56
Absolute Cell and Reference Cell
06:00
Functions
10:06
Text Functions
08:25
Date and Time Functions
05:18
Financial Functions
11:15
Section 6: Page Layout
Header and Footer
07:27
Page Layout (Margins and Orientation)
06:35
Page Layout (Print Area and Print Titles)
06:05
Page Layout (Scale to fit and Gridlines)
05:14
Freeze Panes
04:31
Section 7: Review
Spelling
05:30
Section 8: Charts
Charts (Creating and Moving Charts)
08:51
Charts (Font Size, Change Data Series, Change Chart Type)
08:27
Charts (Changing the Chart Title, Data Lables, Data Tables and Colo
06:37
Section 9: Pictures
Pictures and Smart Art
10:40

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Coach Sofi, Professional Trainer

My passion for training and education is fuelled by my raison d'être - to make a difference in people's life. I believe that my positive attitude, enthusiasm and energy can be rubbed on others to spur them to new heights. I strongly hold on to the adage that knowledge that is not shared, is knowledge wasted. I strongly believe in educating others as it creates a ripple effect. Once students have gained that knowledge, they will feel motivated and empowered to share with others about what they have learned. I gain immense satisfaction when I see others share the knowledge that they have gained in class and apply it in their lives.

Having been in the industry for ten years, I have gained an insightful exposure to a myriad of training methods, andragogies and pedagogies. I have been an associate trainer under the banner of various Continuing Education and Training (CET) campuses, training adults from all walks of lives in life skills such as communication skills, basic conversational English and computer literacy.

I have also been a freelance trainer under the banner of various educational consultancies, coaching students from primary school to pre-university level. I have trained on aspects of leadership, motivational skills, communication skills, cyber-wellness, study skills, financial literacy, entrepreneurship and other life skills.

One notable recent stint as an associate trainer was training a group of adults from a Community Development Council. Initially a quiet and reserved class, I managed to transform them into a rather rowdy, fun and lively bunch. By the end of the 5-day course, the participants were willing to go out of their way the help share their knowledge on computer literacy with one another. Their kind words of gratitude at the end of the course was humbling, to say the least. To quote one the participants, 'Thank you in encouraging and motivating us always, it makes a difference in our lives.' Receiving a pretty necklace as a token of appreciation helps too!

It is experiences like this that spurs me on to take on new challenges in the training industry. I achieve great satisfaction in impacting the lives of others in a positive manner. My aim is to spread the positivity in others in their journey of life-long learning.

Due to the wide spectrum of training-related skill set that I possess, coupled with my burning passion for knowledge sharing, I believe that I am an asset to any training organisation. I hope to explore more opportunities in being an established instructor on Udemy. Given the chance, I am confident that I can boost your skill set through my engaging and lively methods.

Ready to start learning?
Take This Course