Menu
  • No products in the basket.

Microsoft Excel 2013: Essentials

0( 0 REVIEWS )
413 STUDENTS
Overview Microsoft Excel 2013 Essentials demonstrates the fundamentals of entering data and creating spreadsheets, managing lists of data, creating formulas …

Overview

Microsoft Excel 2013 Essentials demonstrates the fundamentals of entering data and creating spreadsheets, managing lists of data, creating formulas & functions, formatting worksheets for print and electronic delivery, charting, data analysis, collaborating with others, automating tasks, and more.

The course provides a basic understanding of how to use the Excel 2013 essential features and functions. Excel 2013 offers new features and let you become an expert at using them. As a premier spreadsheet application, Excel 2013 will explore a number of key topics such as how to analyse numbers, track data and represent your data in a clear, graphical manner. It is easier to use than the earlier version and you are provided with powerful tools to manage data and make better decisions. Qualifying in this course will make you an attractive candidate to potential employers, as Excel is a must-have skill in an array of job roles.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

  • Who is it for?
  • Course outline
  • Course Duration:
  • Method of Assessment:
  • Certification:
  • Entry Requirement:
  • Career Path:
  • Presenter Information:
  • Job seekers
  • Graduates
  • Administrators
  • PA professionals
  • Accountants
  • Bookkeepers
  • Business Owners

This course is comprised of the following modules:

  • Module 01: Getting Acquainted with Excel
  • Module 02: Techniques for Easier Data Entry
  • Module 03: Managing Lists with Excel
  • Module 04: Basic Calculations with Formulas
  • Module 05: Calculations with Functions
  • Module 06: Functions that make Decisions
  • Module 07: Math, Statistical & Financial Functions
  • Module 08: Formatting Worksheets
  • Module 09: Managing Workbooks
  • Module 10: Data Analysis Techniques
  • Module 11: Creating Charts in Excel
  • Module 12: Pivottables & Power Views
  • Module 13: Printing a Worksheet
  • Module 14: Collaboration
  • Module 15: Automating Tasks
  • Module 16: Customizing Excel 2013

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Successful candidates will be awarded a certificate for Excel 2013: Essentials.

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Obtain the entire complex training required to learn this software which will be really useful when working in any organisation. Learn how to basically enter data to the spreadsheets, managing large numbers of data and analysing them using formulas. You will also learn to create charts and how to automate your tasks using this tool. A career with bright prospects await you with the completion of this course. According to www.payscale.uk, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrator - £17,477 per annum
  • Receptionist - £16,297 per annum
  • Bookkeeper - £20,786 per annum
  • Small Business Owner - £24,297 per annum
  • Administrative Assistant - £16,876 per annum
  • Personal Assistant - £25,144 per annum
  • Accounts Administrator - £18,669 per annum
  • Accountant - £28,571 per annum
  • Accounts Assistant - £18,876 per annum
  • Junior Accountant - £17,750 per annum

Bob Flisser has been providing computer training since the early 1980s. Since 1990, he has been engaged in consulting, technical writing, and creating multimedia presentations and print material. In 1995, when the web was new, Bob added web development to his skills. He has had several video courses published, and is the co-author of a dozen books of computer tips and shortcuts. Bob also has written courseware and magazine articles and has created and run training centers for several companies.

Course Curriculum

FREE INTRODUCTION
Excel 2013: Essentials FREE 00:00:00
1: GETTING ACQUAINTED WITH EXCEL
1. If You’re in a Hurry, Use a Template
2. What’s on the Screen
3. File Management Basics
4. Editing the Content & Structure of a Worksheet
5. Creating a Sample Worksheet
2: TECHNIQUES FOR EASIER DATA ENTRY
1. Using Auto Fill
2. Selecting an Area for Faster Data Entry
3. Using Automatic Decimals
4. Using Flash Fill
3: MANAGING LISTS WITH EXCEL
1. Sorting a List of Names & Addresses
2. Formatting & Editing a Table
3. Advanced Filter
4. Finding & Replacing Data
5. Splitting Cells
4: Basic Calculations with Formulas
1. How Do You Write a Formula?
2. Adding, Subtracting & Basic Number Formatting
3. Squaring & Cubing Numbers
4. Absolutely Understand Absolute References
5. Formatting Numbers
6. The Order of Calculations is Critical
7. Joining Cells
5: CALCULATING WITH FUNCTIONS
1. Understanding How Functions Work
2. SUM Function & AutoSum Tool
3. Adding a Whole Worksheet with Just Two Clicks
4. Calculating an Average
5. Finding the Highest, Lowest & Quantity of Values
6. Inserting, Calculating & Formatting Dates
7. Automatic Subtotals
8. Calculations across Worksheets
6: FUNCTIONS THAT MAKE DECISIONS
1. IF: Values that Depend on a Condition
2. SUMIF & AVERAGEIF: Sums & Averages That Depend on a Condition
3. VLOOKUP: Extract Data from a Table
7: MATH, STATISTICAL & FINANCIAL FUNCTIONS
1. Square Roots & Logarithms
2. Correlation, Standard Deviation, Median & Large
3. Calculating Monthly Loan Payments
4. Using Net Present Value to Evaluate an Investment
8: FORMATTING WORKSHEETS
1. Row & Column Size & Cell Alignment
2. Using & Modifying Built-in Styles
3. Analyzing Data with Conditional Formatting
4. Inserting & Modifying Pictures
5. Inserting Pictures from Online Sources
6. Drawing & Modifying Shapes
7. Using Shortcuts to Draw & Modify Shapes
8. Creating Diagrams with SmartArt
9: Managing Workbooks
1. Arranging, Inserting, Moving & Copying Worksheets
2. Freezing Row & Column Titles in Place
3. Repeating Row & Column Titles
4. Hiding & Un-hiding Rows & Columns
10: DATA ANALYSIS TECHNIQUES
1. Goal Seek
2. Creating Scenarios for Multiple What-Ifs
3. Using the Quick Analysis Tool
4. Using the Inquire Add-in to Compare Worksheets
11: CREATING CHARTS IN EXCEL
1. Creating Charts Instantly: Two Methods
2. Creating a Column Chart Manually
3. Creating a Pie Chart Manually
4. Sparklines: Miniature Charts in Cells
5. Setting Up a GeoFlow 3D Map
6. Animating a GeoFlow 3D Map
12: PIVOTTABLES & POWER VIEWS
1. Overview of PivotTables
2. Inserting a Recommended PivotTable
3. Creating a PivotTable Manually
4. Modifying a PivotTable & Filtering with Slicers
5. Creating a PivotChart
6. Creating a Power View Report
13: PRINTING A WORKSHEET
1. Print Layout, What Should Fit & How
2. Inserting Headers & Footers
3. Printing & Print Settings
14: COLLABORATION
1. Writing & Editing Comments
2. Creating PDF Documents
3. Importing & Exporting Data
4. Restricting Editing of a Workbook
5. Protecting Workbook Structure, Finalizing & Password Protection
6. Tracking Changes Other People Make to a Workbook
7. Saving a Workbook in SkyDrive, SharePoint, or Dropbox
8. Allowing Others to Modify Your Open Workbook
9. Inviting Others to Share Your Workbook
10. Sharing a Workbook on a Social Network
11. Share Workbooks on the Web with the Excel Button
15: AUTOMATING TASKS
1. Overview of Automation
2. Installing & Using Office Apps
3. Creating Macros by Recording Keystrokes
4. Editing Macros in Visual Basic for Applications
16: CUSTOMIZING EXCEL
1. Modifying the Ribbon Bar & Quick Access Toolbar
2. Setting Excel’s Options
3. Credits

Students feedback

N.A

Avarage rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Copyright © 2021 -Study365 - All rights reserved.

WhatsApp chat