Practical Excel 2013 Tips & Tricks
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.
26 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practical Excel 2013 Tips & Tricks to your Wishlist.

Add to Wishlist

Practical Excel 2013 Tips & Tricks

Sharpen your spreadsheet skills by learning really cool tricks you can apply at work. Save time and become a power user.
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.
26 students enrolled
Created by Optima Train
Last updated 2/2016
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • New online capabilities including Office Accounts and OneDrive cloud storage
  • Interface changes with the ribbon and touch screens
  • Basics of cell selection and data entry
  • How to use the Flash Fill feature to save hours in data entry
  • How to use Conditional Formatting to clarify worksheet data
  • How to get quick results with the Quick Analysis Lens
  • How to switch between two open worksheets with ease
  • Capturing screen shots into Excel and navigating the new Tabs interface
  • How to build a pivot table from scratch, customize and filter
  • Using Slicers to filter Pivots including the new Timeline Slicer for date filtering
  • Using Sparkline charts to create an effective chart in a single cell
  • How to create & format charts with the new touch controls
  • How to create a PDF from a worksheet
  • How to share Excel worksheets in the cloud and on social networks
  • How to have multiple people edit a worksheet at the same time online
View Curriculum
Requirements
  • Microsoft Office 2013
Description

This course covers Tips & Tricks on Microsoft Excel 2013. It assumes you have used Excel and are familiar with creating, editing & formatting worksheets. In a quick and lively manner this will cover what is new in this version of Excel and also show you some tips to increase your productivity in Excel and widen your skills.

The course begins with a review of online account options followed by interface changes in the ribbon and the use of touch screens. Some basics of cell selection are covered followed by several excellent examples of the exciting Flash Fill feature which can save hours in data entry. Conditional formatting is introduced and custom settings reviewed. Intro to tables is next with examples of sorting & filtering. The Quick Analysis Lens can help users get started quickly with analysis. A Pivot Table is built from scratch in a simple and easy to understand manner and then it is filtered using data slicers and charted with Sparkline charts. The basics of creating & editing a chart with new controls is shown and the course finishes showing the new ways you can share a worksheet in other formats, online, in the cloud and on social networks. Throughout the course the videos are quick, lively and clearly explained. If you don't have all day to spend on a course this will cover the highlights of what's new and a little bit more in about 90 minutes.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** COURSE UPDATED: February 2016 *****

Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you're a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today's economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.

Amplify your spreadsheet skills by learning a series of really neat tips and tricks that you can immediately apply at your workplace or school or home.

If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn neat Excel tricks in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!

Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…

Who is the target audience?
  • Busy Excel users of any skill level who want a quick look at what is new and can save them time. You should have basic skills in editing, formatting and working with Excel worksheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
01:39:13
+
Practical Excel 2013 Tips & Tricks
35 Lectures 01:38:14

Introduction to Excel 2013 Tips & Tricks Course

Preview 01:40

How to download Exercise Files and Handouts
00:23


Recent file list, online templates, searching online, turning off the Start Screen

Start Screen
03:38

Online services are linked to the user account, changing accounts and ribbon color

User Account
04:02

Using offline, syncing to cloud, sharing folders and SkyDrive on many other devices

SkyDrive
04:38

Viewing and editing worksheets from the browser on Windows, and iPad.

Excel Web App
02:20

Showing and hiding the ribbon, using touch mode for easy touch targets

Ribbon and Touch
02:51

Selecting & moving the active cell, filling many cells at once

Basic Cell Entry
03:03

Autofill from adjacent data and autocomplete of formulas and formatting

AutoFill
03:37

Separate a single cell of data into multiple cells by typing text and date examples

Preview 02:34

Separate data from a single cell or join data together based on examples and Ctrl+E keystroke

Flash Fill Automatic
02:54

Animation of cell selection, updated cells and updated charts

Animations
01:38

Cell shading, horizontal data bars and icons to highlights trends and extremes

Conditional Formatting
02:32

Customizing conditional formatting, removing conditional formatting

Managing Conditional Rules
03:54

Table creation, color formatting, table headers as column headers

Create and Format Tables
03:49

Apply sorts to numeric, date and text fields. Filter for one item or by date

Sort and Filter Tables
03:47

Preview and apply conditional formatting to a table with this automatic tool

Quick Analysis Lens Formatting
01:43

Preview and apply tabale totals and charts automatically

Quick Analysis Lens Totals and Charts
02:15

Each individual workbook open a separate window in Excel

One Workbook One Window
02:20

Capturing screen images into Excel and linking to web page captures

Screen Shots
03:45

Navigating, creating, coloring and moving worksheet tabs in a workbook

Worksheet Tabs
04:08

Build a PivotTable from scratch

Creating PivotTables
03:59

Apply formats and changing the layout of a PivotTable

Formatting PivotTables
03:45

Sort and filter PivotTable data for a custom report

Filtering and Sorting PivotTables
03:11

Recommended pivots show previews of selected data and create the pivot in one click

Recommended Pivots
02:06

Filtering PivtoTable data with pushbutton data slicers. Filter for multiple values

Preview 03:17

Filter PivotTable dates with a graphic timeline control

Timeline Slicer
02:24

Charts within a single cell for compact data analysis

Preview 02:53

Create a chart using recommended charts and oneclick formatting

Easy Chart Creation
02:16

Use controls adjacent to the chart to add chart elements, styles, colors and filters

Chart Format Controls
03:04

Sharing worksheets by storing online and giving access to others

Sharing Worksheets
02:45

Edit a worksheet online in a browser with multiple people at the same time

Shared Editing
02:26

Posting a shared worksheet to a social network like Facebook

Sharing to Social Networks
02:35

Sending worksheets in email and as a PDF attachment

Sending Worksheets
02:02
About the Instructor
Optima Train
4.2 Average rating
594 Reviews
4,811 Students
25 Courses
Practical Training for Today's Knowledge Worker

Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.

Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.

We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to relatively low knowledge retention, Optima Train has a results-oriented approach.