A must have lecture series for people using excel and who want improve their skill sets to maximize productivity, impress their boss or get a new job and overall the most important thing, analyse data effectively.
Lecture series is packed with information about formatting options, charts creations, pivot charts, slicers, logic formulas usage, data validation, excel 2016 new features, macros and vb coding for excel.
Teaches you the new things assuming you are very beginner to excel and helps you become expert in no time.
Learn from these lectures and save a lot of time about how you can get a particular thing done in excel. Stop researching and start implementing after going through this lecture series.
Bonus Pack: A lot of excel sheets with each lecture for download.
Description about various menu options in Excel.
Adding Deleting and naming Sheets in the Workbook.
Understanding entering data into excel, selecting boxes, selecting rows/ columns, modifying pre entered data, adding data on new line in the same box.
Some important Data Entry Keyboard Shortcuts.
Learn various options inside Home Tab for setting the text inside the box, making it bold,underline, italic, drwaing borders, custom borders, color borders, merging cells, copy data and paste data.
You will learn:
Adding new rows and columns to excel sheet.
Deleting rows or columns from the excel sheet.
Learn how to set rules for the cell based on the contents of cell.
How to Automatically Update the cell features based on the cell contents
Learn more in depth features of Conditional Formatting.
Adding styles to cells in sheet. Quickly adding a Heading Style to a particular Cell.
Learn to hide and unhide excel sheets.
Learn to hide and unhide rows and columns.
Learn to copy data from one cell to other cell. Learn to copy complete sheet to other workbook and in the same workbook.
Hide All unnecessary rows and columns in excel.
Learn to size cells in one go.
Learn to zoom in and zoom out.
Learn to plot stock price chart
Learn to plot Win loss data
Learn to Plot your happiness level in a bar chart using excel
Quick Updating the chart by adding filter to dataset
Bing Map: Plot a geographical overview of the sales.
Learn to Plot Pivot Table
Adding Shapes to Excel Sheet
Add various symbols like degree, micro, omega
learn character code
Insert Equation In Excel Sheet
Adding Header and Footer to Excel Sheet.
Adding Page Numbers
Add Background to excel sheet.
Adding comments to cells in excel sheet
Un-hiding, hiding, editing and deleting comments.
reviewing all comments.
Correcting Spelling errors in excel.
A new feature of Excel 2016: Inking comments / using touch feature more effectively
Basic Sum Formula
I am S N, Electronics Hardware Design Engineer with lot of passion for writing, educating people on various technologies and learning new technologies.
During my career I learned a lot of new technologies, learned about how to train people by giving various sessions to my colleagues and understood what works best for them. I have put use of my experience in building up various lecture series at Udemy.
I am sure you will like my lecture series and find them very Useful.