Video description
In this Microsoft Excel Cookbook training course, expert author Guy Vaccaro will teach you everything you need to know to work efficiently in Excel. This course is designed for users that have a basic working knowledge of Excel.
You will start by learning about dealing with time in Excel, including how to convert dates from imported data, building a timesheet calculator, and figuring out monthly sales. From there, Guy will teach you about errors in functions, creating pivot tables, working with data, and formulas. This video tutorial also covers creating charts, including creating a hyperlink, graphing with two Y axis, and display the sheetname. Finally, you will learn how to save as a CVS without warnings and create a random text string.
Once you have completed this computer based training course, you will have learned everything you need to know to work faster and more efficiently in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
Table of contents
- Introduction
-
Dealing With Time
- Welcome To Excel - Date And Time
- Formatting A Date
- Converting Dates From Imported Data
- Figuring Out Monthly Sales
- Building A Timesheet Calculator
- Working Out How Old Your Staff Are
- Calculating Dates Using Functions
- Prevent Negative Time From Displaying As Hashes
- Highlighting Dates In The Current Week Or Month
- Forcing The User To Input The Correct Time Format
- What Will The Date Be This Friday?
- Speeding Up Excel
- Errors In Functions
- VLOOKUP Speciality Cake
- Powerful Pivot Pie
-
Data Loaf
- Summing Only The Filtered Results
- Physically Changing Numbers Including Adding Leading Zeros
- Creating An Auto-List Of Your Own Departments
- Splitting A Cell By Text And Number
- Filter Unique Values From Your Data List
- Dragging Rows Or Columns To Change The Order Of Items
- Creating A Comma-Separated List From A Column Of Data
- Sorting Data By Row Values Instead Of Columns
- Autonumbering For Record Rows
- Filtering Rows By Color Rather Than By Value
- Layout Tart
- Mathematical Melange
-
Quick Quiches
- Force A Carriage Return Within A Cell
- Column Row Insertion Deletion And Hiding With The Keyboard Only
- Use A Formula To Calculate The Day Of The Week As A Name
- Searching For The Special Question Mark And Asterisk Characters In Excel
- One Command To Create A Chart
- Display The Current Sheetname On The Sheet
- Display A Yes-No Dialog Box When Running Macros
- Creating A Hyperlink
- Make Cell References Absolute Very Quickly
- Spicy Charts
- Other Clever Titbits
- The End
Product information
- Title: Microsoft Excel Cookbook
- Author(s):
- Release date: November 2015
- Publisher(s): Infinite Skills
- ISBN: 9781771375481
You might also like
book
Excel Cookbook
Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to …
video
Microsoft Excel Advanced 2019
Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led …
video
Microsoft Excel Beginners 2019
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who …
video
Microsoft Excel 2021/365 - Beginner to Advanced
Microsoft has released its latest stand-alone Excel version, which opens up many of the features and …